dotTrace
 
Get dotTrace

SQL Queries

Last modified: 04 June 2024

The SQL Queries event shows time intervals where your application communicates with an SQL server. This includes time required for opening and closing connections, running commands, performing queries, and other SQL activities. Note that all measurements are performed on the client side  – dotTrace measures the time between a client sending a request and it receiving a response.

Select the SQL Queries event to analyze how your app accesses data. For example, a web application may run slowly due to a bottleneck in SQL server communication. In such a case, you can use the SQL Queries filter to determine the slowest queries and methods that run these queries.

After you select the SQL Queries event, you can fine-tune the result with the SQL Queries: Command and SQL Queries: Connection String sub-filters.