SQL Server Autogrowth Shock: How to Fix Slow File Growth and Stop Random Query Timeouts
It is one of the most frustrating performance mysteries in database administration. Out of nowhere, an application query that usually takes 10 milliseconds completely freezes. It spins for 15 seconds,
tunedinstance.com6 min read