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

Check out SpotLight, a free, cloud based SQL Server monitoring tool to easily detect, monitor, and solve SQL Server performance problems on any device

 

⇐ Back to index