We help IT Professionals succeed at work.

We've partnered with Certified Experts, Carl Webster and Richard Faulkner, to bring you a podcast all about Citrix Workspace, moving to the cloud, and analytics & intelligence. Episode 2 coming soon!Listen Now

x

how to check data size in all db in QA

motioneye
motioneye asked
on
Medium Priority
298 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?
Comment
Watch Question

AneeshDatabase Consultant
CERTIFIED EXPERT
Top Expert 2009

Commented:
sp_helpDb

or

Exec SP_MSForEachTable "sp_SpaceUsed"
AneeshDatabase Consultant
CERTIFIED EXPERT
Top Expert 2009

Commented:
or else

SP_MSForEachTable "SELECT * FROM SysFiles "
Database Consultant
CERTIFIED EXPERT
Top Expert 2009
Commented:
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 "

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts

Author

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
EugeneZ ZhitomirskySQL SERVER EXPERT
CERTIFIED EXPERT

Commented:
try :  dbcc showfilestats

Automated Server Information Gathering - Part 3
By Steve Jones

http://www.databasejournal.com/features/mssql/article.php/1467771
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.