Database growth?
jwilley
Posts: 23
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
If SQL Monitor is not the right tool for this, can you suggest something?
thx -- john
Comments
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.
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.
Thanks for your post.
It looks like something in your installation of the web service got corrupted somehow. Are you not able to uninstall "SQL Monitor Web 3" in Programs and Features?
I've solved this issue in the past by reinstalling the current version (just re-run the installer you originally used), then running the version 4 installer again. (You may need to browse to the .msi files, but it should work.)