Quick Scan Report – Log File Slow IO

If the Quick Scan Report is reporting that you have Slow IO on your Log File, this can be an indication that transactions are taking a long time to complete.

If you are watching your wait stats, if you log file has slow IO, you will likely be seeing write log waits accumulating on transactions, for explicit transactions you will see these on the COMMIT statement.

Your transaction cannot complete until the transaction log has been written to disk. A slow transaction log file slows down every single write to your database.

Can you move your transaction logs to faster storage?

 

Related Links:


Enroll Today!
SteveStedman5
SteveStedman5
Steve and the team at Stedman Solutions are here for all your SQL Server needs.
Contact us today for your free 30 minute consultation..
We are ready to help!