Connection failure and timeouts 
Author Message
 Connection failure and timeouts

I am desperate. Our client machines (Mix of 98 and W2K)
connect to SQL2000 server. Most of the time, all is well.
If we try to run a rather large process (800 records
culled from 65,000 records with most of the CPU time done
on the client machine) my other clients will get time-out
errors or Connection problems. Now, the specifics:

There are only 45 clients.
Server is a W2K Server (SP2) running SQL2000; 1Gh PIII;
512mgs RAM
Running NetGear FS524 switches (5x 24 port each)

My question is: Why?

I have set Client connection limit to 0 (Unlimited)
Set connection timeout to 0 (unlimited)
Set max # of threads to 2400

Have no clue!! Killing me...please help.


Sat, 22 May 2004 06:04:31 GMT
 [ 1 post ] 

 Relevant Pages 

1. Connection failure and timeout issues

2. Connection failure and Timeout expired errors

3. connection failure timeout causes SP failure

4. SqlServer - ODBC - Multiple connections cause Connection is busy and Timeout expired

5. Specify connection timeout in connection string

6. Detecting Failure by Timeout

7. Communications Link Failure - Timeouts with no Cluster

8. Timeout Expired and Communication link failure

9. SQL*Net V2, timeout on network failures

10. Communication link failure and Timeout expired

11. slow syncs - timeout failures

12. ODBC timeout expired error - catastrophic failure

Powered by phpBB® Forum Software