Database growth?

SQL Server performance monitoring and alerting

Moderators: Colin Millerchip, priyasinha, Adam, chriskelly

Database growth?

Postby jwilley » Wed Jan 29, 2014 1:05 am

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
jwilley
 
Posts: 15
Joined: Wed Oct 01, 2008 1:49 pm

Postby chriskelly » Thu Jan 30, 2014 3:29 pm

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
chriskelly
 
Posts: 330
Joined: Mon Apr 19, 2010 1:44 pm
Location: Cambridge, UK

Database growth

Postby jwilley » Wed Feb 05, 2014 7:56 pm

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.
jwilley
 
Posts: 15
Joined: Wed Oct 01, 2008 1:49 pm

Postby Colin Millerchip » Thu Feb 06, 2014 4:55 pm

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.
Colin Millerchip
 
Posts: 66
Joined: Wed Oct 31, 2007 5:31 pm
Location: Cambridge, UK


Return to SQL Monitor 4

Who is online

Users browsing this forum: No registered users and 0 guests