Database & File Growth Monitoring

[jessie9000]

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

[rmiao]

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

[jessie9000]

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

thanks

[MAK]

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

[jessie9000]

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.

[MAK]

sp_msforeachdb 'sp_spaceused'