SQL Server Performance Forum – Threads Archive
Alert based on Blocked Process Threshold
According to BOL you can configure an Alert based on the the Blocked Process Threshold configuration parameter, but I’m having some problems figured out how to do this. Can anyone give me some direction??? Thanks!Can you please the reference to your BOL configuration what you are talking… Check the following article… you can write your own alert with the help of this article…
How to monitor blocking in SQL Server 2005 and in SQL Server 2000
http://support.microsoft.com/kb/271509
MohammedU.
Microsoft SQL Server MVP
Moderator
SQL-Server-Performance.com All postings are provided “AS IS†with no warranties for accuracy.
SQL Server 2005 Books Online blocked process threshold Option Use the blocked process threshold option to specify the threshold, in seconds, at which blocked process reports are generated. The threshold can be set from 0 to 86,400. By default, no blocked process reports are produced. This event is not generated for system tasks or for tasks that are waiting on resources that do not generate detectable deadlocks. For more information about deadlock detection, see Detecting and Ending Deadlocks. You can define an alert to be executed when this event is generated. So for example, you can choose to page the administrator to take appropriate action to handle the blocking situation.
http://www.quepublishing.com/articles/article.asp?p=686168&seqNum=3&rl=1 fyi and also DMVs will help you, refer
http://sqlserver-qa.net/blogs/perft…g-list-for-the-objects-indexes-using-dmv.aspx Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
@http://www.askasqlguru.com/ This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
Thanks for the links, but what I’m looking for is a way to set up a SQL Alert based on the blocked process threshold parameter. BOL says it is possible, but I can;t find any information on how to go about setting it up. Thanks
http://searchsqlserver.techtarget.com/tip/1,289483,sid87_gci1162653_tax301334,00.html?adg=301324&bucket=ETA see this. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
@http://www.askasqlguru.com/ This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
]]>