Month: February 2017

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.

Dear Visitors!
To get Best Deals and Discounts Buy Now from Amazon just by
Clicking This Image

Simply send snap of your product details after delivery at ad22092012@gmail.com for more surprises or additional discounts
 

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