Disclaimer:Hey Guys, this post contains affiliate link to help our reader to buy best product\service for them. It helps us because we receive compensation for our time and expenses.
Note: Best viewed in Internet Explorer 6 and above
Implementation: How to get alerts for long running queries by duration.
Scenario: Assume,you are asked to put alerts crossing threshold on SQL server to intimate whenever there is long running queries hit on server
Infrastructure:The below query/procedure has been run/tested successfully on sql server 2005,2008,2008 R2 and 2012/2014.
Kindly find the below link for the same.