Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-08-21 : 09:46:29
|
| Steve writes "Hi,My trace logs for a 6.5 system are showing that the duration of Disconnection has increased from 1 second or less all the way up to an average of 3 seconds and as high as 20 seconds. What happens during disconnection, and why would it take longer? The number of users hiting this system has recently increased. Performance once a user is in the system is as quick as ever, but users now have trouble connecting on the first attempt; the nature of the application is it connects, runs a stored proc that updates some data in .01 sec or less, and then disconnects. Typically there are 50-70 user connections at any moment. NT performance stats show high CPU use, high paging and disk activity; but again, performance once you are in the db is as good as ever. There are no blocking locks.What can be the root cause of the problem? Again, what happens during a disconnect?" |
|
|
|
|
|
disconnects taking too long, some connections refused