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!

http://www.sqlsaturday.com/444


0 Response to "October 3rd: SQL Saturday Kansas City - Profiler is Dead! Long Live Extended Events!"

Post a Comment

Group Tools

Random Prize Winner
Use this tool to generate random numbers for prize drawings.




Follow this twitter list of the twitter accounts for the user groups. Ask for your group to be added to this list: twitter list
Subscribe to the Kansas City User Group Newspaper at Paper.li

Blog Archive

Followers