Database incident rules
Hello
Recently I created an incident to capture/trigger notification for High SQL query execution count
This incident rule sends me notification when Query X has been executed more than say …100 times
When I drill down to see which purepath is responsible for this SQL query….. well… I see a list of purepaths… so if query X is used by multiple Apis , dynatrace just adds up execution count from all the Apis using same query which looks bad by total count but not necessary bad because there are bunch of Apis are involved in that count
What I am trying to achieve is …send notification only when Query X is executed more than 100 time by a single purepath.
Currently I don’t see any option in incident rules where I can configure Query execution by a single purepath only.
Please help
Thanks
Nabi Shajeed
Hi Shajeed,
Add your Measure as the filter of a Business Transaction. Then, base your incident on that BT, selecting the PurePath Response Time. Edit the condition so that 1 is the upper severe (you may need to erase the upper warning). Set the aggregation to count and the threshold to severe, with an evaluation timeframe of 10s and you should be all set.
Thanks Richard
If i followed you correctly... would this only profile/flag a selected/targeted purepath or any purepath(s) with high number of query execution?
Thanks
