Optimize Locking Behavior

SQL Server 2016    |    Intermediate
  • 9 videos | 50m 49s
  • Includes Assessment
  • Earns a Badge
Rating 4.6 of 39 users Rating 4.6 of 39 users (39)
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

Book MySQL Concurrency: Locking and Transactions for MySQL Developers and DBAs
Channel Database Performance Tuning
Book PostgreSQL Query Optimization: The Ultimate Guide to Building Efficient Queries, Second Edition

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Managing Database Integrity
Rating 4.6 of 34 users Rating 4.6 of 34 users (34)
Course Azure AI Fundamentals: Natural Language Processing
Rating 4.5 of 24 users Rating 4.5 of 24 users (24)
Course Isolation Levels
Rating 4.5 of 31 users Rating 4.5 of 31 users (31)