Welcome

Passionately curious about Data, Databases and Systems Complexity. Data is ubiquitous, the database universe is dichotomous (structured and unstructured), expanding and complex. Find my Database Research at SQLToolkit.co.uk . Microsoft Data Platform MVP

"The important thing is not to stop questioning. Curiosity has its own reason for existing" Einstein



Tuesday 16 June 2015

31 days of Extended Events

A came across this excellent series of blog posts by Jonathan Kehayias to help provide a jumpstart to using Extended Events.


XEvents. XEvent A Day: 31 days of Extended Events bit.ly/1GpFptP


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 Cleanup
An 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 Fields
An 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 CTP1
An XEvent a Day (28 of 31) – Tracking Page Compression Operations
An XEvent a Day (29 of 31) – The Future – Looking at Database Startup in Denali
An XEvent a Day (30 of 31) – Tracking Session and Statement Level Waits
An XEvent a Day (31 of 31) – Event Session DDL Events