set-statistics-time-transact-sql.md

title	description	author	ms.author	ms.date	ms.service	ms.subservice	ms.topic	f1_keywords	helpviewer_keywords	dev_langs
SET STATISTICS TIME (Transact-SQL)	SET STATISTICS TIME (Transact-SQL)	WilliamDAssafMSFT	wiassaf	06/10/2016	sql	t-sql	reference	SET_STATISTICS_TIME_TSQL SET STATISTICS TIME	statistical information [SQL Server], statement processing time [SQL Server], statement processing statistics SET STATISTICS TIME statement STATISTICS TIME option statements [SQL Server], statistical information parsing [SQL Server], SET STATISTICS TIME statement compile times [SQL Server] execution processing time [SQL Server]	TSQL

SET STATISTICS TIME (Transact-SQL)

[!INCLUDE SQL Server Azure SQL Database Azure SQL Managed Instance]

Displays the number of milliseconds required to parse, compile, and execute each statement.

:::image type="icon" source="../../includes/media/topic-link-icon.svg" border="false"::: Transact-SQL syntax conventions

Syntax

  
SET STATISTICS TIME { ON | OFF }  

Remarks

When SET STATISTICS TIME is ON, the time statistics for a statement are displayed. When OFF, the time statistics are not displayed.

The setting of SET STATISTICS TIME is set at execute or run time and not at parse time.

Microsoft [!INCLUDEssNoVersion] is unable to provide accurate statistics in fiber mode, which is activated when you enable the lightweight pooling configuration option.

The cpu column in the sysprocesses table is only updated when a query executes with SET STATISTICS TIME ON. When SET STATISTICS TIME is OFF, 0 is returned.

ON and OFF settings also affect the CPU column in the Process Info View for Current Activity in [!INCLUDEssManStudioFull].

Permissions

To use SET STATISTICS TIME, users must have the appropriate permissions to execute the [!INCLUDEtsql] statement. The SHOWPLAN permission is not required.

Examples

This example shows the server execution, parse, and compile times.

USE AdventureWorks2022;  
GO         
SET STATISTICS TIME ON;  
GO  
SELECT ProductID, StartDate, EndDate, StandardCost   
FROM Production.ProductCostHistory  
WHERE StandardCost < 500.00;  
GO  
SET STATISTICS TIME OFF;  
GO  

Here is the result set:

SQL Server parse and compile time:   
   CPU time = 0 ms, elapsed time = 1 ms.  
SQL Server parse and compile time:   
   CPU time = 0 ms, elapsed time = 1 ms.  
  
(269 row(s) affected)  
  
SQL Server Execution Times:  
   CPU time = 0 ms,  elapsed time = 2 ms.  
SQL Server parse and compile time:   
   CPU time = 0 ms, elapsed time = 1 ms.  
  

See Also

SET Statements (Transact-SQL)
SET STATISTICS IO (Transact-SQL)