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
- Make sure code and directories have been configured as per FileStream best practices (link below)
- Check SQL Server error log for any FileStream warnings and errors
- Upgrade disks hosting the FileStream database and transaction log files
Additional research
FILESTREAM Best Practices
AlwaysOn Availability Groups Troubleshooting and Monitoring Guide
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