Albuquerque SQL Server User Group

What's Happening?

Next Meeting: Fri, Oct 13 2017

October Meeting

Language: English
Event Type: In-Person
Online Meeting URL: None
RSVPURL: https://www.meetup.com/Albuquerque-SQL-Server-User-Group/events/242411096/

October Meeting: Profiler Is Dead! Long Live Extended Events! - with Keith Tate

The Albuquerque SQL Server User Group (ABQSQL) will be having its next meeting on Friday, October 13th from 11:30 AM to 1:00 PM at Hospital Services Corporation, 7471 Pan American Freeway NE.

Keith Tate will be sharing his insights on using Extended Events.  Please join us for his presentation “Profiler is Dead!  Long Live Extended Events!”  Ask Keith questions, get to know your peers, and have lunch on us!

Presentation description: "Did you know that Profiler and SQL Trace are deprecated?  I know it still works, 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!"

Attend this FREE SQL training event!

Kindly RSVP so we know how much Pizza we should buy!

When

iCal
UTC : Fri, Oct 13 2017 17:30 - 19:00
Event Time : Fri, Oct 13 2017 11:30 - 13:00 Mountain Daylight Time
Your Local Time: Fri, Oct 13 2017 17:30 - 19:00

Where

7471 Pan American
Albuquerque, New Mexico

Direction: None

Featured Presentation

Profiler Is Dead! Long Live Extended Events!

Speaker: Keith Tate, Database Administrator ALC Solutions

Summary: Did you know that Profiler and SQL Trace are deprecated? I know it still works, 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!

About Keith: Keith Tate is a Senior Database Administrator with over 17 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.

Attachments

Please be sure to check out our Meetup.com page, and RSVP there for our monthly meetings.

PASS membership is not a prerequisite to attend this or any other monthly meeting of the Albuquerque SQL Users Group, however, you can enjoy many benefits of being a member by signing up for a FREE PASS membership at http://www.pass.org/.

Sponsors

PASSChapterLogo100.jpg  

 

 


 

Back to Top
cage-aids
cage-aids
cage-aids
cage-aids