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.