Results 1 to 7 of 7

Thread: SQL server 2000 block analysis

Hybrid View

  1. 10-23-2005, 03:58 PM #1
    kit_reddy
    kit_reddy is offline Registered User
    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.
    Reply With Quote Reply With Quote
  2. 10-23-2005, 07:54 PM #2
    MAK's Avatar
    MAK
    MAK is offline Registered User
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254
    what software?
    My Site:http://www.mssqlengineering.com
    My Book:http://www.wiley.com/WileyCDA/WileyT...470477288.html
    Reply With Quote Reply With Quote
  3. 10-23-2005, 08:37 PM #3
    kit_reddy
    kit_reddy is offline Registered User
    Join Date
    Oct 2005
    Posts
    5
    it is called Microsoft operations manager 2005
    Reply With Quote Reply With Quote
  4. 10-24-2005, 09:34 AM #4
    rmiao
    rmiao is offline Registered User
    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.
    Reply With Quote Reply With Quote
  5. 10-24-2005, 10:05 AM #5
    skhanal
    skhanal is offline Experts
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    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.
    Reply With Quote Reply With Quote
  6. 10-24-2005, 12:39 PM #6
    kit_reddy
    kit_reddy is offline Registered User
    Join Date
    Oct 2005
    Posts
    5
    it is SP4 on SQL 2K
    Reply With Quote Reply With Quote
  7. 10-24-2005, 01:22 PM #7
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    MOM should give you more info of that blocking process.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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