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.