February 18, 2008 at 4:14 am
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
February 18, 2008 at 4:17 am
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
February 18, 2008 at 4:21 am
You can look at the size and growth columns in sys.database_files before and after the reindexing.
Regards,
Andras
February 19, 2008 at 1:58 pm
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.
April 27, 2011 at 7:46 am
I would use the Report "Disk Usage" on the Reporting Server (url).
You have a downloadlink for this report?
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply