Matt Lavery

Technical tips, focusing on SQL Server
  • Matt Lavery

    TSQL to identify databases with high number of VLFs

    If you aren't aware there can be significant impact to performance when a database has a high number of VLFs within it's Transaction Log. SQL Server divides each physical transaction log file internally into a number of virtual log files (VLFs) and it...
Page 1 of 1 (1 items)