Profiler is Dead! Long Live Extended Events!
July 10, 2015 @ 11:30 am - 1:00 pm| Free
Topic: Profiler is Dead! Long Live Extended Events!
Presenter: Keith Tate
When: Friday July 10, 2015 @ 11:30am
Location: ITT Tech 5100 Masthead St NE, Albuquerque, NM 87109
Overview: 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!
Bio: Keith Tate is a Microsoft Certified Master in SQL Server 2008 and 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.
Please RSVP to Willis Johnson(Willis.Johnson@rht.com