Show TOC

SQL StatementsLocate this document in the navigation structure

Use

The SQL Statements monitor is based on information from the SQL Server procedure cache. You can access this screen using transaction DBACOCKPIT and navigating to Performance → SQL Statements.

Features

The main screen shows a list of SQL statements, which according to the information in the SQL Server cache have placed the highest load on the server based on various criteria.

You can enter two pieces of information to provide various views of the SQL Server cache:

  1. The value to sort by (in descending order).

    You can choose the elapsed time, total logical reads for example. This value is chosen using a dropdown list box, which initially contains a default.

  2. The number of rows selected from the server.

    Default is 300.

There are several functions that you can use to provide a detailed analysis of a statement. Choose SQL statement or double-click on a line to display the full statement text. Choose Explain to display the execution plan.