Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Content with tags Performance Tuning, Transaction Logs Rss

   Items 1 to 1 of 1   

Performance Issue with large number of Virtual Log Files in SQL Server Transaction Log

SQL Server transaction log files have an internal structure called the Virtual Log File or VLF. When the number of VLFs grow out of control due to autogrowth the log can become fragmented and cause delay. In this tip we look at how to see how many VLFs exist as well as how this can be reduced to a more reasonable number.   Read more...
By Additional Articles 2010/09/13 | Source: | Category: performance tuning
Rating: (not yet rated)  Rate this |   Briefcase | 2,944 reads
   Items 1 to 1 of 1