Results 1 to 7 of 7

Thread: SQL server 2000 block analysis

  1. #1
    Join Date
    Oct 2005
    Posts
    5

    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.

  2. #2
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254

  3. #3
    Join Date
    Oct 2005
    Posts
    5
    it is called Microsoft operations manager 2005

  4. #4
    Join Date
    Sep 2002
    Posts
    5,938
    Run 'sp_who2 active' on sql server to see which query blocks others, then try optimize the query.

  5. #5
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,922
    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.

  6. #6
    Join Date
    Oct 2005
    Posts
    5
    it is SP4 on SQL 2K

  7. #7
    Join Date
    Sep 2002
    Posts
    5,938
    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
  •