http://www.sqlservercentral.com/blogs/useful-information-and-case-studies-covering-data-warehousing-data-modeling-and-business-intelligence/2012/08/28/parallel-data-warehouse-pdw-how-to-check-database-size-with-dbcc_pdw_showspaceused/
Printed 2013/05/19 05:56PM
Parallel Data Warehouse (PDW) How-To: Check Database Size with DBCC_pdw_showspaceused
There is a way to view the size of a particular PDW database using the DBCC_pdw_showspaceused command via the NEXUS query editor. Executing the steps below will allow the developer to view sizes (in Mb) for the following columns:
Reserved_Space
Data_Space
Index_Space
Unused_Space
PDW_Node_ID
Follow the steps below in NEXUS query editor:
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.