A production-focused guide to SQL Server 2025 optimized locking, covering TID locks, lock-after-qualification, ADR and RCSI dependencies, workload compatibility, failure modes, observability, and controlled rollout.