Home Dashboard Directory Help
Search

ICE01: How to determine easily the database size by lavitabella


Status: 

Active


1
0
Sign in
to vote
Type: Bug
ID: 721670
Opened: 1/30/2012 6:24:34 PM
Access Restriction: Public
0
Workaround(s)
view
0
User(s) can reproduce this bug

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