ICE01: How to determine easily the database size - by lavitabella

Status : 


Sign in
to vote
ID 721670 Comments
Status Active Workarounds
Type Bug Repros 0
Opened 1/30/2012 6:24:34 PM
Access Restriction Public


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
Sign in to post a comment.
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.