| title | DBCC PDW_SHOWPARTITIONSTATS (Transact-SQL) | Microsoft Docs | |
|---|---|---|
| ms.custom | ||
| ms.date | 07/17/2017 | |
| ms.prod | sql-non-specified | |
| ms.reviewer | ||
| ms.service | sql-data-warehouse | |
| ms.suite | ||
| ms.technology |
|
|
| ms.tgt_pltfrm | ||
| ms.topic | language-reference | |
| dev_langs |
|
|
| caps.latest.revision | 10 | |
| author | barbkess | |
| ms.author | barbkess | |
| manager | jhubbard |
[!INCLUDEtsql-appliesto-xxxxxx-xxxx-asdw-pdw_md]
Displays the size and number of rows for each partition of a table in a [!INCLUDEssSDW] or [!INCLUDEssPDW] database.
Transact-SQL Syntax Conventions (Transact-SQL)
-- Syntax for Azure SQL Data Warehouse and Parallel Data Warehouse
Show the partition stats for a table
DBCC PDW_SHOWPARTITIONSTATS ( " [ database_name . [ schema_name ] . ] | [ schema_name.] table_name ")
[;] [ 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.
Requires VIEW SERVER STATE permission.
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. |
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); DBCC PDW_SHOWEXECUTIONPLAN (Transact-SQL)
DBCC PDW_SHOWSPACEUSED (Transact-SQL)