Locking & Blocking

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 we 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.

Date & Pricing Details:

  • Time: October 5, 2017 from 09:00am to 05:00pm (GMT + 1)
  • Live Web-Based Training
  • EUR 590 + 20% VAT