download (16)

Understanding Database Locking and Blocking

Concurrency control, also known as locking and blocking, is one of the central tenets of the ACID properties of transactions in a relational database. When done poorly, however, locking issues can bring any database application to a screeching halt. During this webinar, our colleagues at SentryOne will take you through a variety of demos to teach you the ins and outs of locking, blocking, and transactions in SQL Server and Azure SQL.

 

During this 50-minute session, you will learn about:

  • Common concurrency problem situations
  • Transaction isolation levels
  • Blocking chains and how to find them
  • Why NOLOCK is not the solution for many problems
  • DMVs and other instrumentation to tell you what’s going on with locking
  • Lock escalation
  • And more

    In order to provide you with this content we will share your business information with SolarWinds. By clicking below, you are agreeing to SolarWinds Terms and Privacy Policy. Third party cookies may be placed to serve you more relevant ads when your browse the web. You can learn more about those ads here. link to optout information this links to

    All information that you supply is protected by our Privacy Policy.
    In order to provide you with this free service, we may share your business information with companies whose content you choose to view on this website.
    By submitting your information you agree to our Terms of Use.
    Third party cookies may be placed, to serve more relevant ads when you browse the web.
    You can learn more about those ads here.