Next Meeting: Tue, Jul 28 2015
July User Group Meeting
Event Type: In-Person
Online Meeting URL: None
UTC : Tue, Jul 28 2015 21:00 - 23:00
Event Time : Tue, Jul 28 2015 17:00 - 19:00 Eastern Daylight Time
Your Local Time: Tue, Jul 28 2015 21:00 - 23:00
2000 Technology Dr
Geekin’ Out on Extended Events -Deconstructing the system_health session to solve performance issues
Janis Griffin, Database Performance Evangelist / Senior DBA SolarWinds
Extended Events are used to gather a wide range of performance information to help troubleshoot performance problems in SQL Server. The system_health session is an Extended Events session that is included by default with SQL Server. This session starts automatically when the SQL Server database engine starts, and runs without any noticeable performance effects. This presentations will take you on an in-depth tour of the data provided in the system_health event session and how to use it to troubleshoot performance issues. Cases studies from real-life examples will be used to demonstrate tips and tricks.
Janis Griffin has over 25 years of DBA experience including design, development and implementation of many critical database instances. Her primary focus has always been database performance. Before coming to SolarWinds (formerly Confio), she held many DBA positions, primarily in the Telecom/Network Industry, working with real-time network / OLTP databases. At SolarWinds, her primary focus is assisting customers in finding and fixing database performance issues. She is a well known SQL Saturday speaker, often speaks at Virtual PASS (Database / Performance chapters) and gives performance webinars for Solarwinds.