Andreas Wolter • 2/22/2013

Locking & READONLY Filegroups vs READONLY Databases

This technical article investigates and debunks common misconceptions about SQL Server locking behavior when using READONLY filegroups versus entire READONLY databases. It details test results across different isolation levels (Read Committed, Read Uncommitted, Repeatable Read) to show that READONLY filegroups do not reduce locking, while READONLY databases do. The piece also covers edge cases like statistics generation and exclusive locks in read-only contexts, providing a definitive guide for database administrators and developers.

0 comments

#SQL Server #Readonly #Filegroups