Wed, Oct 23 2013 12:00 Eastern Daylight Time
Making the Leap from Profiler to Extended Events
If you’re like me, you’ve been using SQL Trace and Profiler since you started using SQL Server. They’re like old friends, tried and true. You know how they work, you know what you can capture, and you know how to find the data you need. But now you’ve been told that your good friends have been deprecated in SQL Server 2012, and you need to become best friends with Extended Events. What is THAT all about?
It’s OK. Really. In this session, we’ll look at Profiler and Extended Events side by side to see how easy it is to transition to Extended Events. We’ll step through real-world examples using Extended Events to do what you’re used to doing with Trace, and more. This session is applicable whether you're running SQL Server 2008 or 2012, and you'll walk out with a set of scripts to get you started. If you’ve been putting off learning Extended Events because you just don’t think you have the time (even if you’ve never used Profiler), this is the session for you. You CAN find the time…today.
Erin Stellato is a Principal Consultant with SQLskills and lives in Cleveland, OH. She has over 15 years of technology experience and has worked with SQL Server since 2003. Her areas of interest include internals, performance tuning, and high availability and disaster recovery.
Erin is a SQL Server MVP and an active member of the SQL Server community. She is involved with the Ohio North SQL Server User Group and blogs at SQLskills.com/blogs/erin. You can find her on Twitter at @ErinStellato.
May 11: Noon Mountain
May 25: Noon Eastern
About the recording for September 23: You may want to advance
the video about 5 minutes into the file.
The DBA Virtual Chapter presentations are recorded. On the Meeting Archive page, you will find .WMV files that can be viewed on-line.
We can always use people to give a talk at one of our bi-monthly events. If you are interested in giving a presentation, please send your title, a brief abstract and a brief bio to Sharon Dooley, firstname.lastname@example.org.
The DBA Virtual Chapter holds two webinars each month. The first one is on the second Wednesday at noon, Mountain time and the second one is on the fourth Wednesday at noon, Eastern time. These 1 - 1¼ hour presentations include slides, demos and a time for questions and answers. The meetings are recorded and archived.