Take a look at the profiler. You can trace for locks using that.

John

-----Original Message-----
From: anthony.[Email Address Removed] [mailto:anthony.[Email Address Removed]
Sent: Wednesday, May 28, 2003 4:17 PM
To: LazyDBA.com Discussion
Subject: Auto alert for locking.....

Guys.

I am after an automatic way to trigger an alert if there is an excess
amount of locking in the database..

Is there a sp_ or some sort of monitor I can create to do this?

Just briefly I can think of having a stored proc that queries the same
fields sp_lock does, at 30sec intervals..

Is there a better way?


Thanks for your help.
__________________________________________
Anthony Hand
DBA | Systems Integration
Aon Risk Services Australia Ltd
Ph: +61 2 9253 7516
Fax: +61 2 92537952
Mob: +61 415 877 988



---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed]MS Sql Server LazyDBA home page