SQL Server Performance Forum – Threads Archive
current activity not respondingHi, We have a peculiar problem with our SQL server. I got a call from some of our developers that they were not able to access the server, when i logged on to the system, I observed unusually high number of thread in the server. usually the number of thread on our server would be between 25 to 40, but today it shows me more than 80 threads and when i tried to expand the current activity container bucket ( inorder to kill some threads) the EM is not responding. I tried so many times to close the connection and open it again and tried to expand the current activity bucket but its just going blank on me. I am able to expand all other buckets in the server except this one.Usually i use citrix meta fram to connect to the server , when i do so and run sp_who command, its showing a very large number of threads under my login id (29), when i closed the citrix and re connect to the server using remote desktop connection, its showing that there are 2 threads under my login name (which is normal). can any one shed some light on where the problem might be and how to resolve it?? Thanks,
Why not use Query Analyzer and run sp_who and sp_who ‘active’? Part of the problem with EM is that it will make a number of connections to SQL Server and keep them active, so it’s not exactly helping with regards to your problem. If you make a connection in QA, it’s just the one connection and nothing more.
the sp_who2 is returning 37 rows and sp_who ‘active’ is returning 25 rows. now the jobs are running extreamly slowely, i cannot see where the problem is. also why am i not able to expand current activity bucket?? can u please help??
Hi,<br /><blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><i>Originally posted by vijaygarapati</i><br /><br />the sp_who2 is returning 37 rows and sp_who ‘active’ is returning 25 rows.<br /><br />now the jobs are running extreamly slowely, i cannot see where the problem is. also why am i not able to expand current activity bucket?? can u please help??<br /><hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote"><br /><br />sp_who ‘active’ shows only those processes that are not idle.<br />run sp_who2 for any blocking event and then <br />run dbcc inputbuffer(spid) –where spid is a blocking spid <br />this way you can rectify the blocking id / event if any.<br />and run a profiler for long running transaction….<br /><br />[<img src=’/community/emoticons/emotion-1.gif’ alt=’‘ />]<br />Regards<br /><br />Hemantgiri S. Goswami<br />[email protected]<br />"Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemantgiri Goswami<br />
Do not check CURRENT ACTIVITY from Enterprise Manager, if the SQL server is already stressed with issues then it will addup more performance glitch.# Best to use Query analyzer using above statements. Satya SKJ
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.