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.

https://swasheck.wordpress.com/presentations/

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

Advertisements

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

**
Update
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