The recording of top SQL queries for Oracle and MS SQL Server databases has long been an integral part of the Herrmann & Lenz Monitoring Module. With the help of this powerful feature, specific SQL queries can be identified that may be the cause of any performance bottlenecks that may arise. In addition to the actual SQL query, additional information and performance indicators are recorded and clearly displayed. E.g. sort queries according to the number of executions, the disk reads or disk writes caused or the CPU times. The display of the respective execution plan and the comparison of the runtimes of the SQL queries in the past supports you in the efficient elimination of any performance problems.

The historical view of the top SQL queries for any time period is new. With the help of this new function, you can also analyze SQL queries that were long ago. Of course, all additional information and performance indicators are also available to you.

If you would like to know more about this topic, we would be glad if you contact us or give us a call +49 2174/30710 0.