Catching the Slowdowns: Capturing Workloads with Extended Events

If you have ever been tasked with finding out exactly which application queries are causing CPU spikes or disk latency on a production database, you might have instinctively reached for SQL Server Pro