MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.

I'm not curious

SQL Server: Deadlock Analysis and Prevention

Course Summary

Deadlocks can be very problematic when they occur, especially if you do not know how to figure out what's making the deadlocks occur so that you can take steps to prevent them. This course explains how the locking mechanism in SQL Server works and the cir

  • +

    Course Syllabus

    ● Introduction
        ◦ Introduction
        ◦ Misconceptions
        ◦ Course Structure
    ● Locking Overview
        ◦ Introduction
        ◦ Terminology
        ◦ Lock Granularity
        ◦ Lock Hierarchy
        ◦ Shared and Update Locks
        ◦ Exclusive and Intent Locks
        ◦ Schema and Key-Range Locks
        ◦ Lock Compatibility
        ◦ Isolation Levels and Locking Hints
        ◦ Lock Escalation
        ◦ Summary
    ● Deadlock Detection
        ◦ Introduction
        ◦ Deadlock Detection
        ◦ Deadlock Priority
        ◦ Deadlock Victim Selection
        ◦ Deadlock Resolution in SQLCLR
        ◦ Summary
    ● Collecting Deadlock Information
        ◦ Introduction
        ◦ Trace Flags
        ◦ Demo: Trace Flags
        ◦ SQL Trace and Profiler
        ◦ Demo: SQL Trace and Profiler
        ◦ Event Notifications
        ◦ Demo: Event Notifications
        ◦ Windows Management Instrumentation
        ◦ Demo: Windows Management Instrumentation
        ◦ Extended Events
        ◦ Demo: Extended Events
        ◦ Summary
    ● Deadlock Analysis
        ◦ Introduction
        ◦ Deadlock Graph Sections
        ◦ Demo: Deadlock Graphs
        ◦ Interpreting the Information
        ◦ Graphical Display in Profiler/SSMS
        ◦ Demo: Graphical Display
        ◦ Third-party Tools
        ◦ Demo: Third-party Tools
        ◦ Summary
    ● Example Deadlock Scenarios
        ◦ Introduction
        ◦ Reverse Object Order Deadlocks
        ◦ Demo: Reverse Object Order Deadlocks
        ◦ Bookmark Lookup Deadlocks
        ◦ Demo: Bookmark Lookup Deadlocks
        ◦ Serializable Deadlocks
        ◦ Demo: Serializable Deadlocks
        ◦ Cascading Constraint Deadlocks
        ◦ Lock Escalation Deadlocks
        ◦ Demo: Lock Escalation Deadlocks
        ◦ Memory Grant Deadlocks
        ◦ Intra-Query Parallelism Deadlocks
        ◦ Multi-Victim Deadlocks
        ◦ Demo: Multi-Victim Deadlocks
        ◦ Resolving Deadlocks
        ◦ Demo: Resolving Deadlocks
        ◦ Summary
    ● Handling Deadlocks
        ◦ Introduction
        ◦ Catching Deadlock Errors
        ◦ Demo: Catching Deadlock Errors
        ◦ Retrying After a Deadlock
        ◦ Demo: Retry Logic
        ◦ Summary


Course Fee:
USD 29

Course Type:


Course Status:



1 - 4 hours / week

Attended this course?

Back to Top

Awards & Accolades for MyTechLogy
Winner of
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url

Back to Top