VTSQL UG: SQL Server Blocking and Locking (ONLINE)

Description: How to detect, analyze and minimize SQL Server Blocking and Locking. The goals of this session are to learn the good, the bad, and the ugly of blocking; to discover what is the difference between locking, blocking and deadlocking; to understand how to minimize blocking during OLTP operations, batch processing, bulk inserts, and large scale deletes, to study how to use the appropriate isolation levels to reduce/increase blocking and partitioning and blocking.

Discover what Snapshot and Read Committed Snapshot Isolation levels are all about and when you should use them. Understand how to monitor locking and blocking. Learn about In Memory Tables. Learn how to monitor and troubleshoot blocking processes.

About the speaker: SQL Server MVP Hilary Cotter is a 24+ year IT veteran who has answered over 20,000 questions on the forums. Some of them correctly. He has worked on some of the largest and challenging SQL Server topologies in the world. He has been a SQL Server MVP for 14 years now. He has worked on some of the more complex replication deployments in the world.

Event info: Please join my meeting from your computer, tablet or smartphone.

https://global.gotomeeting.com/join/494063517

You can also dial in using your phone.
(For supported devices, tap a one-touch number below to join instantly.)

United States: +1 (872) 240-3212

• One-touch: tel:+18722403212,,494063517#

Access Code: 494-063-517

Join from a video-conferencing room or system.
Dial in or type: 67.217.95.2 or inroomlink.goto.com
Meeting ID: 494 063 517
Or dial directly: 494063517@67.217.95.2 or 67.217.95.2##494063517

New to GoToMeeting? Get the app now and be ready when your first meeting starts: https://global.gotomeeting.com/install/494063517