Page History

The statement is a major consumer of MS-SQL resources. By tuning the statement, you can free resources needed by other statements and processes.

The statement consumed more than 50% of MS-SQL batch resources. By tuning the statement, you can free resources needed by other statements and processes.

The statement or batch has an operator that accesses the object and shows a high cost percentage.

During SQL Server optimization, missing indexes were identified for one or more statements or batch. This means there can be one or more indexes, but they are not used because of a mismatch of column types. The SQL Server optimizer recommended creating indexes to improve the performance of the statement or batch. Detailed information regarding the index recommendation for this statement or batch can be found in the Recommend tab of the SQL tab.

The Missing Statistics warning was issued by the SQL Server optimizer when the access plan was created. This means that the SQL Server optimizer recommends creating and updating the statistics on objects accessed by a specific statement or batch. Detailed information on missing statistics for this statement or batch can be found in the Recommend tab in the SQL tab.

The average In MS-SQL time increased after an object change. Check the changes and how they affected the statement or batch execution time.

Statement resource consumption was increased by n% as a result of an increase in its executions.

The average In MS-SQL time of the statement increased following a major change in table size.

The SQL Server resources consumed by the statement increased by

n%.

Much of the statement or batch time was spent waiting for a lock. Regular locks can be categorized as follows:

• During the blocker session, a locked statement or batch ran for a short period of time. Afterwards the session was idle or continued running other statements or batches. In this case, it is possible to identify the blocker session, but not necessarily the blocker statement or batch.
• During the blocker session, a locked statement or batch ran for a long period of time. Identifying the blocker statement or batch is easier in this case.

Total In MS-SQL time of the statement was consistently high and reached the thresholds of the top statements.

A collapsed statement includes several statements that use the same text, but not the same constants.

A set of collapsed statements constitute a major consumer of MS-SQL resources.

Statement resource consumption was increased by n% as a result of an increase in its executions.