cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

How to get DB top 10 query wait states in AppD dashboard.

Hi Team,

I want to get DB top 10 query wait states in AppD dashboard. Kindly suggest.

4 REPLIES 4

Cansel.OZCAN
Maker

Hi Ashok,

I you have Analytics you can use ADQL in order create Top 10 query wait states widgetdb query.jpg

 

Thanks

Cansel

Hardik .Makwana
New Poster

@Cansel.OZCAN  I have analytics, but it is still not showing. Can you please tell me the query for getting the top 10 sessions by weight widget? 

Hi Hardik,

You can use this ADQL as a simple

SELECT `wait-state-id`, (`wait-state-id`) FROM dbmon_wait_time

This query gathers data based on "wait state id" but you can change this query based on "wait state name" 

 

For Example wait state id 59 = Using CPU

CanselOZCAN_0-1713275623338.png

Thanks

Cansel

 

Hardik .Makwana
New Poster

Hello Cansel,

I did the same, but it is showing me a syntax error. Please find the attachment below.Screenshot from 2024-04-17 09-48-19.pngScreenshot from 2024-04-17 10-16-45.png