Too Many Virtual Log Files (VLFs) Can Cause Slow Database Recovery

The Transaction Log of a SQL Server database is composed of one or more physical files.  For each database, SQL Server only writes to one physical transaction log file at a time.  Although some firms choose to have more than one physical log file, the general guideline for SAP databases on SQL Server is to… Read more