Optimize Locking Behavior

SQL Server 2016
  • 9 Videos | 54m 49s
  • Includes Assessment
  • Earns a Badge
Likes 12 Likes 12
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.

WHAT YOU WILL LEARN

  • provide an overview of locking
    discuss the types of concurrency and their effects
    describe deadlock behavior
    minimize deadlocks
    demonstrate how to handle deadlocks
  • demonstrate how to remediate, detect, and end deadlocks
    demonstrate how to troubleshoot locking issues
    describe lock escalation behaviors
    provide an overview of memory-optimized tables and discuss use cases for memory-optimized tables vs. traditional disk-based tables

IN THIS COURSE

  • Playable
    1. 
    Locking Basics
    10m 55s
    UP NEXT
  • Playable
    2. 
    Concurrency Effects
    4m 43s
  • Locked
    3. 
    Understanding Deadlocks
    5m 43s
  • Locked
    4. 
    Minimizing Deadlocks
    3m 29s
  • Locked
    5. 
    Handling Deadlocks
    3m 53s
  • Locked
    6. 
    Remediating Deadlocks
    4m 38s
  • Locked
    7. 
    Troubleshooting Locking Issues
    6m 38s
  • Locked
    8. 
    Lock Escalation Behavior
    5m 25s
  • Locked
    9. 
    Exercise: Troubleshoot Deadlocks
    5m 26s

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion of this course, which can be shared on any social network or business platform

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Likes 8 Likes 8  
Likes 34 Likes 34  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 57 Likes 57  
Likes 61 Likes 61  
Likes 26 Likes 26