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