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?
 
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
All Courses

From novice to tech pro — start learning today.