Tag Archives: see the log_reuse_wait_desc column in sys.databases

SQL Server Transaction Log – Best Practice

Best practices for managing SQL Server Transaction Logs. Steps for better throughput for SQL Server Transaction log. 1. Dedicate a physical disk to your transaction logs.  2.  Defrag the disks on which your tranaction logs reside to get rid of disk file fragmentation.  (requires downtime) 3.  You only need one transaction log.  Put it on a [...]