Monitoring Blocked SPID's in SQL Server 2000

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?

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.

Among the most obnoxious of Exchange errors is error 1216 – Attached Database Mismatch error of the Jet Database Engine. When faced with this error, users may have to suffer from mailbox inaccessibility and in worst situations, permanent data loss.

If you try to migrate from Elastix to Issabel, you will face a lot of issues. These problems are inevitable but fortunately, you can fix them. In the guide below, I will explain how I performed the migration while keeping all data and successfully t…

This is a high-level webinar that covers the history of enterprise open source database use. It addresses both the advantages companies see in using open source database technologies, as well as the fears and reservations they might have.
In this…

In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB.
To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…