Build your skills with Extended Events in this hands-on SQLChallenge. You’ll set up a problem scenario in your test instance, then configure an Extended Events trace that captures the problem. Along the way, you’ll learn when traces will capture events and when they won’t, understand event filtering and configuration options, and work through sample solutions that demonstrate different approaches to Extended Events trace design.

Follow the script to set up a problem in your test instance of SQL Server. Then, your challenge is to configure a trace that will capture the problem – and also learn more about when the trace will capture an event, and when it won’t.

Challenge difficulty

This is designed as a 200 level challenge. It will be pretty quick for people who have configured Extended Events traces before. If you haven’t done that yet, it may take a little more time – but it’s worth it! These traces can be extremely useful.