Skip to content

set-statistics-profile-transact-sql.md

Latest commit

 

History

History
69 lines (53 loc) · 3.31 KB

set-statistics-profile-transact-sql.md

File metadata and controls

69 lines (53 loc) · 3.31 KB
description SET STATISTICS PROFILE (Transact-SQL)
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.reviewer
ms.technology t-sql
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
author markingmyname
ms.author maghan

SET STATISTICS PROFILE (Transact-SQL)

[!INCLUDE SQL Server SQL Database]

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

Topic link icon Transact-SQL Syntax Conventions

Syntax

  
SET STATISTICS PROFILE { ON | OFF }

[!INCLUDEsql-server-tsql-previous-offline-documentation]

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)