MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.

I'm not curious

SQL Server: Advanced Extended Events

Course Summary

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 e

  • +

    Course Syllabus

    ● Introduction
        ◦ Introduction
        ◦ Why a Separate Advanced Course?
        ◦ Course Structure
    ● Getting More From Event Sessions
        ◦ Introduction
        ◦ Using Textual Comparators
        ◦ Demo: Sampling Events with package0.divides_by_uint64
        ◦ Demo: Tracking Long Statement Executions
        ◦ Controlling Event Execution Count
        ◦ Demo: Using package0.counter
        ◦ The sql_text Action
        ◦ Demo: sql_text Action
        ◦ Determining Execution Path with tsql_stack
        ◦ Demo: tsql_stack Action
        ◦ Side-impacting Actions
        ◦ Demo: Collecting a Memory Dump
        ◦ Summary
    ● Event Session Options
        ◦ Introduction
        ◦ Memory Buffer Configuration
        ◦ Demo: MAX_MEMORY Setting
        ◦ Demo: Preventing Live Data Viewer Disconnects
        ◦ Memory Buffer Configuration (2)
        ◦ Demo: MEMORY_PARTITION_MODE Setting
        ◦ Memory Buffer Configuration (3)
        ◦ Demo: MAX_EVENT_SIZE Setting
        ◦ Event Dispatch and Retention
        ◦ Demo: EVENT_RETENTION_MODE Setting
        ◦ Demo: MAX_DISPATCH_LATENCY Setting
        ◦ Session Startup and Event Correlation
        ◦ Demo: STARTUP_STATE Setting
        ◦ Demo: TRACK_CAUSALITY Setting
        ◦ Summary
    ● Advanced Targets
        ◦ Introduction
        ◦ histogram Target
        ◦ histogram Target Options
        ◦ Demo: histogram Target
        ◦ pair_matching Target
        ◦ pair_matching Target Options
        ◦ pair_matching Target Options (2)
        ◦ Demo: pair_matching Target
        ◦ Troubleshooting invalid pairs
        ◦ Demo: Troubleshooting invalid pairs
        ◦ event_counter Target
        ◦ Demo: event_counter Target
        ◦ etw_classic_sync_target Target
        ◦ etw_classic_sync_target Target Options
        ◦ Demo: etw_classic_sync_target Target
        ◦ etw_classic_sync_target Target Limitations
        ◦ Demo: etw_classic_sync_target Target Limitations
        ◦ Summary
    ● Advanced UI Features
        ◦ Introduction
        ◦ Grouping and Aggregating Data
        ◦ Demo: Grouping and Aggregating Data
        ◦ Merging Files
        ◦ Demo: Merging Files (system_health)
        ◦ Demo: Merging Files with Server Audit
        ◦ Designing Event Sessions for Advanced Analysis
        ◦ Demo: Designing Event Sessions for Advanced Analysis
        ◦ Summary
    ● Extended Events .NET API and PowerShell Integration
        ◦ Introduction
        ◦ Considerations for Leveraging the .NET API
        ◦ Extended Events Object Model
        ◦ Demo: Extended Events Object Model
        ◦ Using the Extended Events Reader
        ◦ Using the Extended Events Reader (2)
        ◦ Reading Files with QueryableXEventData
        ◦ Demo: Reading Event Files with QueryableXEventData
        ◦ Reading Live Data with QueryableXEventData
        ◦ Demo: Reading Live Data with QueryableXEventData
        ◦ Using the PowerShell Provider
        ◦ Demo: Using the PowerShell Provider
        ◦ Summary
    ● Advanced Troubleshooting Scenarios
        ◦ Introduction
        ◦ Tempdb Latch Contention
        ◦ Demo: Tempdb Latch Contention
        ◦ Lock Escalation
        ◦ Demo: Lock Escalation
        ◦ Problematic Page Splits
        ◦ Demo: Problematic Page Splits
        ◦ Troubleshooting Orphaned Transactions
        ◦ Demo: Troubleshooting Orphaned Transactions

    Course Fee:
    USD 29

    Course Type:


    Course Status:



    1 - 4 hours / week

    This course is listed under Development & Implementations and Data & Information Management Community

Attended this course?

Back to Top

Awards & Accolades for MyTechLogy
Winner of
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url

Back to Top