SQL Server: Introduction to Extended Events

Unlock Powerful SQL Server Troubleshooting with Extended Events

Are you a developer or DBA looking for advanced ways to analyze and troubleshoot your SQL Server environment? Extended Events were introduced in SQL Server 2008 and have revolutionized how we approach performance analysis and problem-solving, enabling troubleshooting scenarios previously unattainable. With the deprecation of SQL Trace in SQL Server 2012, mastering Extended Events is no longer optional – it's essential.

This comprehensive course provides a deep dive into SQL Server Extended Events, covering everything from the underlying architecture to practical application. You'll learn how to:

• Understand the Architecture: Gain a solid foundation in how Extended Events work within SQL Server.
• Create and Manage Event Sessions: Master the creation and management of event sessions, utilizing key components like:
  • Events: Identify specific server activities to monitor.
  • Actions: Define what happens when an event occurs.
  • Predicates: Filter events based on specific criteria.
  • Targets: Direct event data to appropriate destinations.
• Leverage SQL Server Management Studio (SSMS): Explore the robust Management Studio UI for Extended Events, introduced in SQL Server 2012.
• Utilize the SSMS Add-in: Discover the freely-available SSMS add-in, developed by Jonathan, for enhanced Extended Events management in SQL Server 2008 and 2008R2.
• Troubleshoot Common Scenarios: Apply your knowledge to resolve real-world issues with practical troubleshooting examples.

This course is designed for a wide range of skill levels:

• Beginners: No prior experience with Extended Events is required.
• New to the UI: Learn to navigate and utilize the Extended Events interfaces.
• Experienced Users: Solidify your understanding and deepen your expertise in Extended Events.

The information presented is applicable to all versions of SQL Server from 2008 onwards, ensuring long-term value and relevance. Learn to harness the power of Extended Events to proactively monitor, diagnose, and resolve issues in your SQL Server databases.