Next Meeting: Fri, Jul 10 2015
Event Type: In-Person
Online Meeting URL: None
UTC : Fri, Jul 10 2015 17:30 - 19:30
Event Time : Fri, Jul 10 2015 11:30 - 13:30 Mountain Daylight Time
Your Local Time: Fri, Jul 10 2015 17:30 - 19:30
5100 Masthead St NE
Albuquerque, New Mexico
Profiler is Dead! Long Live Extended Events!
Keith Tate, Database Administrator ALC Solutions
Did you know that Profiler and SQL Trace are deprecated? I know it still works (even in SQL Server 2016 CTP2), but it will never be updated with the latest features. In fact it will never be updated at all! That means if you want to capture information about any new feature, from version SQL Server 2012 and beyond, you need to use another tool.
That new tool is Extended Events (XE). Not only has it replaced Profiler, and can be used to capture information on all new features, but it is a substantially better tool!
In this session we will discuss the architecture of Extended Events, how to setup a new trace from scratch or convert an existing Profiler trace, and the new abilities that never existed in Profiler. We will also cover the difference in overhead cost of Profiler and Extended Events.
Profiler was a friend of mine, but it is time to embrace the new king!
Keith Tate is a Senior Database Administrator with over 14 years of experience as a data professional. During Keith's professional career he has been a developer, DBA and data architect. Keith is also active in the SQL Server community and is currently the chapter leader of the Albuquerque SQL Server User Group.