Skip to content

Latest commit

 

History

History
48 lines (41 loc) · 1.94 KB

File metadata and controls

48 lines (41 loc) · 1.94 KB
title SQL Server, ExecStatistics Object | Microsoft Docs
ms.custom
ms.date 03/01/2017
ms.prod sql
ms.prod_service database-engine
ms.component performance-monitor
ms.reviewer
ms.suite sql
ms.technology
database-engine
ms.tgt_pltfrm
ms.topic conceptual
helpviewer_keywords
SQLServer:ExecStatistics
ExecStatistics object
ms.assetid 4f8557a8-345f-4622-a8a5-763a0388ad94
caps.latest.revision 14
author MikeRayMSFT
ms.author mikeray
manager craigg

SQL Server, ExecStatistics Object

[!INCLUDEappliesto-ss-xxxx-xxxx-xxx-md] 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)