Grouped SQL Events

Data Access has been discontinued. Please refer to this page for more information.

Grouped SQL Events

The Grouped SQL Events tab page groups all events by SQL Statement.

Here you can find information about:

SQL Statement - the complete SQL statement.
Count - how many times the current SQL statement is executed.
First Seen - the first time when the current SQL statement is executed.
Sum Duration (ms) - the total duration of all SQL statements.
Max - the maximum duration of a SQL statement.
Min - the minimum duration of a SQL statement.
Avg - the average duration.
Sum Rows - the total number of rows returned (fetched) by all queries.
Max - the maximum number of rows returned (fetched) by a query.
Min - the minimum number of rows returned (fetched) by a query.
Avg - the average number of rows returned (fetched) by a query.

The context menu for the selected row in the Grouped SQL Events grid exposes the following actions:

Go To LINQ Statement - navigates to the corresponding LINQ record in the LINQ/API Events. This command in disabled for the parent row, it is available only for the child rows.
Go To SQL Statement - navigates to the related SQL query in the SQL Events.