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

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
Troubleshooting ASYNC_NETWORK_IO issues
Demo: Troubleshooting ASYNC_NETWORK_IO issues
Summary

Uploaded
http://uploaded.net/file/peujch7b/SQL_Server_-_Advanced_Extended_Events.part1.rar
http://uploaded.net/file/h42e0hya/SQL_Server_-_Advanced_Extended_Events.part2.rar
http://uploaded.net/file/iof2o3qr/SQL_Server_-_Advanced_Extended_Events.part3.rar
http://uploaded.net/file/i14k50w5/SQL_Server_-_Advanced_Extended_Events.part4.rar

Ryushare
http://ryushare.com/5767065f1036/SQL_Server_-_Advanced_Extended_Events.part1.rar
http://ryushare.com/567e31bb3fc7/SQL_Server_-_Advanced_Extended_Events.part2.rar
http://ryushare.com/55955d162c5f/SQL_Server_-_Advanced_Extended_Events.part3.rar
http://ryushare.com/55955d162c5e/SQL_Server_-_Advanced_Extended_Events.part4.rar

Rapidgator
http://rapidgator.net/file/45375b847e0b16ba89af2be80735a219/SQL_Server_-_Advanced_Extended_Events.part1.rar.html
http://rapidgator.net/file/52afbf44c5b892c0bd331f4e9161bde3/SQL_Server_-_Advanced_Extended_Events.part2.rar.html
http://rapidgator.net/file/faa7ece0386d6720f2e82f35576f9fa4/SQL_Server_-_Advanced_Extended_Events.part3.rar.html
http://rapidgator.net/file/284794f35ab890bb89436612df95003c/SQL_Server_-_Advanced_Extended_Events.part4.rar.html