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

Grouped SQL Events

This article is relevant to entity models that utilize the deprecated Visual Studio integration of Telerik Data Access. The current documentation of the Data Access framework is available here.

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.

Context Menu Operations

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.