Call Us: US - +1 845 478 5244 | UK - +44 20 7193 7850 | AUS - +61 2 8005 4826

Analyze Network Traffic

Query Reporting via APM Solutions

One of the great features of many application performance management (APM) tools is their ability to track SQL queries. For example, Retrace tracks SQL queries across multiple database providers, including SQL Server.

Retrace can tell you how many times a query has been executed, how long it takes on average, and what transactions are calling it. This is really valuable information for SQL performance tuning.

APM solutions collect this data by doing lightweight performance profiling against your application code at runtime.

Below is a screenshot from Retrace’s application dashboard that shows for a particular application, which SQL queries take the longest.

SQL Performance Tuning With Retrace Top Queries


Retrace collects performance statistics about every single SQL query being executed. You can search for specific queries to hunt down potential problems.

Retrace View All SQL Queries


By selecting an individual query, you can see how often that query is called over time and how long it takes. You can also see what web pages use the SQL query and how their performance is impacted by it.