On all of my databases, I cap the growth of the data and log files. I have not done my due diligence and performed capacity planning (Capacity Planning for SQL Server 2000 Database Storage), so I know I need to take those steps. I have been recent caught with a full database and I had to rush to expand it to keep the application up and running. Independent of the capacity planning process, I want to be able to monitor the database size and free space. Do you have a script that I can run to perform the checks on my SQL Server 2005 databases?
Additional Info
MSSQLTips.com webinars!
SQL Server Fragmentation - Fact vs. Fiction
Presenter: Chad Boyd
Sponsored By: Idera
Wednesday, October 17, 2007
4:00 PM - 5:00 PM EDT
Fragmentation - an often used word that is unfortunately also so often misunderstood. Fragmentation exists in multiple flavors, has different characteristics and effects on different types of data structures, and can be a major problem in some scenarios (also can be a non-issue at times as well). We'll discuss the different types of index structures, how and when they become fragmented (if they become fragmented), and when you should be concerned about fragmentation (and when not to be so concerned). We'll also be discussing multiple methods for monitoring and analyzing fragmentation, and discussing the different methods for removing fragmentation if appropriate.
