PREEMPTIVE_OS_FLUSHFILEBUFFERS

Description

Occurs while SQL Server is waiting for the Operating System to flush file buffers to disk. This wait is commonly seen in databases with auto-growth not configured appropriately. Small values are expected. Excessive values should be investigated

Resolved by

DBAs and Developers

Suggested solutions

  1. Increase the auto-growth from the default (less frequent growths)
  2. Investigate storage issues in the Windows Event Viewer
  3. Upgrade storage
  4. Consolidate transactions from row-by-row statements to batch processing

Additional research

Some Initial Insert Test Benchmarks on SQL Server 2008 R2
PREEMPTIVE and Non-PREEMPTIVE

See more

Consider using ApexSQL Monitor, a Windows and SQL Server monitoring tool able to track SQL Server wait types, including the individual query wait statistics

⇐ Back to index