set-statistics-profile-transact-sql.md

title	SET STATISTICS PROFILE (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	06/10/2016
ms.prod	sql
ms.prod_service	database-engine, sql-database
ms.component	t-sql|statements
ms.reviewer
ms.suite	sql
ms.technology	t-sql
ms.tgt_pltfrm
ms.topic	language-reference
f1_keywords	PROFILE SET_STATISTICS_PROFILE_TSQL PROFILE_TSQL SET STATISTICS PROFILE
dev_langs	TSQL
helpviewer_keywords	profiles [SQL Server], displaying statements [SQL Server], profile information SET STATISTICS PROFILE statement STATISTICS PROFILE option statistical information [SQL Server], profiles
ms.assetid	c635e262-35fa-421a-aa6f-a1c30f351647
caps.latest.revision	34
author	edmacauley
ms.author	edmaca
manager	craigg

SET STATISTICS PROFILE (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2008-asdb-xxxx-xxx-md]

Displays the profile information for a statement. STATISTICS PROFILE works for ad hoc queries, views, and stored procedures.

Transact-SQL Syntax Conventions

Syntax

  
SET STATISTICS PROFILE { ON | OFF }  

Remarks

When STATISTICS PROFILE is ON, each executed query returns its regular result set, followed by an additional result set that shows a profile of the query execution.

The additional result set contains the SHOWPLAN_ALL columns for the query and these additional columns.

Column name	Description
Rows	Actual number of rows produced by each operator
Executes	Number of times the operator has been executed

Permissions

To use SET STATISTICS PROFILE and view the output, users must have the following permissions:

• Appropriate permissions to execute the [!INCLUDEtsql] statements.

• SHOWPLAN permission on all databases containing objects that are referenced by the [!INCLUDEtsql] statements.

For [!INCLUDEtsql] statements that do not produce STATISTICS PROFILE result sets, only the appropriate permissions to execute the [!INCLUDEtsql] statements are required. For [!INCLUDEtsql] statements that do produce STATISTICS PROFILE result sets, checks for both the [!INCLUDEtsql] statement execution permission and the SHOWPLAN permission must succeed, or the [!INCLUDEtsql] statement execution is aborted and no Showplan information is generated.

See Also

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