november, 2020
Abstract
Concurrency control, aka locking and blocking,
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 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!
Time
(Wednesday) 5:00 PM - 6:00 PM
Organizer
SentryOnesales@sentryone.com
Virtual Event Details
RUN
Event has already taken place!
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 with bp as a database engineer for over two decades and collaborates closely with Sarpedon Quality Lab as a Principal Microsoft SQL Server Consultant. 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.
MVP | MCSE | MCT