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 2014/07/22 03:41PM

Parallel Data Warehouse (PDW) How-To: Check Database Size with DBCC_pdw_showspaceused

By sal.deloera, 2012/08/28

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-2014 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.