XEvents SQLChallenge: Create an Extended Events Trace (55 minutes)

Build your skills with Extended events in this SQLChallenge.

Your challenge

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.

Get the scripts

https://github.com/LitKnd/SQLWorkbooks/tree/main/xevents_sqlchallenge

Lessons

Your Extended Events SQLChallenge (12 minutes)

Sample Solutions - Script and Video (27 minutes)

Questions and Answers (16 minutes)