Is it possible to have a report showing the most time consuming queries made on the system?
I came across a query which would take 500ms, the query would run between 4 to 10 times depends on user settings, resulting in a bad response time. This did help to detect missing indexes on the DB.
Solved! Go to Solution.
Hi @Gregory B.,
Yes it is go to the database service that you are interested in, in the service list. Click the View all database statements button. In the resulting Database activity screen, simply click the Response time median vs slowest 10% column. The list will then show the slowest database statements. Does that help?