1 / 16

The X-Factor of the Extended Events Amit Khandelwal

The X-Factor of the Extended Events Amit Khandelwal. DISCLAIMER.

lludwig
Download Presentation

The X-Factor of the Extended Events Amit Khandelwal

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. The X-Factor of the Extended Events Amit Khandelwal

  2. DISCLAIMER The opinions expressed in this presentation and on the following slides are solely those of the presenter and not necessarily those of Microsoft. Microsoft does not guarantee the accuracy or reliability of the information provided herein.

  3. About me: • I am currently working as Microsoft SQL Server Support Escalation Engineer. Worked with Beta Teams for SQL Server release and masters SQL Performance, HR-DR technologies and Replication and Engine technologies. Have Authored several internal training materials. Have been speaker at many programs like SQL Server Talks, SQL Server Asia level conference and many others. Current interests in learning and working on SQL Server Azure and other cloud products of Microsoft.

  4. Agenda Introduction • Understanding the Mumbo jumbo Demos and Troubleshooting tips Extended Events Vs. Profiler Traces

  5. Introduction

  6. Introduction Introduced in SQL Server 2008, major over-hauling was done in SQL 2012. Shifting focus from SQL Server Profiler Traces A new mechanism for capturing information about events inside the Database Engine Designed from the ground up with performance as a primary focus

  7. The MUMBO - JUMBO

  8. The Jargons Package Events Actions Sessions Targets Predicates

  9. Extended Events Engine

  10. Demos and Troubleshooting tips

  11. Let’s DEMO It! • The system_health session • Default session run in background and captures some vital information to kick start troubleshooting • Hello MSFT, Is my query “Waiting”? • Let’s see how you can find wait_types, wait_resources and wait_times for your slow running queries. • Oh Gosh! It’s 100% CPU • Sneak-peek into quick troubleshooting bytes of identifying high CPU consumers and query plans.

  12. Extended events Vs. Profiler traces

  13. Extended events Vs. Profiler traces • Significantly less performance overhead than traces • The only possibility of tracing new features like FileStream, FileTable, AlwaysOn, ColumnStore, In_Memory OLTP etc. • Introduction of large number of events as compared to profiler traces. • Events and Filters can be adapted live - during active session using Extended Events "Watch Live Data" option. • Easy Automation - can be easily scripted out, easy to do grouping, aggregation, filtering on events etc. • Directly integrated in Management Studio , & choice of different targets

  14. References • http://blogs.msdn.com/b/psssql/archive/2009/04/30/why-should-i-use-extended-events-in-sql-server-2008.aspx • http://blogs.msdn.com/b/extended_events/archive/2010/04/14/introduction-to-extended-events.aspx • https://www.sqlskills.com/blogs/jonathan/extended-events-overview/ • https://technet.microsoft.com/en-us/library/bb630354(v=sql.105).aspx • http://blogs.msdn.com/b/extended_events/archive/2010/04/14/introduction-to-extended-events.aspx • http://channel9.msdn.com/posts/SQL11UPD02-REC-08

  15. Thank you for Attending Tech Unite!!!

More Related