Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Database growth Expand / Collapse
Author
Message
Posted Monday, February 18, 2008 4:14 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Saturday, September 12, 2009 9:12 PM
Points: 65, Visits: 224
Hi,

I need to find the Database growth while doing reindexing the Db
i have 2 Dbs including the Temp db and one more Db,
How do i find out the growth

regds
Shine
Post #456851
Posted Monday, February 18, 2008 4:17 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Friday, August 1, 2014 6:18 AM
Points: 1,618, Visits: 20,980
The Stored procedure which is already available on this site might serve your purpose.

http://www.sqlservercentral.com/scripts/Maintenance+and+Management/31929/


Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
Post #456852
Posted Monday, February 18, 2008 4:21 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, January 26, 2012 5:26 AM
Points: 1,367, Visits: 1,585
You can look at the size and growth columns in sys.database_files before and after the reindexing.

Regards,
Andras




Andras Belokosztolszki, MCPD, PhD
GoldenGate Software
Post #456853
Posted Tuesday, February 19, 2008 1:58 PM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Thursday, May 22, 2014 11:56 AM
Points: 472, Visits: 854
If your using SQL Server 2005 SP2 and have the default trace enabled still you can Right click the database choose "Reports" > "Disk Usage" , that will tell you the increments for the autogrow feature for all files and logs.
Post #457629
Posted Wednesday, April 27, 2011 7:46 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, August 6, 2014 8:08 AM
Points: 1, Visits: 279
I would use the Report "Disk Usage" on the Reporting Server (url).
You have a downloadlink for this report?

Post #1099446
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse