SQL Server: Advanced Extended Events
Learn how to use the advanced features of Extended Events for more in-depth troubleshooting on SQL Server, either through Transact-SQL or the Extended Events UIs, applicable for developers and DBAs who have some Extended Events and troubleshooting experience, for SQL Server 2008 onwards
What you'll learn
This course builds on the SQL Server: Introduction to Extended Events course and delves deeper into the Extended Events system to show you more advanced features, options, targets, and scenarios. The course starts by showing how to develop more powerful event sessions and also set the various event session options to control memory management, event dispatching and retention, and how to track linked events. It then presents the advanced event targets, along with the potential problems you may encounter when using them, and the advanced features of the SQL Server 2012 Extended Events UI in Management Studio, and how to leverage Extended Events using both the .NET API and PowerShell. The course ends by presenting some complex troubleshooting scenarios and shows how they can be investigated using Extended Events.This course is perfect for those with some experience of Extended Events and troubleshooting, as all the knowledge in the SQL Server: Introduction to Extended Events course is assumed. The information in the course applies to all versions from SQL Server 2008 onwards.
Table of contents
- Introduction 3m
- Using Textual Comparators 3m
- Demo: Sampling Events with package0.divides_by_uint64 4m
- Demo: Tracking Long Statement Executions 4m
- Controlling Event Execution Count 2m
- Demo: Using package0.counter 4m
- The sql_text Action 2m
- Demo: sql_text Action 5m
- Determining Execution Path with tsql_stack 2m
- Demo: tsql_stack Action 7m
- Side-impacting Actions 3m
- Demo: Collecting a Memory Dump 4m
- Summary 1m
- Introduction 2m
- Memory Buffer Configuration 3m
- Demo: MAX_MEMORY Setting 4m
- Demo: Preventing Live Data Viewer Disconnects 4m
- Memory Buffer Configuration (2) 3m
- Demo: MEMORY_PARTITION_MODE Setting 4m
- Memory Buffer Configuration (3) 3m
- Demo: MAX_EVENT_SIZE Setting 3m
- Event Dispatch and Retention 3m
- Demo: EVENT_RETENTION_MODE Setting 2m
- Demo: MAX_DISPATCH_LATENCY Setting 2m
- Session Startup and Event Correlation 3m
- Demo: STARTUP_STATE Setting 3m
- Demo: TRACK_CAUSALITY Setting 4m
- Summary 2m
- Introduction 2m
- histogram Target 1m
- histogram Target Options 3m
- Demo: histogram Target 7m
- pair_matching Target 2m
- pair_matching Target Options 2m
- pair_matching Target Options (2) 3m
- Demo: pair_matching Target 5m
- Troubleshooting invalid pairs 2m
- Demo: Troubleshooting invalid pairs 4m
- event_counter Target 2m
- Demo: event_counter Target 2m
- etw_classic_sync_target Target 2m
- etw_classic_sync_target Target Options 2m
- Demo: etw_classic_sync_target Target 8m
- etw_classic_sync_target Target Limitations 2m
- Demo: etw_classic_sync_target Target Limitations 5m
- Summary 2m
- Introduction 1m
- Grouping and Aggregating Data 2m
- Demo: Grouping and Aggregating Data 4m
- Merging Files 2m
- Demo: Merging Files (system_health) 2m
- Demo: Merging Files with Server Audit 3m
- Designing Event Sessions for Advanced Analysis 2m
- Demo: Designing Event Sessions for Advanced Analysis 5m
- Summary 2m
- Introduction 1m
- Considerations for Leveraging the .NET API 2m
- Extended Events Object Model 2m
- Demo: Extended Events Object Model 6m
- Using the Extended Events Reader 3m
- Using the Extended Events Reader (2) 2m
- Reading Files with QueryableXEventData 2m
- Demo: Reading Event Files with QueryableXEventData 5m
- Reading Live Data with QueryableXEventData 3m
- Demo: Reading Live Data with QueryableXEventData 5m
- Using the PowerShell Provider 2m
- Demo: Using the PowerShell Provider 5m
- Summary 1m
- Introduction 2m
- Tempdb Latch Contention 3m
- Demo: Tempdb Latch Contention 7m
- Lock Escalation 2m
- Demo: Lock Escalation 8m
- Problematic Page Splits 2m
- Demo: Problematic Page Splits 5m
- Troubleshooting Orphaned Transactions 2m
- Demo: Troubleshooting Orphaned Transactions 3m
- Troubleshooting ASYNC_NETWORK_IO issues 3m
- Demo: Troubleshooting ASYNC_NETWORK_IO issues 5m
- Summary 1m
About the author
Jonathan Kehayias is a Principal Consultant with SQLskills. He is the youngest person ever to achieve the Microsoft Certified Master - SQL Server 2008 certification and has been a SQL Server MVP for many years. Jonathan is heavily involved in the SQL community; including being the top answerer on the MSDN Database Engine forum, writing deep technical content on his blog (plus his old blog, and answering questions as @SQLPoolBoy on Twitter. Jonathan is a performance tuning expert, both SQL Se... more