SQL Server for Developers

SQT13 Reading Between the Lines: Using XEvents to Diagnose Application Issues


4:15pm - 5:30pm

Level: Intermediate

Mindy Curnutt

Mindy Curnutt & Associates Consulting

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:

  1. The long running query
  2. The thousand paper cuts -- de-parameterization and aggregation
  3. 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