17 May,2012 by Jack Vamvas
Question: This SQL Server Error message appears in the logs :
“Timeout occurred while waiting for latch: class 'LOG_MANAGER', id 000000001B8009F8, type 4, Task 0x0000000004ED9288 : 0, waittime 300, flags 0x1a, owning task 0x0000000B671882C8. Continuing to wait.”
How do I fix?
1. Check for disk bottlenecks through Windows Perfmon during maintenance processing. Read Window Perfmon scripting, SQL Server perfmon and how to perfmon
2. Don't run heavy processing jobs in parallel with backup and db reindexing
3. Check your service packs are up to date..
4. Check the Auto-Grow on Log files is set to Fixed growth, rather than percentage. On large transaction , if you set it at 10% , a large file such as 30GB – will request 3 GB growth. Whereas , if you set it a .5 GB . Read SQL LOG FILE AUTOGROW performance troubleshooting