Skip to content

set-statistics-profile-transact-sql.md

Latest commit

 

History

History
66 lines (50 loc) · 3.05 KB

set-statistics-profile-transact-sql.md

File metadata and controls

66 lines (50 loc) · 3.05 KB
title SET STATISTICS PROFILE (Transact-SQL)
description SET STATISTICS PROFILE (Transact-SQL)
author WilliamDAssafMSFT
ms.author wiassaf
ms.date 06/10/2016
ms.service sql
ms.subservice t-sql
ms.topic reference
ms.custom
ignite-2025
f1_keywords
PROFILE
SET_STATISTICS_PROFILE_TSQL
PROFILE_TSQL
SET STATISTICS PROFILE
helpviewer_keywords
profiles [SQL Server], displaying
statements [SQL Server], profile information
SET STATISTICS PROFILE statement
STATISTICS PROFILE option
statistical information [SQL Server], profiles
dev_langs
TSQL

SET STATISTICS PROFILE (Transact-SQL)

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

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

:::image type="icon" source="../../includes/media/topic-link-icon.svg" border="false"::: 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)