XEvents SQLChallenge: Create an Extended Events Trace (55 minutes)
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.
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.