In this session, three different approaches to using Extended Events will be covered, culminating in a non-traditional approach of using them to determine what's MISSING -- thus the application/network portion of a user experience. We will explain how to use XEvents to do the following:
- The long running query
- The thousand paper cuts -- de-parameterization and aggregation
- Looking at Space Between SQL Calls (how to determine when application slowness does NOT involve the SQL Server)
Each approach will detail the following: Creating an extended events session to capture the information you need for each scenario and how to analyze and make sense of the captured data. Lots of demos and take-away scripts!
You will learn:
- How to use XEvents from scripting
- Use XEvents to detect basic performance issues
- Acquire a new and creative technique for diagnosing application issues by using a SQL tool