-
Type: Question
-
Resolution: Done
-
Priority: Major - P3
-
None
-
Affects Version/s: None
-
Component/s: Concurrency
-
None
-
Execution Team 2020-03-23, Execution Team 2020-04-06, Execution Team 2020-04-20
As we no longer have any significant data structures in the catalog that need protection at the database level, almost all database locks (with a ResourceType of RESOURCE_DATABASE) are now IS and IX. This ticket is to find all remaining mode X and S locks and see if we can remove these.
If we can, we can flatten the hierarchy and completely get rid of these locks, gaining a little performance and simplifying the code base.