SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

SQLServerCentral Article on Database Space Capacity Planning

I wrote an article for SQLServerCentral entitled "Database Space Capacity Planning" that demonstrates a database and volume (disk) capacity planning solution I use in my production environment. Some highlights of the solution:

  • Powershell is used to collect database and volume space information from a list of SQL Servers, which is then loaded into a consolidated reporting database
  • A series of queries are used to calculate a days remaining metric i.e. the number of days until volume or database file runs out of space.
  • Uses SQL Server Reporting Services (SSRS)  to provide self-service reports

See the full article for details.

Chad Miller

Chad Miller is a Senior Manager of Database Administration at Raymond James Financial. Chad has worked with Microsoft SQL Server since 1999 and has been automating administration tasks using Windows Powershell since 2007. Chad is the Project Coordinator/Developer of the Powershell-based Codeplex project SQL Server PowerShell Extensions (SQLPSX). Chad leads the Tampa Powershell User Group and is a frequent speaker at users groups, SQL Saturdays and Code Camps.


No comments.

Leave a Comment

Please register or log in to leave a comment.