Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17


how to check data size in all db in QA

Posted on 2006-11-08
Medium Priority
Last Modified: 2012-06-27
I know that dbcc sqlperf (log space) will display all the use size and % left for trans log file on every db's, so how about to check the data size? is there any similar dbcc command for to check data size?
Question by:motioneye
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
LVL 75

Expert Comment

by:Aneesh Retnakaran
ID: 17896575


Exec SP_MSForEachTable "sp_SpaceUsed"
LVL 75

Expert Comment

by:Aneesh Retnakaran
ID: 17896590
or else

SP_MSForEachTable "SELECT * FROM SysFiles "
LVL 75

Accepted Solution

Aneesh Retnakaran earned 1000 total points
ID: 17896599
> Exec SP_MSForEachTable "sp_SpaceUsed"
>SP_MSForEachTable "SELECT * FROM SysFiles "

Exec SP_MSForEachDB "use ? ;Exec sp_SpaceUsed"

Exec SP_MSForEachDB "use ? ;SELECT * FROM SysFiles "

Author Comment

ID: 17897196
this is great, unfortuantely I only want particulary data size, as we know dbcc sqlperf (log space) will only show us the % of log size, so I also want the same for data size
LVL 43

Expert Comment

by:Eugene Z
ID: 17897533
try :  dbcc showfilestats

Automated Server Information Gathering - Part 3
By Steve Jones

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
What if you have to shut down the entire Citrix infrastructure for hardware maintenance, software upgrades or "the unknown"? I developed this plan for "the unknown" and hope that it helps you as well. This article explains how to properly shut down …
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

722 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question