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 |
|
jharwood
Starting Member
41 Posts |
 Posted - 2001-06-26 : 16:02:49
|
| Hi,I am having a cpu and response issue on my system. When I use sp_who2 active, there is an entry for sp_reset_connection. This is an extended stored procedure. It is usually either runnable or dormant in the sp_who2 window, but holding cpu utilization. If I kill it, my system goes back to normal. I can't find any info on it. I am running sql2k on win2k in an active/passive cluster. Dual 733's on both servers with 2b ram. My avg utilization during peak time is 30% so I am well under any limits. Any information would be appreciated. Thanks-Josh |
|
|
|
|
|
extended proc named 'sp_reset_connection