SQL Server: Introduction to Extended Events
Learn how to use Extended Events to perform analysis and troubleshooting on SQL Server using either Transact-SQL or the Extended Events UIs. Applicable for developers, DBAs and anyone who uses SQL Server from SQL Server 2008 onwards.
What you'll learn
Extended Events were added in SQL Server 2008 as a method of performing analysis and troubleshooting of SQL Server, with the ability to troubleshoot scenarios that have never been possible before. SQL Trace has finally been deprecated in SQL Server 2012 and so it is now imperative that developers and DBAs learn how to use Extended Events. This course explains the architecture of Extended Events, and how to create and manage event sessions, using events, actions, predicates, and basic targets. It then gives comprehensive coverage of the Management Studio UI for Extended Events that was added in SQL Server 2012, as well as the freely-available SSMS add-in that Jonathan wrote for SQL Server 2008 and 2008R2. The course ends by presenting some common troubleshooting scenarios that can be easily accomplished using Extended Events. It is perfect for those with no experience of Extended Events, those who are new to the Extended Events UIs and those with some experience but who want to solidify their understanding of Extended Events and how to use them. The information in the course applies to all versions from SQL Server 2008 onwards.
Table of contents
- Introduction 2m
- New Event Session Wizard 2m
- Demo: New Event Session Wizard 6m
- New Session Dialog 2m
- Demo: New Session Dialog 7m
- Using Templates 1m
- Default Templates (1) 1m
- Demo: Count Query Locks 4m
- Default Templates (2) 1m
- Demo: Query Detail Sampling 3m
- Default Templates (3) 1m
- Demo: Query Wait Statistic 4m
- Default Templates (4) 3m
- Demo: Activity Tracking 4m
- Custom Templates 1m
- Demo: Using Templates 5m
- Viewing Target Data 2m
- Demo: Viewing Target Data 2m
- Customizing the Data View 3m
- Demo: Customizing the Data View 5m
- Live Data Viewer 2m
- Demo: Live Data Viewer 4m
- Exporting the Event Data 2m
- Demo: Exporting the Event Data 3m
- Summary 1m
- Introduction 1m
- Event Session DDL Commands 2m
- Creating an Event Session 2m
- Modifying an Event Session 1m
- Demo: Event Session DDL 3m
- Event Session Management 2m
- Demo: Event Session Management Concepts 7m
- Session Definition Views 1m
- Demo: Session Definition Views 4m
- Active Session DMVs 2m
- Demo: Active Session DMVs 5m
- Summary 2m
- Introduction 2m
- ring_buffer Target 2m
- Demo: ring_buffer Target 2m
- ring_buffer Target Options 2m
- Demo: ring_buffer Target Options 5m
- ring_buffer XML Output 1m
- Demo: ring_buffer XML Output 3m
- Event XML 3m
- Demo: Event XML 4m
- event_file Target 2m
- Demo: event_file Target 2m
- event_file Target Options 2m
- Demo: event_file Target Options 2m
- Reading event_file Data With Transact-SQL 2m
- Demo: Using sys.fn_xe_file_target_read_file 7m
- Summary 1m
- Introduction 2m
- Identifying Deadlock Issues 3m
- Demo: Identifying Deadlock Issues 5m
- Identifying Blocking Issues 2m
- Demo: Identifying Blocking Issues 4m
- Identifying Recompile Issues 2m
- Demo: Identifying Recompile Issues 5m
- Identifying When Errors Occur 2m
- Demo: Identifying When Errors Occur 6m
- Tracking Session-Level Waits 2m
- Viewing Historical System Health 3m
- Demo: Historical System Health 3m
- Summary 2m
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