Understanding Database Locking and Blocking - Part 3


Length: 1 hour

Concurrency control, aka locking and blocking, is one of the central tenets of the ACID properties of transactions in a relational database. And yet, when done poorly, locking issues can slow down or bring any database application to a standstill. This webinar takes you through a variety of demos to teach you all of the ins and outs about locking, blocking, and transactions in SQL Server and Azure SQL.

Cut from a six-hour marathon recording session with Torsten and Kevin, this session drills down into topics:  

  • Common concurrency problem situations
  • Why and how SQL Server escalates locks from row- or page-level to a full table lock
  • How to partition tables for improved locking performance
  • And much more

SQL Server offers a wide variety of ways to ensure transactional concurrency and consistency. Register for this webinar to demos of these scenarios so that you can write better applications and administrate your databases more effectively!

Interested in additional SentryOne webinars?  Check our webinar library.

Register now

Kevin Kline

Kevin Kline

Principal Program Manager, SentryOne

Kevin (@kekline) serves as Principal Program Manager at SentryOne. He is a founder and former president of PASS and the author of popular IT books like SQL in a Nutshell. Kevin is a renowned database expert, software industry veteran, Microsoft SQL Server MVP, and long-time blogger at blogs.sentryone.com/author/kevinkline. As a noted leader in the SQL Server community, Kevin blogs about Microsoft Data Platform features and best practices, SQL Server trends, and professional development for data professionals.

Torsten Strauß

Torsten Strauß

Microsoft Most Valuable Professional and Data Platform Senior Consultant
Torsten Strauß (MVP, MCSE Data Platform, MCSE Data Management and Analytics, MCT) has been working with Microsoft SQL Server since the turn of the millennium. He currently works as Database Engineer and Microsoft SQL Server Evangelist for BP Europe SE and as Principal Consultant for Sarpedon Quality Lab. Torsten has delivered more than 100 presentations about Microsoft SQL Server at national and international conferences and user groups in recent years.

Companies with the highest demands for database performance choose SentryOne