how to check data size in all db in QA

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?
motioneyeAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Aneesh RetnakaranConnect With a Mentor Database AdministratorCommented:
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
 
Aneesh RetnakaranDatabase AdministratorCommented:
sp_helpDb

or

Exec SP_MSForEachTable "sp_SpaceUsed"
0
 
Aneesh RetnakaranDatabase AdministratorCommented:
or else

SP_MSForEachTable "SELECT * FROM SysFiles "
0
 
motioneyeAuthor Commented:
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
 
Eugene ZCommented:
try :  dbcc showfilestats

Automated Server Information Gathering - Part 3
By Steve Jones

http://www.databasejournal.com/features/mssql/article.php/1467771
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.