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: Introduction to Extended Events

Course Summary

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 a


  • +

    Course Syllabus

    ● Introduction
        ◦ Introduction
        ◦ What are Extended Events?
        ◦ Why Replace SQL Trace
        ◦ The Extended Events Solution
        ◦ Course Structure
    ● Extended Events Architecture
        ◦ Introduction
        ◦ Extended Events Engine
        ◦ Event Sessions
        ◦ Extended Events Architecture
        ◦ Event Execution Lifecycle
        ◦ Event Session Isolation
        ◦ Dispatching
        ◦ Summary
    ● Extended Events Objects
        ◦ Introduction
        ◦ Packages
        ◦ Demo: Packages
        ◦ Events
        ◦ Demo: Events
        ◦ Predicates
        ◦ Demo: Predicates
        ◦ Actions
        ◦ Demo: Actions
        ◦ Targets
        ◦ Demo: Targets
        ◦ Types and Maps
        ◦ Demo: Types and Maps
        ◦ Metadata Catalog Views
        ◦ Summary
    ● SQL Server 2012 UI Integration
        ◦ Introduction
        ◦ New Event Session Wizard
        ◦ Demo: New Event Session Wizard
        ◦ New Session Dialog
        ◦ Demo: New Session Dialog
        ◦ Using Templates
        ◦ Default Templates (1)
        ◦ Demo: Count Query Locks
        ◦ Default Templates (2)
        ◦ Demo: Query Detail Sampling
        ◦ Default Templates (3)
        ◦ Demo: Query Wait Statistic
        ◦ Default Templates (4)
        ◦ Demo: Activity Tracking
        ◦ Custom Templates
        ◦ Demo: Using Templates
        ◦ Viewing Target Data
        ◦ Demo: Viewing Target Data
        ◦ Customizing the Data View
        ◦ Demo: Customizing the Data View
        ◦ Live Data Viewer
        ◦ Demo: Live Data Viewer
        ◦ Exporting the Event Data
        ◦ Demo: Exporting the Event Data
        ◦ Summary
    ● SQL Server 2008 SSMS Add-in
        ◦ Introduction
        ◦ Demo: Installing the Add-in
        ◦ Metadata Viewer
        ◦ Demo: Metadata Viewer
        ◦ Session Editor Dialog
        ◦ Demo: Session Editor
        ◦ Target Data Viewer
        ◦ Demo: Target Data Viewer
        ◦ Add-in Options
        ◦ Demo: Add-in Options
        ◦ Summary
    ● Defining Event Sessions
        ◦ Introduction
        ◦ Event Session Requirements
        ◦ Demo: Event Session Requirements
        ◦ Basic Predicates
        ◦ Demo: Predicate Definitions
        ◦ Understanding and Planning for Short Circuiting
        ◦ Demo: Writing Predicates to Short Circuit
        ◦ Adding Data with Actions
        ◦ Demo: Using Actions
        ◦ Summary
    ● Event Session Management
        ◦ Introduction
        ◦ Event Session DDL Commands
        ◦ Creating an Event Session
        ◦ Modifying an Event Session
        ◦ Demo: Event Session DDL
        ◦ Event Session Management
        ◦ Demo: Event Session Management Concepts
        ◦ Session Definition Views
        ◦ Demo: Session Definition Views
        ◦ Active Session DMVs
        ◦ Demo: Active Session DMVs
        ◦ Summary
    ● Basic Targets
        ◦ Introduction
        ◦ ring_buffer Target
        ◦ Demo: ring_buffer Target
        ◦ ring_buffer Target Options
        


    Course Fee:
    USD 29

    Course Type:

    Self-Study

    Course Status:

    Active

    Workload:

    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
    REDHERRING
    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