Webinar:

Understanding Database Locking and Blocking - Part 1

Summary:

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 bring any database application to a screeching halt. 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.

We will cover a variety of relevant issues and FAQs, including:

  • Common concurrency problem situations
  • Transaction isolation levels
  • Blocking chains and how to find them
  • Why NOLOCK is not the solution for many problems and can even make things worse
  • DMVs and other instrumentation that tells you what is going on with locking
  • Lock escalation
  • And much more

 

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

Interested in additional SentryOne webinars?  Check our webinar library.

On-Demand 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