-
StatPress TopPosts
- How to Shrink TempDB in SQL 2005 (2290)
- A Busy/Accidental DBA's Guide to Managing VLFs (2233)
- Stored Procedure to Sequentially Run SQL Agent Jobs (2184)
- Why Do I Need All These Servers? (2173)
- Stored Procedure to Get SQL Job Execution Status (2131)
Archives
- May 2011 (4)
- April 2011 (1)
- January 2011 (1)
- November 2010 (8)
- October 2010 (3)
- September 2010 (6)
- August 2010 (1)
- July 2010 (2)
- June 2010 (1)
- May 2010 (5)
- April 2010 (11)
- March 2010 (2)
- February 2010 (3)
- January 2010 (3)
- December 2009 (4)
Categories
- Azure (1)
- Backup (1)
- CLR (1)
- Dynamic SQL (1)
- File Management (5)
- General (7)
- PowerShell (6)
- Reporting (1)
- Security (4)
- Security Cache (2)
- SQL University (4)
- Tracing and Profiler (1)
- Troubleshooting (7)
- User Management (6)
- Utilities (22)
Meta
Disclaimer
All thoughts and opinions expressed here do not reflect those of my employer in any way.
Tag Archives: VLF
Want to Make Your SQL Server Run Faster for Free?
Want to Make Your SQL Server Run Faster for Free? The trick is to properly manage your VLFs. What are VLFs? The short anser is that VLF stands for virtual log file. SQL Server database log files are made up of many smaller virtual log files that make it easier for SQL Server to manage the log files. Continue reading
A Busy/Accidental DBA’s Guide to Managing VLFs
Introduction Properly managing VLFs can make or break the performance of your databases. There is a ton of information out there on the proper management of VLFs, but nothing I have found that tries to boil it down to the … Continue reading
