Today we will be seeing a simple solution of Delayed Durability and Flushing Log Files. Comprehensive Database Performance Health Check.
They found out that they have a full backup running for one of the largest servers and at the same time they are running a log backup on the same server.
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.