Display DB growth rate, including DB File-layout
DB sizing is any DBA's worst nightmare, mostly because very few of us were involved when the DB was designed. Thus, DB data- and log-file layouts, project growth and maximum sizing, all becomes very important properties and settings, which the DBA needs to be aware of. Also, tracking growth rate to plan for future planning regarding underlying disk space is as important to any DBA.
This would be very useful to incorporate it into SQL Monitor, having the option to navigate to SQL Server Instance-level, from the Global Overview option and then display the underlying properties for each database in terms of Total Size, Free Space and Un-used space, as well as logial names, file-location and properties mentioned above. Also, have the ability to track DB growth rate, saving historic sizes and plotting a trend. This can be enhanced even further by sending alerts based on incosistent growth rates, or even just the fact that DB data-files had to autogrow etc.
Michael Berry commented
would also like to see it project out an estimate of when a drive would drun out of space based on existing growth trends.
Nicolaas Botes commented
Yes, thanks for your suggestions Nicolaas, we will certainly bear these in mind as we are developing the next releases.
In the meantime, we do have a free SQL Monitor SSRS Reporting Pack which has reports for DB size and Top DBs by Growth:
I hope that's useful. Thanks again for your feedback.
Hello Nicolaas .. Thanks a lot for your feedback.