This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
FAQ
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Trigger alerts for Slow database queries

Gogi
Helper

‎29 Aug 2022 01:04 PM - last edited on ‎29 Aug 2022 02:24 PM by Community Team

Hi,

Please let me know whether it possible to trigger custom alerts for Slow database queries.

I tried with below steps

 

Created custom metric , metric name: DB-Statements-RT-GT-5ms

 

Gogi_1-1661774146749.png

 

2: used above metric in Data Explorer to build query to 

Gogi_2-1661774301716.png

 

Gogi_3-1661774347508.png

 

3.used code to create "Custom Alert"

calc:service.db_statements_rt_gt_5ms:filter(and(or(in("dt.entity.service",entitySelector("type(service),entityName.equals(~"sto_intranet~")")),in("dt.entity.service",entitySelector("type(service),entityName.equals(~"sto_internet~")"))))):splitBy("dt.entity.service",Dimension):avg:auto:sort(value(avg,descending)):limit(10)

 

Gogi_4-1661774474322.png

 

4: Alert preview shows Zero alerts dont know why, 

 

Gogi_5-1661774507608.png

 

please help me to configure alerts to trigger custom alert when DB query Response time is above 5ms, it would be great if it show queries along with alerts,

please let me know if there are any other approaches also.

 

 

Labels:
0 Kudos
Reply
1 REPLY 1

Gogi
Helper

‎29 Aug 2022 01:47 PM

 

I got the Problems created now, please let me know whether I can link the specific queries breaching theshold ?

Gogi_0-1661777055241.png

 

0 Kudos
Reply
Ask a question

Featured Posts