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 2005 Forums
 SQL Server Administration (2005)
 Database growth

Author  Topic 

prodigy2006
Yak Posting Veteran

66 Posts

Posted - 2009-11-20 : 10:51:22
Is there a way to measure how much a database has grown in the past 4-5 months?
Please help...

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2009-11-20 : 11:03:33
you should be tracking this at regular intervals so you can do just that
Go to Top of Page

Aldex
Starting Member

1 Post

Posted - 2009-11-25 : 11:22:33
Hi, have a look at the SQLMetatool (see www.aldexsoftware.co.uk/SQLMetaTool). This can undertake regular scheduled scans and one of the features it supports is a graph of the size of each database (data, log and total) over time.
HTH
David
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-11-25 : 13:00:24
Here's what I use and wrote (I'm the author of the tool not the SQL Server Magazine article): http://www.sqlmag.com/Articles/ArticleID/102370/102370.html

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."
Go to Top of Page

behrman
Yak Posting Veteran

76 Posts

Posted - 2009-11-28 : 22:44:00
Hi.
Please refer to the url below:
http://www.sqlservercentral.com/scripts/Maintenance+and+Management/31929/

RAQ Report: Web-based Excel-like Java reporting tool
Go to Top of Page
   

- Advertisement -