Extended Events to the Rescue

Extended Events is a highly scalable and highly configurable monitoring platform, which every DBA must be familiar with. It has many advantages over alternative tools, such as SQL Trace or Dynamic Management Views. In some cases, it is the only tool that can provide the desired monitoring solution.
In this session we will demonstrate several common use cases, such as monitoring query waits, troubleshooting deadlocks and monitoring page splits. We will demonstrate how to setup an event session for each use case, and how to analyze the collected data in a meaningful way. By the end of this session, you'll have several practical monitoring and troubleshooting solutions to apply on your environment.
Presented by Guy Glantser at SQLBits XII
Tags (no tags)
  • Downloads
    Sorry, there are no downloads available for this session.
  • SpeakerBIO
    guy_glantser.jpg
    Guy Glantser is the leader of the Israeli SQL Server user group and also the CEO of Madeira SQL Server Services. His career has been focused on SQL Server for the past 17 years, performing various database roles as either an on-site DBA, an external consultant or an instructor. Guy is involved in many activities in the SQL Server community. He occasionally speaks at community events, such as PASS Summit, Tech-Ed and user groups around the world. He also co-hosts the SQL Server radio show (www.sqlserverradio.com).
    http://www.madeirasql.com/author/guyglantser/ http://www.madeirasql.com/feed/
  • Video
    The video is not available to view online.