Infrastructure (Server, Network, Database)

cancel
Showing results for 
Search instead for 
Did you mean: 

Bad Query Plan alerting with SQL Server databases

Highlighted

Bad Query Plan alerting with SQL Server databases

I am looking for advice on statistics or methods to focus and alert on "bad query plans" that cause queries to stall or take much longer.  I'll plan on looking into the plethora of stats that are raised for SQL databases but wanted to get advice overall for anyone else looking to tackle this problem and setup alerting for it.

 

Thanks.

Doug

Tags (2)
Bad Query Plan alerting with SQL Server databases