extended events to the rescue
TRANSCRIPT
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: [email protected]: @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: [email protected]: @guy_glantserBlog: www.madeirasql.com/author/guyglantserPodcast: www.sqlserverradio.com
Image courtesy of David Castillo Dominici / FreeDigitalPhotos.net