-
SQL server 2000 block analysis
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.
-
-
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.
-
-
MOM should give you more info of that blocking process.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|