Episode

Waiting due to Blocking (Part 5 of 7) | Azure SQL for beginners

with Bob Ward

Special Edition: Performance Troubleshooting | Azure SQL for Beginners

In this episode we will look at a common performance scenario involving blocking of SQL users. This scenario involves a problem where little, or no CPU is observed but a blocking problem is discovered causing slow performance for the application. We will look at the common symptoms of a blocking problem and solutions for immediate relief and long-term prevention.

Chapters

  • 00:00 - Introduction
  • 00:53 - What is blocking?
  • 01:38 - What is a Dynamic Management View (DMV)?
  • 02:54 - The troubleshooting process
  • 04:07 - Demo
  • 08:24 - Best practices to avoid blocking problems
  • 09:28 - Summary
  • 09:58 - Learn more

Azure
Azure SQL Database