Every database and system administrator knows the four common resource bottlenecks: memory, CPU, disk, and network. But another bottleneck exists inside the database engine itself: concurrency.
Concurrency is a necessary function inside a SQL Server database. It helps ensure data integrity while users are accessing data at the same time. By default, concurrency uses a locking mechanism on the underlying data. Locking will lead to blocking, and blocking will result in time wasted and losses in productivity.
In this session presented by Microsoft Data Platform MVP Thomas LaRock, we’ll review the fundamentals of database concurrency, the differences between locking and blocking, and how to identify when concurrency issues exist. We’ll also discuss steps you can take to resolve performance issues and show you how SolarWinds® Database Performance Analyzer can help your troubleshooting efforts.
Register for this live event learn how to best manage locking as well as minimize blocking and deadlocks.
Thursday, October 29, 2020
3:00:00 PM EDT (New York) | 7:00:00 PM UTC
Thomas LaRock has over 20 years of IT experience holding roles such as programmer, developer, analyst, and database administrator. He is a Microsoft Certified Master, VMware vExpert, Microsoft Certified Trainer, and a 12-time Microsoft Data Platform MVP.
Thomas has spent much of his career focused on data and database administration, which led to his election as a Technical Evangelist for Confio Software in 2010, where his research and experience helped create the initial versions of the software now known as SolarWinds® Database Performance Analyzer (DPA).
LaRock has served on the board of directors for the Professional Association for SQL Server (PASS), and is an avid blogger, author, and technical reviewer for numerous books about SQL Server management. He’s made it his mission to give IT and data professionals longer weekends.
Copyright (c) 2006-2020 Edgewood Solutions, LLC All rights reserved
Some names and products listed are the registered trademarks of their respective owners.