cancel
Showing results for 
Search instead for 
Did you mean: 
Create Post

Query Anomaly Detection

Query Anomaly Detection

We recently had a query take 10000x longer to complete due to poor statistics plan. We would love the ability to have alerting based on query timing jumping up such a high ammount.

1 Comment
Level 10

That is a really interesting idea.  For SQL server if it is enabled, Query store kind of is intended to detect (and if configured, respond to) plan regressions where a new plan results in sub-optimal performance. But stale statistics would not necessarily result in a new plan. Oracle DB I believe you need to have purchased an additional feature for similar functionality.  So the idea has a lot of merit, especially since DPA is already tracking most queries over time.  I was trying to think how I would roll my own... it is easy to setup a custom metric that would focus on notification for specific query or queries that match a specific pattern, but... notifying for any jumps in execution time for any queries, that would take someone with more expertise than me.  One of the gurus like @aLTeReGo might have more insights...