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

Status : 

  Won't Fix<br /><br />
		Due to several factors the product team decided to focus its efforts on other items.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.

Sign in
to vote
ID 721670 Comments
Status Closed 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.