Optimize Locking Behavior

SQL Server 2016    |    Intermediate
  • 9 videos | 50m 49s
  • Includes Assessment
  • Earns a Badge
Likes 41 Likes 41
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

  • 10m 55s
    After completing this video, you will be able to provide an overview of locking . FREE ACCESS
  • 4m 43s
    Learn how to discuss the types of concurrency and their effects. FREE ACCESS
  • Locked
    3.  Understanding Deadlocks
    5m 43s
    After completing this video, you will be able to describe deadlock behavior. FREE ACCESS
  • Locked
    4.  Minimizing Deadlocks
    3m 29s
    In this video, you will learn how to avoid deadlocks. FREE ACCESS
  • Locked
    5.  Handling Deadlocks
    3m 53s
    In this video, you will learn how to handle deadlocks correctly. FREE ACCESS
  • Locked
    6.  Remediating Deadlocks
    4m 38s
    In this video, you will learn how to remediate, detect, and end deadlocks. FREE ACCESS
  • Locked
    7.  Troubleshooting Locking Issues
    6m 38s
    In this video, you will learn how to troubleshoot lock issues. FREE ACCESS
  • Locked
    8.  Lock Escalation Behavior
    5m 25s
    After completing this video, you will be able to describe lock escalation behaviors. FREE ACCESS
  • Locked
    9.  Exercise: Troubleshoot Deadlocks
    5m 26s
    After completing this video, you will be able to provide an overview of memory-optimized tables and discuss use cases for memory-optimized tables vs. traditional disk-based tables. FREE ACCESS

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

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

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Course Introduction to SQL Bootcamp: Session 4 Replay
Likes 77 Likes 77  
Course MySQL: Transactions, Savepoints, & Locks
Likes 43 Likes 43  
Course Stored Procedures
Likes 61 Likes 61  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Optimizing Statisitics & Indexes
Likes 49 Likes 49  
Course Analyzing Query Plans
Likes 21 Likes 21  
Course Data Types & Normalization
Likes 67 Likes 67