THE SQL Server Blog Spot on the Web
Back in April, Paul Randal (Blog|Twitter) did a 30 day series titled A SQL Server Myth a Day, where he covered a different myth about SQL Server every day of the month. At the same time Glenn Alan Berry (Blog|Twitter) did a 30 day series titled A DMV a Day, where he blogged about a different DMV every day of the month. Being so inspired by these two guys, I have decided to attempt a month long series on Extended Events that I am going to call A XEvent a Day. I originally wanted to do this series during the month of November, but with school requirements and preparations for PASS Summit, I just couldn’t make it work out. Instead I am going to end 2010 with a bang and at the same time double my blog post count for they year by doing it in December.
This post will be the master post and will have a link to each of the posts throughout the month as I post them.
An XEvent a Day (1 of 31) – An Overview of Extended Events An XEvent a Day (2 of 31) – Querying the Extended Events Metadata An XEvent a Day (3 of 31) – Managing Event Sessions An XEvent a Day (4 of 31) – Querying the Session Definition and Active Session DMV’s An XEvent a Day (5 of 31) – Targets Week – ring_buffer An XEvent a Day (6 of 31) – Targets Week – asynchronous_file_target An XEvent a Day (7 of 31) – Targets Week – bucketizers An XEvent a Day (8 of 31) – Targets Week – synchronous_event_counter An XEvent a Day (9 of 31) – Targets Week – pair_matching An XEvent a Day (10 of 31) – Targets Week – etw_classic_sync_target An XEvent a Day (11 of 31) – Targets Week – Using multiple targets to simplify analysis An XEvent a Day (12 of 31) – Using the Extended Events SSMS Addin An XEvent a Day (13 of 31) – The system_health Session An XEvent a Day (14 of 31) – A Closer Look at Predicates An XEvent a Day (15 of 31) – Tracking Ghost CleanupAn XEvent a Day (16 of 31) – How Many Checkpoints are Issued During a Full Backup?An XEvent a Day (17 of 31) – A Look at Backup Internals and How to Track Backup and Restore Throughput (Part 1)An XEvent a Day (18 of 31) – A Look at Backup Internals and How to Track Backup and Restore Throughput (Part 2)An XEvent a Day (19 of 31) – Using Customizable FieldsAn XEvent a Day (20 of 31) – Mapping Extended Events to SQL Trace An XEvent a Day (21 of 31) – The Future – Tracking Blocking in Denali An XEvent a Day (22 of 31) – The Future – fn_dblog() No More? Tracking Transaction Log Activity in Denali An XEvent a Day (23 of 31) – How it Works – Multiple Transaction Log Files An XEvent a Day (24 of 31) – What is the package0.callstack Action? An XEvent a Day (25 of 31) – The Twelve Days of Christmas An XEvent a Day (26 of 31) – Configuring Session Options An XEvent a Day (27 of 31) – The Future - Tracking Page Splits in SQL Server Denali CTP1An XEvent a Day (28 of 31) – Tracking Page Compression OperationsAn XEvent a Day (29 of 31) – The Future – Looking at Database Startup in DenaliAn XEvent a Day (30 of 31) – Tracking Session and Statement Level WaitsAn XEvent a Day (31 of 31) – Event Session DDL Events
I really look forward to this series Jonathan!!
This should be a good series! I am looking forward to catching up.
Very cool. Looks like a have some catching up to do. Thank you for the effort to get this done.
Nice work Jonathan. I'll use this as my platform for learning xevents :-)
I think this series are different than the Paul or Glenn ones, just because they are linked very hard. I mean, is always about Extended Events (obviously), but Paul or Glenn talk about differents topics.
Anyway, this is not a complaint, is about something that (I suppose) many people could be grateful (me the first) for a document that gather all the posts in a single, unique and more easy to use object.
Could be possible? Or mybe with your whitepaper the document I talk about is not necessary...
If you have not seen it already, Jonathan Kehayias is writing a 31 day series on extended events in celebration