SQL Server: Replacing Profiler with Extended Events
Use your knowledge of Profiler and Trace to help learn how to effectively use their replacement: Extended Events. If you use Trace or Profiler in SQL Server, in any capacity, this course is relevant to you.
What you'll learn
There have been three new releases of SQL Server since the introduction of Extended Events (XE) in SQL Server 2008, and DBAs and Developers alike still prefer Profiler. It's time to move on. If you've tried Extended Events and struggled, or if you've been thinking about it but just aren't sure where to begin, then this course is for you. Using your existing knowledge and experience, this course will bridge the gap between Profiler and XE through a series of demos, including how to create an Extended Events session using an existing Trace, how to create one in the UI from scratch, how to analyze the data, and what to watch out for in terms of performance. If you use Trace or Profiler in SQL Server, in any capacity, regardless of what you do as part of your day-to-day job, this course is relevant to you.
Table of contents
- Introduction, the Extended Events Engine, and its Objects 3m
- Demo: Making the Leap from Profiler Trace to Extended Events - 1 5m
- Demo: Making the Leap from Profiler Trace to Extended Events - 2 10m
- Demo: Making the Leap from Profiler Trace to Extended Events - 3 8m
- Events and Event Comparison 3m
- Event Changes by Version and Considerations for Events 2m
- Predicates and Considerations for Predicates 3m
- Actions and Considerations for Actions 2m
- Targets and Considerations for Targets 2m
- The Big Picture 2m
- Event Session Options 6m
- Module Summary 1m
- Introduction 2m
- New Session Wizard, New Session, and Templates 2m
- Demo: Event Session Creation and Output Analysis in the UI - 1 10m
- Demo: Event Session Creation and Output Analysis in the UI - 2 9m
- Demo: Event Session Creation and Output Analysis in the UI - 3 7m
- Live Data Viewer, Customize Columns, Grouping and Aggregation 1m
- Expanding a Grouping and Filtering 1m
- Merging Files, Bookmarking Events, and Module Summary 2m
- Introduction and Target Basics 2m
- Event Dispatching and Revisiting the Big Picture 2m
- Event File, Event Counter, and Histogram Targets 3m
- Demo: Tracking Database File Growth Using the Histogram Target 7m
- Event Pairing and Ring Buffer Targets 3m
- Demo: Using the Ring Buffer Target 8m
- Module Summary 1m
About the author
Erin Stellato is a Principal Consultant with SQLskills and a SQL Server MVP. She has worked as a SQL Server professional since 2003, spending 12 years of her career at two different software companies. Erin discovered a passion for all things data while completing her M.S. in Motor Control at the University of Michigan. As she entered the IT field, she discovered the power of relational databases. During her IT career, Erin has worked closely with customers, users and colleagues to support bus... more