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 countersDescription
Distributed QueryStatistics relevant to execution of distributed queries.
DTC callsStatistics relevant to execution of DTC calls.
Extended ProceduresStatistics relevant to execution of extended procedures.
OLEDB callsStatistics relevant to execution of OLEDB calls.

Each counter in the object contains the following instances:

ItemDescription
Average execution time (ms)Average execution time of the selected type of execution.
Cumulative execution time (ms) per secondAggregated execution time per second, of the selected type of execution.
Execs in progressNumber of execs in progress of the selected type of execution.
Exec started per secondNumber of exes started per second of the selected type of execution.

Monitor Resource Usage (System Monitor)

Show: