DBCC PDW_SHOWPARTITIONSTATS (Transact-SQL)

**APPLIES TO:** ![no](media/no.png)SQL Server ![no](media/no.png)Azure SQL Database ![yes](media/yes.png)Azure SQL Data Warehouse ![yes](media/yes.png)Parallel Data Warehouse

Displays the size and number of rows for each partition of a table in a SQL Data Warehouse or SQL Data Warehouse Parallel Data Warehouse database.

Topic link icon Transact-SQL Syntax Conventions (Transact-SQL)

Syntax

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

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 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 allocated to the partition.
row_count	bigint	Number of rows in the partition.
pdw_node_id	int	Compute node for the data.
distribution_id	int	Distribution id for the data.

Examples: [!INCLUDEssSDW] 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 **AdventureWorksPDW2012** database.

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