Solved

how to check data size in all db in QA

Posted on 2006-11-08
5
266 Views
Last Modified: 2012-06-27
Hi,
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?
0
Comment
Question by:motioneye
  • 3
5 Comments
 
LVL 75

Expert Comment

by:Aneesh Retnakaran
ID: 17896575
sp_helpDb

or

Exec SP_MSForEachTable "sp_SpaceUsed"
0
 
LVL 75

Expert Comment

by:Aneesh Retnakaran
ID: 17896590
or else

SP_MSForEachTable "SELECT * FROM SysFiles "
0
 
LVL 75

Accepted Solution

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


Exec SP_MSForEachDB "use ? ;Exec sp_SpaceUsed"

Exec SP_MSForEachDB "use ? ;SELECT * FROM SysFiles "
0
 

Author Comment

by:motioneye
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
0
 
LVL 42

Expert Comment

by:EugeneZ
ID: 17897533
try :  dbcc showfilestats

Automated Server Information Gathering - Part 3
By Steve Jones

http://www.databasejournal.com/features/mssql/article.php/1467771
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

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

For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
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.

910 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

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now