45 lines (38 loc) · 1.76 KB

title

SQL Server, ExecStatistics Object | Microsoft Docs

ms.custom

ms.date

06/13/2017

ms.prod

sql-server-2014

ms.reviewer

ms.suite

ms.technology

dbe-cross-instance

ms.tgt_pltfrm

ms.topic

article

helpviewer_keywords

SQLServer:ExecStatistics

ExecStatistics object

ms.assetid

4f8557a8-345f-4622-a8a5-763a0388ad94

caps.latest.revision

13

author

craigg-msft

ms.author

craigg

manager

jhubbard

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

Monitor Resource Usage (System Monitor)