extended events to the rescue

Extended Events to the Rescue

Guy Glantser

Image courtesy of Boians Cho Joo Young / FreeDigitalPhotos.net

Copyright © 2015 Madeira LtdAll Rights Reserved

Full rights, including copyrights, belong exclusively to Madeira LtdNo use of the materials, in any form, is allowed,

unless receiving a prior written permission from Madeira Ltd

Name: Guy GlantserEmail Address: guy@madeira.co.ilTwitter: @guy_glantserBlog: www.madeirasql.com/author/guyglantserPodcast: www.sqlserverradio.com

A Few Words about Me…

Image courtesy of Mister GC / FreeDigitalPhotos.net

Agenda

Image courtesy of Boians Cho Joo Young / FreeDigitalPhotos.net

• What is Extended Events?• Why Extended Events?• Use Cases (Demo)

So What is Extended Events?Extended Events is a general event-handling system for server systems. It has a highly scalable and highly configurable architecture that allows users to collect as much or as little information as is necessary to troubleshoot or identify a performance problem.

Image courtesy of Boians Cho Joo Young / FreeDigitalPhotos.net

No, really, what is Extended Events?

It’s a monitoring platform…

Image courtesy of Boians Cho Joo Young / FreeDigitalPhotos.net

How does it look like?

Image courtesy of Boians Cho Joo Young / FreeDigitalPhotos.net

Module

Packages

Events Targets Actions Types Predicates Maps

How does it look like?

Image courtesy of Boians Cho Joo Young / FreeDigitalPhotos.net

Is it meant to replace Profiler?

Yes!

Image courtesy of Boians Cho Joo Young / FreeDigitalPhotos.net

Is it better than Profiler?

Well… yes!

Image courtesy of Boians Cho Joo Young / FreeDigitalPhotos.net

Is it better than Profiler?

Image courtesy of Boians Cho Joo Young / FreeDigitalPhotos.net

Test Batch Requests / Sec Batch DurationBaseline 2345 00:13:35Extended Events Event File 2102 (-10%) 00:15:15Extended Events Ring Buffer 2073 (-12%) 00:15:40Trace File 1920 (-18%) 00:16:40Profiler (Remote) 260 (-89%) 02:03:20Profiler (Local) 215 (-91%) 02:29:00

Source: http://sqlperformance.com/2012/10/sql-trace/observer-overhead-trace-extended-events

Wanna see some demos?

?Image courtesy of Boians Cho Joo Young / FreeDigitalPhotos.net

Summary

Image courtesy of Boians Cho Joo Young / FreeDigitalPhotos.net

• Extended Events is the new kid in town• It has less impact on performance• It offers multiple targets• It has many configuration options• It has GUI in SSMS• You need to get used to it…

Summary

Image courtesy of Boians Cho Joo Young / FreeDigitalPhotos.net

The best resource – Jonathan Kehayiashttps://www.sqlskills.com/blogs/jonathan/category/extended-events/

Stay In Touch…

Image courtesy of Nuttapong / FreeDigitalPhotos.net

Name: Guy GlantserEmail Address: guy@madeira.co.ilTwitter: @guy_glantserBlog: www.madeirasql.com/author/guyglantserPodcast: www.sqlserverradio.com

Image courtesy of David Castillo Dominici / FreeDigitalPhotos.net