Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
dewacorp.alliances
452 Posts |
 Posted - 2008-03-05 : 16:21:49
|
Hi allInstead of the business people telling us, is there any way to monitor blocking all the time by automatically sending an alert or something? I used the sp_block_pss80 (http://support.microsoft.com/default.aspx?scid=kb;en-us;271509) stored procedure but that is more for troubleshooting if things happen. I guess I can run the following thing to run continuously but I reckon this is over kill:WHILE 1=1BEGIN EXEC master.dbo.sp_blocker_pss80 -- Or for fast mode -- EXEC master.dbo.sp_blocker_pss80 @fast=1 -- Or for latch mode -- EXEC master.dbo.sp_blocker_pss80 @latch=1 WAITFOR DELAY '00:00:15'ENDGO Anyone?Thanks |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-05 : 23:03:26
|
| Possible with third party sql monitoring tools. |
 |
|
|
dewacorp.alliances
452 Posts |
|
|
|
|
|
Monitoring Blocking