Skip to content

dbcc-pdw-showpartitionstats-transact-sql.md

Latest commit

 

History

History
73 lines (52 loc) · 2.93 KB

dbcc-pdw-showpartitionstats-transact-sql.md

File metadata and controls

73 lines (52 loc) · 2.93 KB
title DBCC PDW_SHOWPARTITIONSTATS (Transact-SQL)
description DBCC PDW_SHOWPARTITIONSTATS displays the size and number of rows for each partition of a table in Azure Synapse Analytics or Analytics Platform System (PDW).
author rwestMSFT
ms.author randolphwest
ms.date 12/05/2022
ms.service sql
ms.subservice data-warehouse
ms.topic reference
dev_langs
TSQL
monikerRange >= aps-pdw-2016 || = azure-sqldw-latest

DBCC PDW_SHOWPARTITIONSTATS (Transact-SQL)

[!INCLUDEapplies-to-version/asa-pdw]

Displays the size and number of rows for each partition of a table in a [!INCLUDEssazuresynapse-md] or [!INCLUDEssPDW] database.

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

Syntax

--Show the partition stats for a table
DBCC PDW_SHOWPARTITIONSTATS ( "[ database_name . [ schema_name ] . ] | [ schema_name. ] table_name" )
[;]

Note

[!INCLUDEsynapse-analytics-od-unsupported-syntax]

Arguments

"[ database_name . [ schema_name ] . | schema_name . ] table_name"

The one, two, or three-part name of the table to be displayed. For two or three-part table names, the name must be enclosed with double quotes (""). Using quotes around a one-part table name is optional.

Permissions

Requires VIEW SERVER STATE permission.

Result sets

This set is the results for the DBCC PDW_SHOWPARTITIONSTATS command.

Column name Data type Description
partition_number int Partition number.
used_page_count bigint Number of pages used for the data.
reserved_page_count bigint Number of pages reserved for the partition.
row_count bigint Number of rows in the partition.
pdw_node_id int Compute node for the data.
distribution_id int Distribution identifier for the data.

Examples: [!INCLUDEssazuresynapse-md] and [!INCLUDEssPDW]

A. DBCC PDW_SHOWPARTITIONSTATS basic syntax examples

The following examples display the space used and number of rows by partition for the FactInternetSales table in the [!INCLUDEssawPDW] database.

DBCC PDW_SHOWPARTITIONSTATS ("ssawPDW.dbo.FactInternetSales");
DBCC PDW_SHOWPARTITIONSTATS ("dbo.FactInternetSales");
DBCC PDW_SHOWPARTITIONSTATS (FactInternetSales);

See also