Skip to content

dbcc-pdw-showpartitionstats-transact-sql.md

Latest commit

 

History

History
70 lines (59 loc) · 2.96 KB

dbcc-pdw-showpartitionstats-transact-sql.md

File metadata and controls

70 lines (59 loc) · 2.96 KB

title: "DBCC PDW_SHOWPARTITIONSTATS (Transact-SQL) | Microsoft Docs" ms.custom: "" ms.date: "07/17/2017" ms.prod: "" ms.prod_service: "sql-data-warehouse, pdw" ms.reviewer: "" ms.service: "sql-data-warehouse" ms.component: "t-sql|database-console-commands" ms.suite: "sql" ms.technology:

  • "database-engine" ms.tgt_pltfrm: "" ms.topic: "language-reference" dev_langs:
  • "TSQL" caps.latest.revision: 10 author: "barbkess" ms.author: "barbkess" manager: "craigg" ms.workload: "Inactive" monikerRange: ">= aps-pdw-2016 || = azure-sqldw-latest || = sqlallproducts-allversions"

DBCC PDW_SHOWPARTITIONSTATS (Transact-SQL)

[!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.

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 [!INCLUDEssawPDW] database.

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

See also

DBCC PDW_SHOWEXECUTIONPLAN (Transact-SQL)
DBCC PDW_SHOWSPACEUSED (Transact-SQL)