You’re a developer with an application that’s grown over time, and its performance has started to degrade. When your users change data with inserts/updates/deletes, they are reporting random slowdowns. The more users you get, the worse performance becomes – and you’re not allowed to purge or archive data, either.
How are you supposed to handle concurrency and scale? You don’t have a senior DBA you can escalate these problems to – maybe you work for a software vendor. (Or maybe you’re the DBA, and this is the first time you’ve hit the notorious locking, blocking, and deadlocking walls.)
Good news: SQL Server has options to help – and we’re not talking about NOLOCK.
In this half-day class, you’ll learn:
- Learn the differences between Pessimistic and Optimistic Concurrency Control in SQL Server
- Understand how your application’s transaction controls affect concurrency
- Study SQL Server’s locking and blocking behaviors
- Leverage SQL Server metadata to observe the locking, blocking and row versioning
- Master the two snapshot based isolation levels: Read Committed Snapshot and Full Snapshot
About the instructor: Kalen Delaney has been a Microsoft MVP for SQL Server since 1993. She is the author of several highly regarded books, including Microsoft SQL Server 2012 Internals, SQL Server Concurrency, SQL Server MVP Deep Dives, and SQL Server Internals of In-Memory OLTP.
This is an online class – Kalen hosts it in GoToWebinar, live on webcam, taking questions as she goes through the material. Audio can come through either your computer audio, or by dialing into a US phone number – headset recommended either way. For more information, check out the Training Logistics PDF for our online classes.
You can watch again later with Instant Replay – as soon as you buy, you can stream the online recordings for a year. Brush up on stuff you missed or revisit your favorite topics. It’s the best of both worlds: live training with us, plus reminders.
This class is not scheduled for delivery, but you can contact Kalen Delaney to schedule a class at your company.