DBA Fundamentals Group

Whether you are a new DBA or a seasoned professional, these are the critical items you need to do to make sure your Postgresql clusters are healthy and happy. Many times, we can’t control what applications are doing to our servers, but we can do a lot to make sure they're ready for the flood. We will discuss Backups, Restores, Performance configuration, Vacuum policies, Size/Structure concerns, and several other items. I’ll share free scripts you can use anytime to really understand your server. This is a great session for DBAs, accidental DBAs, and anyone that is interested in understanding more about the clusters they manage.

SQL Server 2025 introduces major enhancements to the locking engine, including Optimized Locking and the new Lock After Qualification strategy. These improvements fundamentally change how the engine acquires and holds locks, reducing contention and improving throughput under concurrent workloads.

In this deep dive, we will examine the internals of SQL Server’s locking behavior and how the 2025 improvements minimize unnecessary locks during query execution. We will analyze common contention scenarios—such as large updates, high‑concurrency workloads, and lock escalation—and demonstrate how Lock After Qualification defers lock acquisition until rows are fully qualified, thereby reducing blocking and deadlocks.

Through detailed demos using Dynamic Management Views (DMVs) and Extended Events (XEvents), you will learn how to inspect lock footprints, compare behaviors across access patterns, and evaluate strategies such as partitioning, index design, and transaction scoping. We will also discuss how these changes interact with features like RCSI, READPAST/skip locked, and explicit lock hints (UPDLOCK, HOLDLOCK, ROWLOCK) in the context of SQL Server 2025.

By the end of this session, you will have a clear understanding of SQL Server 2025’s optimized locking engine, know how to monitor and troubleshoot blocking scenarios, and be equipped to design queries and indexes that fully leverage these engine enhancements for maximum concurrency and stability.