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) |