(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the essential knowledge you need to know about performance tuning on SQL Server.)
On February 25, 2021 I will run an SQLpassion Online Training about Locking, Blocking, and Deadlocking in SQL Server – one of my favourite topics! Locks are used by SQL Server to isolate database users from each other.
Unfortunately, incompatible locks lead to blocking situations. And blocking situations always hurt your end user response times. In this one-day long webinar we will have a detailed look at Locking & Blocking in SQL Server, and at how you can influence SQL Server in this area.
During the webinar I will cover the following areas:
- Transactions
- Pessimistic Concurrency
- Read Uncommitted
- Read Committed
- Repeatable Read
- Serializable
- Optimistic Concurrency
- Read Committed Snapshot Isolation
- Snapshot Isolation
- Locking Internals
- Lock Escalations
- Deadlocking
This one-day long webinar is primarily for DBAs, Developers, and Consultants who want to make their SQL Server installations faster. Please check-out the this link for more details about the online training (detailed agenda, date, pricing) and how to sign-up.
Thanks for your time,
Klaus