Database & File Growth Monitoring

Can someone point me to examples of database & file growth monitoring.

I specificially want to monitor a number of separate SQL servers (2000, 7.0)

I want to end of with statistics of any size changes on any of these over time.

Help is greatly appericated..

thanks

You can write script to chech db and file size, and save the result in table. Then schedule to run the script.

do u have the written script with you? if so do u mind to pass it on to me please..

thanks

Actually I am writing an article on this. But here is sneak preview of the base concept behind it.


set quoted_identifier on
go
create table #dbsizemonitor (servername varchar(128), name varchar(128), filename varchar(1000),Size int)
go
sp_msforeachdb "insert into #dbsizemonitor(Servername,name,filename,size) select @@servername,name,filename,size from ?.dbo.sysfiles"
go
select * from #dbsizemonitor
go

Hi Mak,

Your query give the file size of the data and log file..

what i need is actual data size. Is that possible help is very much appericated..

thanks

jessie.

sp_msforeachdb 'sp_spaceused'