SQL Server Video on Database Growth


By:   |   Updated: 2014-11-17   |   Comments (1)   |   Related: More > Database Administration




 






Enter your business email address to
get free SQL Server tips.

Problem / Solution

Monitoring database growth and anticipating future growth is a key component for being a proactive DBA.  In this video, we look at how to use PowerShell to capture SQL Server database size statistics and using this data over time to predict the growth of our databases.  Watch the video to learn more.

Key Learning Items
  • How to use PowerShell to track database growth
  • Viewing and trending database growth
  • Predicting future database storage needs
Read Companion Tips

Click Here



Last Updated: 2014-11-17


get scripts

next tip button



About the author
MSSQLTips author Tim Smith Tim Smith works as a DBA and developer and also teaches Automating ETL on Udemy.

View all my tips
Related Resources





Comments For This Article




Monday, November 17, 2014 - 12:34:54 PM - Ian Miller Back To Top (35312)

Hi Tim.  Thanks for the video.  Could you please explain why you prefer this approach over using SQL Server's builtin Data Collection?



download





Recommended Reading

How to rename a SQL Server database

How to determine SQL Server database transaction log usage

Different ways to determine free space for SQL Server databases and database files

How to read the SQL Server Database Transaction Log

Execute SQL Server Script Files with the sqlcmd Utility








get free sql tips
agree to terms


Learn more about SQL Server tools