Optimize Locking Behavior
SQL Server 2016
| Intermediate
- 9 Videos | 54m 49s
- Includes Assessment
- Earns a Badge
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
-
1.Locking Basics10m 55sUP NEXT
-
2.Concurrency Effects4m 43s
-
3.Understanding Deadlocks5m 43s
-
4.Minimizing Deadlocks3m 29s
-
5.Handling Deadlocks3m 53s
-
6.Remediating Deadlocks4m 38s
-
7.Troubleshooting Locking Issues6m 38s
-
8.Lock Escalation Behavior5m 25s
-
9.Exercise: Troubleshoot Deadlocks5m 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.
