SQL Server, ExecStatistics Object

The SQLServer:ExecStatistics object in Microsoft SQL Server provides counters to monitor various executions.

This table describes the SQL Server Exec Statistics counters.

SQL Server Exec Statistics counters

Description

Distributed Query

Statistics relevant to execution of distributed queries.

DTC calls

Statistics relevant to execution of DTC calls.

Extended Procedures

Statistics relevant to execution of extended procedures.

OLEDB calls

Statistics relevant to execution of OLEDB calls.

Each counter in the object contains the following instances:

Item

Description

Average execution time (ms)

Average execution time of the selected type of execution.

Cumulative execution time (ms) per second

Aggregated execution time per second, of the selected type of execution.

Execs in progress

Number of execs in progress of the selected type of execution.

Exec started per second

Number of exes started per second of the selected type of execution.

See Also

Concepts

Monitor Resource Usage (System Monitor)