November 27, 2002 at 2:12 pm
I need to create an alert when there is table blocking lasting more than X and or a resource semaphore on SQL 7.0
Any ideas?
November 27, 2002 at 5:49 pm
I'm not sure you can do exactly what you're trying to do in SQL Server 7.0. What Microsoft typically recommends is to run a check every five minutes to capture what is blocking.
Here's Microsoft's article on setting up monitoring for blocking. This one is geared for SQL Server 2000, the link for SQL Server 7 is still broken:
http://support.microsoft.com/default.aspx?scid=kb;en-us;271509
You can also build views and develop your own monitoring methods. But this gives you a start. There are also some MS articles in their knowledge base about using Profiler to help monitor activity.
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
K. Brian Kelley
@kbriankelley
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply