Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Monthly Database growth in a year

Author  Topic 

YogeshDesai
Posting Yak Master

136 Posts

Posted - 2008-02-18 : 12:21:54
We are handling the 4 production server and we use weekly based disk space and dbsize monitoring.
I want to calculate monthly growth of dbsize and disk space for all databases. Is it possible in SQL Server 2000. If you have an updates on this Please let me know. It will be really a great help for me.

SQL IN Minds

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-02-18 : 13:10:28
Should your weekly based disk space and dbsize monitoring tool tell you those info?
Go to Top of Page

YogeshDesai
Posting Yak Master

136 Posts

Posted - 2008-02-19 : 08:18:47
yes it shows the info on daily basis, i want to grab it only one day in month

SQL IN Minds
Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-02-19 : 23:11:21
Keep that day's data, so you know growth rate next month.
Go to Top of Page
   

- Advertisement -