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-06-28 : 09:07:34
|
| Josh writes "Hello,I am running sql2k on nt2k and have had some strange issues with the extended stored procedure 'sp_reset_connection'. I can't find any documentation on this from Microsoft. When we are having unusually high cpu activity, I will run sp_who2 active. This xp is always in the list either runnable or dormant, but holding cpu utilization. When I kill it, cpu goes back to normal and clients response time goes back to normal. I am running a active/passive cluster on some dells with 2 733mhz processors on each server and 2gb ram.Any information would be appreciated. Thanks-Josh" |
|
|
|
|
|
Strange xp named sp_reset_connection