नोट
इस पृष्ठ तक पहुंच के लिए प्राधिकरण की आवश्यकता होती है। आप साइन इन करने या निर्देशिकाएँ बदलने का प्रयास कर सकते हैं।
इस पृष्ठ तक पहुंच के लिए प्राधिकरण की आवश्यकता होती है। आप निर्देशिकाएँ बदलने का प्रयास कर सकते हैं।
Applies to: 
Azure Synapse Analytics
Analytics Platform System (PDW)
Displays the size and number of rows for each partition of a table in a Azure Synapse Analytics or Analytics Platform System (PDW) database.
Transact-SQL syntax conventions
Syntax
--Show the partition stats for a table
DBCC PDW_SHOWPARTITIONSTATS ( "[ database_name . [ schema_name ] . ] | [ schema_name. ] table_name" )
[;]
Note
This syntax is not supported by serverless SQL pool in Azure Synapse Analytics.
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: Azure Synapse Analytics and Analytics Platform System (PDW)
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 AdventureWorksPDW2022 database.
DBCC PDW_SHOWPARTITIONSTATS ("ssawPDW.dbo.FactInternetSales");
DBCC PDW_SHOWPARTITIONSTATS ("dbo.FactInternetSales");
DBCC PDW_SHOWPARTITIONSTATS (FactInternetSales);