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.


1
0
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

Description

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.