Printable View
I get the following alert frequently, when iam monitoring the server with the software provided by microsoft
SQL server 2000 block analysis . The program has been blocked for 1 min on the database DIM in the SQL instance MSSQL server. The defined acceptable blocking threshold is 1 min is running on SPID as login ram and is blocked by SPID22
Can someone please tel me what to do in order to correct this error.
what software?
it is called Microsoft operations manager 2005
Run 'sp_who2 active' on sql server to see which query blocks others, then try optimize the query.
What service pack do you have in SQL 2K. We also monitor waittime and we have seen such alerts more frequently after installing SP4, but according to what I have read everywhere there is no reason for SP4 to do that.
it is SP4 on SQL 2K
MOM should give you more info of that blocking process.