SQL Saturday #271 – Extended Events In Real Life

I’ve uploaded my deck and scripts for my upcoming presentation. It’s in the “Presentation” page.


In order to create the sample “Stack Exchange” databases, you can use the Gist here .


“Tracking” SQL Server (and SQLSat #271 – ABQ)

I’ve noticed some range and scale issues so I took out the explicit schema creation (for now). For right now it just selects into a table, dropping the table if it already exists.

Back in October I had the opportunity to attend Jonathan Kehayias’ “SQL Server Archaeology” presentation. I’d been trying to wrap my brain around Extended Events for a while, but his presentation got me motivated to dive into the system_health Event Session.
Continue reading