The Statement Mode view includes queries that are presented exactly as they are collected by the Query Monitor Trace.

If queries appear on the Query Monitor views that you never want to appear, click Configure Query Monitor > Advanced and enter the applications, databases or SQL text you want to exclude from the Query Monitor collection.

The Statement Mode view is where you go to drill-down into a specific execution of a particular query. Whereas the signature mode view provides a filtered look at your queries, the Statement Mode view provides all the detail you may need to diagnose a specific problem with a query. Once you find the problem query, History mode allows you to track the query over time and view trends.

The primary focus of the Statement Mode view is in the charts. The chart type drop-down allows you to pick a chart type to display, while the chart category drop-down allows you to choose to view the data by SQL Text, Application, Database, User, or Host. Click a query in a chart to open up the query history for that query.

Use Query filters to narrow the results to only those that most interest you. Do this by selecting the data and time range, the application, user, database, workstation and even the SQL text you want to include or exclude from your results.

Event Occurrences is a listing of each occurrence of the query and the associated statistics, such as the duration, CPU time, reads, writes, and associated SQL text.

If Query Monitor is disabled but Activity Monitor is enabled, SQL statements appearing in the Event Occurrences grid come from the Blocking Session collector. The collector only populates the following fields: Query, SQL text, Event Type, and Deadlocks.

The Include incomplete queries filter in the Statement Mode view is disabled by default.  If you would like to include data with null values in this view, select this check box in the Filters section of the main query view.

Access the Statement Mode view

You can open the Statement Mode view of the SQL Diagnostic Manager Queries tab by selecting the appropriate SQL Server instance, and then clicking Queries > Statement Mode

Query Diagnosis

In the Statement Mode view you can run a query diagnosis and receive a list of performance recommendations.

Sigma (Σ) character

The Sigma character indicates that the data in this row is at least partially composed of aggregated data. This means that the data is condensed into a day-length summary and some precision about the individual statements, client computers, and users is suppressed. Rows on this view with the Sigma character may include a mix of aggregated and non-aggregated data.  

Understanding cell colors

Red in the column indicates that the data in that row represents 20 percent or more of the total data displayed in the list, while yellow indicates that the data in the row represents five percent or more of the total data displayed in the list.

SQL Diagnostic Manager identifies and resolves SQL Server performance problems before they happen. Learn more > >