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

⇐ Back to index