Month: February 2025

When managing multiple SQL Server instances, database integrity is a top priority. Corruption issues can sneak up unexpectedly, leading to downtime, data loss, or performance problems. One of the most critical SQL Server maintenance tasks is running DBCC CHECKDB, which checks for corruption in your databases. However, running DBCC CHECKDB manually across multiple servers can be tedious and time-consuming. This is where Database Health Monitor comes in—offering a centralized view of DBCC CHECKDB reports across all your instances. In this …

Understanding the DBCC CheckDB Report in Database Health Monitor Read more »

Here is a short video on managing VLFs on SQL Server https://youtu.be/VjsgTWkws8M?si=ywngDBtdL9uE2i0X Best Practices for Managing VLFs Preallocate Log File Size: Instead of allowing SQL Server to expand the log file in small increments, preallocate a sufficient log file size to minimize growth events. Use Larger Growth Increments: Set the log file growth increment to a reasonable value (e.g., 512 MB or more) to avoid creating too many VLFs during growth. Monitor Regularly: Use the VLF Report in Database Health …

What are VLFs and why should you care Read more »

Here is a short video on managing VLFs on SQL Server https://youtu.be/VjsgTWkws8M?si=ywngDBtdL9uE2i0X Best Practices for Managing VLFs Preallocate Log File Size: Instead of allowing SQL Server to expand the log file in small increments, preallocate a sufficient log file size to minimize growth events. Use Larger Growth Increments: Set the log file growth increment to a reasonable value (e.g., 512 MB or more) to avoid creating too many VLFs during growth. Monitor Regularly: Use the VLF Report in Database Health …

What are VLFs and why should you care Read more »