August 7, 2008 at 6:09 am
Hi
i want to know the database growth per month so that i can planned for hardware maintainence:)
cheers,
syed.
August 7, 2008 at 6:51 am
You can write a scheduled job which inserts the data of the database file sizes into a table. Schedule the job to work every month or what ever the period you want to have.
The database growth rate should not be taken just with one month's data. You need to allow the database to stabilize. (Initially, the database growth may depend mainly on setup related data. Later it will move towards transactional data. Also it depnds on the usage of the people.)
Cheers,
Prithiviraj Kulasingham
http://preethiviraj.blogspot.com/
August 7, 2008 at 7:29 am
If you need this data in retrospect, you may be able to dig out stuff from your default trace on 2005. You can run
SELECT *
FROM FN_TRACE_GETTABLE('C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\log.trc',
DEFAULT)
WHERE EventClass = 92
AND DatabaseID = DB_ID()
GO
(you may need to change the path, depending on where your instance is installed)
This will find the automatic file growths for the current database. It will not include information about the amount the file has grown, but I assume this has not changed for your database, so you can find that out. Note that you will have several entries per filegrowth.
Regards,
Andras
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply