Monitoring Blocked SPID's in SQL Server 2000

Posted on 2004-11-15
Last Modified: 2011-10-03
I want have SQL send me a message whenever we have a Blocked SPID.  Is there a counter in the performance monitor that can monitor that for me so that it can send me a message whenever it has a blocked SPID?
Question by:Summit-IT
    LVL 12

    Accepted Solution

    Hope this article will give you some idea on it:
    LVL 7

    Assisted Solution

    You can set an alert to fire with these charactistics:
    Type = SQL Server event alert
    Error Number = 60001  (msg is SPID %s is blocked by SPID %t).

    However I much prefer the method posted by geotiger. Blocking locks are a normal part of database activity. The majority of them are of short duration and no interest. The advantage of geotiger's method is that only long duration locks are captured.

    Scott Pettman

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Find Ransomware Secrets With All-Source Analysis

    Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

    Introduction: I have seen many questions on EE and elsewhere, asking about how to find either gaps in lists of numbers (id field, usually) ranges of values or dates overlapping date ranges combined date ranges I thought it would be a good …
    Creating and Managing Databases with phpMyAdmin in cPanel.
    Video by: Steve
    Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
    Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    12 Experts available now in Live!

    Get 1:1 Help Now