Get Alerts For Long Running Queries By Duration

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.

https://app.box.com/s/wu781ut4unptz6li5k6k6ymjff975jbf