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. |