The Databases - Log Flush Wait Time alarm becomes active when the duration of the last log flush for a database exceeds a threshold.
As users make modifications to SQL Server databases, SQL Server records these changes in a memory structure called the Log Cache. Each SQL Server database has its own log cache.
When a user transaction is committed (either explicitly via a COMMIT statement, or implicitly), SQL Server writes all changes from the Log Cache out to the log files on disk. This process is termed a log flush. The user that issued the commit must wait until the log flush is complete before they can continue. If the log flush takes a long time, this will degrade the user's response time.
Note that Spotlight on SQL Server checks the log flush wait time for the last log flush performed for each database. If a database has a slow log flush, and then has no update activity (and therefore no more log flushes) for a long time, Spotlight on SQL Server will still continue to report this as an alarm until another log flush is performed for that database.
When the alarm is raised
Configuration
© 2022 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy