May 27, 2009 at 2:00 am
Dear All,
Can anyone brief me how to use "ACTIVITY MONITOR" ?.
I am seeing 2 processes in "Locks by Process" and about 70 processes in "Locks by Object" sections.
Infact my SQL server went very slow all of sudden. What should I do now..?
How can I findout the processess which I need to kill.?
Thanks.
May 27, 2009 at 2:14 am
In Activity monitor see the columns BlokedBy and Blocking in process info...
This will tell you what is blocking or bloked by the processes....
Check out ;]
http://msdn.microsoft.com/en-us/library/cc879320.aspx%5B/url%5D
Tanx 😀
May 27, 2009 at 2:19 am
Thanks for quick reply.
Sorry, I forgot to mention my SQL Server version.
It's SQL Server 2005+SP2.
The link which you have given is for SQL Server 2008.
Thanks.
May 27, 2009 at 9:43 am
SAN, Killing the SPID or the process is just a temporary solution. This could happen again and again. The best would be to tackle the problem and find out the root cause for it.
Did you check if there were dead locks? Or was it just blocking?
-Roy
May 28, 2009 at 3:10 am
Did you check if there were dead locks? Or was it just blocking?
Can we find it out from Activity Monitor itself.?
May 28, 2009 at 7:33 am
It is better to put -T 1204 in your start up parameters and restart SQL Engine if you can so that even if you are not there to monitor it, you can see it in your SQL Logs. It will give the details of what is deadlocking with what. That is a recommended way.
Or you can use the profiler to catch the dead locks.
-Roy
May 29, 2009 at 8:00 pm
Is there a way to see the top blocking to kill...i had probrably 100 blocks on the database yesterday and it became very hard to see which one to kill first.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply