ICE01: How to determine easily the database size by lavitabella

Active

Type:	Bug
ID:	721670
Opened:	1/30/2012 6:24:34 PM
Access Restriction:	Public

Workaround(s)

view

User(s) can reproduce this bug

Currently, I don't see a way to determine the database size, request to provide statements to check the database size by following:
- replicated
- distributed
- log size

Details (expand)

English

SQL Server 2008 R2 - Parallel Data Warehouse Edition

SQL Server PDW

Windows Server 2008 (all editions)

US English

There is no way to determine the database size using PDW statements

There is no such way retrieve DB size either via PDW statements or by database properties

Either via PDW statements or by database properties, there must be a way to provide easily get the database size within a few seconds:
by following:
- replicated
- distributed
- log size

0 attachments

Posted by Microsoft on 3/12/2012 at 2:08 PM

We are concurrently in the process of gathering and prioritizing the feedback of all TAP customers. After we have finalized this process, we will know for which coming post-AU3 PDW release we are aiming for. Thanks for your patience.

Posted by Artin Avanes on 2/9/2012 at 1:49 PM

A PDW user can use a DBCC command: DBCC PDW_SHOWSPACEUSED to display the number of rows, disk space reserved, and disk space used for a table in a corresponding database. Doing so for all replicated and then all distributed tables gives you the data you are looking for. However, we will consider and discuss a more user-friendly way of providing this information for next major PDW releases.

Microsoft