october, 2020

wed14oct5:00 PM6:30 PMVirtual EventI will speak at SentryOneUnderstanding Database Locking and Blocking in Microsoft SQL Server5:00 PM - 6:30 PM CEST SentryOne

Abstract

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!

Speaker for this event

  • Torsten Strauß

    Torsten Strauß

    MVP | MCSE | MCT

    Torsten (MVP, MCSE, MCT) has been working with Microsoft SQL Server since the turn of the millennium and is specialized in performance optimization for large SQL Server environments. He has been a Database Engineer at BP for over two decades and has also been working for SARPEDON Quality Lab as a Principal Microsoft SQL Server Consultant for many years. Torsten is the founder of inside-sqlserver.com and has given more than 120 presentations on Microsoft SQL Server performance optimization at national and international conferences and user groups. Torsten has been recognized as a Microsoft Most Valuable Professional for Data Platform since 2018.

    URL https://inside-sqlserver.com/

    MVP | MCSE | MCT

Organizer

SentryOnesales@sentryone.com

Time

(Wednesday) 5:00 PM - 6:30 PM CEST

Virtual Event Details

Event has already taken place!