Run a load test, then analyze the Blocked Process Report (16 minutes)

Please purchase the course before starting the lesson.

Now we'll fire up a load test against the WideWorldImporters sample database, using free tools from Microsoft. This gets into blocking trouble when our (imaginary) co-worker Frank starts doing some work. We'll check out how that's captured by the Blocked Process Report, and I'll show you how the free Blocked Process Report Viewer makes reading the results easier.

Back to: Troubleshooting Blocking and Deadlocks for Beginners (2 hours 10 minutes) > Troubleshooting retroactively