HADR_FILESTREAM_BLOCK_FLUSH

Description

For databases utilizing Availability Groups with the FileStream feature configured. This wait accumulates while SQL Server is waiting to process outstanding log blocks. High values indicate a bottleneck on the transaction log

Resolved by

DBAs and Developers

Suggested solutions

  1. Make sure code and directories have been configured as per FileStream best practices (link below)
  2. Check SQL Server error log for any FileStream warnings and errors
  3. Upgrade disks hosting the FileStream database and transaction log files

Additional research

FILESTREAM Best Practices
AlwaysOn Availability Groups Troubleshooting and Monitoring Guide

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