Optimize Locking Behavior Locking is a feature in SQL Server 2016 that helps ensure the physical integrity of each transaction. Discover how to implement and troubleshoot locking and minimize handle and remediate deadlocks.