I was asked a very interesting question by their DBA about log files. The question was – Is there ever need of multiple log files in SQL Server?
During the Comprehensive Database Performance Health Check, I had also helped the client build a query to list active and inactive VLF.
There are many reasons to envy my job as SQL Server Performance Tuning Expert Consultant but the most important reason is that I get to work on quite often the latest version of SQL Server. Just the other day I had an early adopter customer who was using SQL Server 2019 for their environment and they wanted me to help them with the new feature of Accelerated Database Recovery.