Problems On Heavy Load

Mar 31, 2008

Hi,

When running a test against SQL Server 2005 Express most of the connections work fine, but some don't. I get that Exception;

When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

It seems to me I am reaching some kind of limitation. What can I do to increase the number of connectionst?

Regards, Jean

View 8 Replies

Timout - SQL Not Responding Under Heavy Load

Apr 1, 2005

Hi,
Our app uses an NT4 SQL 2k box and a Win2k IIS box. To fulfill the text searching requirements we've had to use dynamic SQL (created within a large SP). This query searches about 8000 rows in a flat table (which we create and keep up to date using a scheduled SP which trawls the underlying tables). It's a complicated SP, and can return all 8000 rows (I think we're winning the battle to have this capped though).
When we get about 50 users hitting the app and doing searches simultaneously, performance drops severely (20 secs+ for a query rather than ~2 secs), and we get a lot of errors - which report that:
Source: .Net SqlClient Data ProviderMessage: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
We also get a lot of Invalid Viewstate errors, which i'm totally baffled by, and the odd IIS Access Denied error - as if authentication (NTLM) is timing out.
Neither the Web not the SQL machines are being hit very hard - the web server in particular is not under any strain whatsoever.
It doesn't appear to be related to connection pooling, from the logged error messages we're getting.
Does anyone have ANY suggestions as to where I should be looking?!

View 3 Replies View Related

Heavy Fragmentation

May 8, 2007

I'm attempting to debug some query timeouts on a production server.

Several tables involved in this query have logical scan fragmentation levels around 10%, and extent scan fragmentation levels 90%+.

Running INDEXDEFRAG or DBREINDEX reduces the logical scan fragmentation down to almost 0%, but the extent scan fragmentation stays upwards of 90%.

Why? What can I do to get this fragmentation down? Is it because this particular index is on a GUID?

View 7 Replies View Related

Coping Data Into A New DB With Heavy Constrants

Mar 21, 2007

I'm trying to take data and push it into a new database.

This data was taken from a database where there were many contraints, FK etc. quite a complicated structure and now sent to us with just the data in the tables with none of these constraints, FK!!

This data now needs pushing into the original database structure, so all the data will live within the constraints, but using an insert SPROC throws some FK errors, what is the best way to push this data into it's structure!

somebody suggested DTS but this doesn't take into account the constraints, also we need to run this at anytime for a number different datasets. Can anybody help ?(if you can decipher my explantion)

Many thanks for reading, please indicate if you need more info.

Shrew