Last week was a successful sixty-seventh T-SQL Tuesday! I asked bloggers to tell me why they loved Extended Events, why they hated it, what their favorite tricks were, or what they had recently learned. I learned several new tips and tricks! Here’s a recap of the blogs. Huge thanks to all the bloggers who took time out of their week to help me – and you! – learn.
- Andrew McDermid – “Why extended? And why events?” – Andrew gives an overview of the Extended Events framework. He also talks about the difference between polling and tracing, which I think is a great point in favor of XE.
- Rob Farley – “DBAs and the Internet of Things” – “Imagine that each configured event is a smart device, sitting somewhere, producing data in some semi-structured form.” Rob tells us why he thinks DBAs should be using XE to help them be superheros in an IoT world.
- Boris Hristov – “Extended Events and... Distributed Replay?” – Distributed Replay is one of those tools, like the first iterations of XE, that I don't use enough because it's not intuitive – and there's no GUI to get started with. Boris loves it, though. Here, he walks us through how he solved the problem of capturing a workload with XE, then converted it to a trace that DR could read. This is great stuff! I love that he walks us through his troubleshooting approach.
- Wayne Sheffield – “Weaning yourself off of SQL Profiler (Part 1)” – Wayne breaks down a problem many of us have – we've been using SQL Server for so long that a lot of our default troubleshooting tools use...Profiler. How do you move from Profiler to XE? Read his blog! (And...part 1? I can't wait for the series, Wayne!)
Aaron Bertrand – “New Backup and Restore Extended Events” – Backups and restores are the bread and butter of being a
goodgreat DBA. Aaron found some new XE events for backups and restores in SQL Server 2016 CTP2. I can't wait to try these out!
- Kenneth Fisher – “A walk-through of creating the Activity Tracking template using Extended Events” – Kenneth wanted to capture query activity in a specific database, just like he could with Profiler. He walks us through setting up the same session in the XE wizard.
- Joseph Harkins – “T-SQL TUESDAY #67 EXTENDED EVENTS” – First off, let me congratulate Joseph on starting his blog. It's one of the best ways to learn and share! In his first blog, he dives into how XE can be used to validate that an Availability Group secondary set up for read-only routing is indeed receiving read-only requests. Excellent work!
- I wrote about two features I feel XE is missing in “What Extended Events is Missing“. One has a workaround; the other doesn't.
- Steve Jones – “Extended Events for DBCC” – Steve shows us how to create an XE session to track when DBCC events are run – a great tool for DBAs!
- Mike Fal – “#Powershell and Extended Events” – I know Mike, and I know he loves PowerShell, but doesn't love XE. I'm delighted he contributed to my T-SQL Tuesday on XE regardless! Mike digs into XE with POSH, showing how it can be used to get information about sessions.
- Vicky Harp – “Introduction to Idera SQL XEvent Profiler” – Do you want to set up an XE session, but use a tool that looks like Profiler? It's your lucky day! Idera has a free tool that lets you do just that! (Full disclosure: Vicky works for Idera. When she mentioned writing this blog on Twitter, I wholly supported the idea. If a vendor tools helps you get started with XE, I'm all for it!)
- Paul Randal – “Monitoring log activity with Extended Events” – If you want to learn about the transaction log, Paul is one of the best people to learn from. Here, he shows us that when a transaction commits, there is a write to the log file – using XE.
- John Morehouse – “Extended Events” – John wanted to reduce the number of SQL logins being used, in favor of Windows login. My favorite part is that he uses the histogram target for the results!
- Mark Wilkinson – “Retrieving Deadlock Graphs with PowerShell” – XE, POSH, and deadlocks? Be still, my beating nerd heart! Mark shows how to use the system_health session to view any deadlocks graphs that have been captured, then extends (get it?!) that to PowerShell. Awesome stuff!
- Jason Brimhall – “Extended Events, Birkenstocks and SQL Server” – Jason wins Most Creative Blog Title this month! If your SQL Servers are set to tree-hugger mode – Power Saving – they are not pushing out the CPU cycles you need. How can you tell? XE to the rescue! I loved this blog post.
- Chris Yates... TBD. Yep, Chris, you said you were going to write a post, and I'm eagerly waiting to read it!
What a great set of blogs to read! I hope this keeps you busy reading and learning for a couple of weeks…just in time to catch the July 2015 edition of T-SQL Tuesday!