Community

When a data file autogrows, does autogrowth block updates to the file?

No, but autogrowth of data files blocks allocations of new extents because SQL Server blocks changes to the allocation pages, which keep track of which extents in the file are in use, during autogrowth.

Read More - Register for Free Membership