Red Gate forums :: View topic - Database growth?
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Monitor 4
SQL Monitor 4 forum

Database growth?

Search in SQL Monitor 4 forum
Post new topic   Reply to topic
Jump to:  
Author Message
jwilley



Joined: 01 Oct 2008
Posts: 15

PostPosted: Wed Jan 29, 2014 1:05 am    Post subject: Database growth? Reply with quote

Question: will SQL Monitor show me the size of my database over time so that I can estimate growth rate for capacity planning? If SQL Monitor won't give me this info out-of-the-box, can I (or you?) right a custom metric, possibly using backup information (I think (could be wrong) that backup sizes are stored for each full backup -- which we do weekly using SQL Backup).

If SQL Monitor is not the right tool for this, can you suggest something?

thx -- john
Back to top
View user's profile Send private message
chriskelly



Joined: 19 Apr 2010
Posts: 327
Location: Cambridge, UK

PostPosted: Thu Jan 30, 2014 3:29 pm    Post subject: Reply with quote

If you monitor the data repository host sql server instance, then this information will be captured in exactly the same way as any other SQL Server database. You can use the analysis graphs to see this information over time too, so that you can estimate the growth. However SQL Monitor will not make this estimate for you, it will only show you the historical data.
_________________
Chris Kelly
Technical Support Engineer
Back to top
View user's profile Send private message
jwilley



Joined: 01 Oct 2008
Posts: 15

PostPosted: Wed Feb 05, 2014 7:56 pm    Post subject: Database growth Reply with quote

thx for the reply. Yes, I know I can monitor manually every day or week. I have 75 large databases to keep track of and was hoping you guys had some better approach. It is surprisingly difficult to find out how fast a database is growing over time, let alone consolidating that across multiple databases and projecting so as to plan storage upgrades.

This would be a great opportunity for a new "Capacity Planning" product for RedGate. You could use the SQL Backup history to get the historical file growth but we also need to understand growth within the size allocated to the various filegroups. Idera is the only vendor I've found that advertises that feature (I have not tried it...yet).

As a long-time RedGate customer, I'll volunteer to share our workflows with the developers and be a beta if you decide to pursue this.
Back to top
View user's profile Send private message
Colin Millerchip



Joined: 31 Oct 2007
Posts: 63
Location: Cambridge, UK

PostPosted: Thu Feb 06, 2014 4:55 pm    Post subject: Reply with quote

Hi John,

Assuming you're actively monitoring the server(s) with the databases of interest, then SQL Monitor captures this information automatically for you. We capture total size, as well as data and log size (as separate metrics).

These are accessible via the "Analysis" tab. You can also export the data to .csv files, to do further analysis (such as capacity planning).

Is this the information you're after?

Best regards,


Colin.
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group