Show database size info across an instance

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Richard Douglas » Show database size info across an instance

Show database size info across an instance

Rate Topic

Display Mode

Topic Options

Author

Message

RichardDouglas

Posted Monday, August 02, 2010 10:57 PM

SSC Eights!

Group: General Forum Members
Last Login: Thursday, June 13, 2013 3:50 AM
Points: 969, Visits: 652

Comments posted to this topic are about the item Show database size info across an instance

Hope this helps,
Rich

Post #962585

Matt Whitfield

Posted Tuesday, August 03, 2010 4:29 AM

Mr or Mrs. 500

Group: General Forum Members
Last Login: Friday, February 15, 2013 7:29 AM
Points: 509, Visits: 718

Just to note, OBJECT_SCHEMA_NAME was actually introduced in SQL Server 2005 SP2...

Atlantis Interactive - SQL Server Tools
My blog
Why I wrote a sql query analyzer clone

Post #962701

Pei Zhu-415513

Posted Tuesday, August 03, 2010 8:03 AM

Ten Centuries

Group: General Forum Members
Last Login: Yesterday @ 8:13 PM
Points: 1,053, Visits: 2,799

not sure why you used dbo.sysfiles i/o sys.database_files.

Post #962830

bouarroudj Mohamed

Posted Tuesday, August 03, 2010 3:34 PM

SSC Journeyman

Group: General Forum Members
Last Login: Friday, June 14, 2013 6:49 AM
Points: 90, Visits: 131

You can use this free tool
http://www.sqldbtools.com/Tools.aspx?ProductId=3

Post #963154

DLRDBA

Posted Friday, August 06, 2010 12:48 PM

Grasshopper

Group: General Forum Members
Last Login: Tuesday, March 27, 2012 11:08 AM
Points: 16, Visits: 134

Very useful script. I have been doing some sp_spaceused manually to collect this data until I could write this, thanks for sharing a workable solution. I did run this on 2008 and 2005 version 9.00.4035.00 without any modification. Thanks again.

Post #965407

RichardDouglas

Posted Saturday, August 07, 2010 3:41 AM

SSC Eights!

Group: General Forum Members
Last Login: Thursday, June 13, 2013 3:50 AM
Points: 969, Visits: 652

Hi all,

Thanks for your replies, I've not been able to respond before due to illness.

Matt: That's really interesting, I'll bear that in mind, thanks.

Pei Zhu: This is the way that MS chose to write the code inside sp_spaceused.

DLRDBA: Glad this worked for you.

Rich

Hope this helps,
Rich

Post #965536

msvoboda

Posted Thursday, August 26, 2010 1:55 PM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, April 11, 2013 9:12 AM
Points: 2, Visits: 52

Getting this error when I run on SQL Server 2008:

Msg 156, Level 15, State 1, Line 24
Incorrect syntax near the keyword 'END'.
Msg 102, Level 15, State 1, Line 37
Incorrect syntax near 'DECLARE
EXEC sp_MSforeachdb
@pages BIGINT -- Working variable for size calc.
,@dbname SYSNAME
,@dbsize BIGINT
,@logs'.

Post #975923

RichardDouglas

Posted Thursday, August 26, 2010 4:41 PM

SSC Eights!

Group: General Forum Members
Last Login: Thursday, June 13, 2013 3:50 AM
Points: 969, Visits: 652

Hi,

It appears that there is a parenthesis ")" missing after DATA_COMPRESSION = PAGE

Rich

Hope this helps,
Rich

Post #976014

« Prev Topic | Next Topic »

Permissions