Skip to content

sp_Blitz: if optimized locking is enabled, warn if RCSI is not enabled #3741

@BrentOzar

Description

@BrentOzar

Is your feature request related to a problem? Please describe.
SQL Server 2025's new optimized locking performs better if RCSI is on: https://learn.microsoft.com/en-us/sql/relational-databases/performance/optimized-locking?view=sql-server-ver17#best-practices-with-optimized-locking

Describe the solution you'd like
If OL = enabled on a database, warn if RCSI is not.

Are you ready to build the code for the feature?
Yep

Metadata

Metadata

Assignees

Labels

Type

No type

Projects

No projects

Relationships

None yet

Development

No branches or pull requests

Issue actions