Wed, Oct 23 2013 12:00 (GMT-05:00) Eastern Time (US & Canada)
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 12 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.
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, email@example.com.
March 26 Noon Eastern Grant Fritchey Query Performance Tuning for Azure SQL Database
April 9 Noon Mountain Microsoft Countdown to SQL Server 2014 AlwaysOn in 2014
The DBA Virtual Chapter holds two monthly live meeting events on the second Wednesday of every month at noon, Mountain time and on the fourth Wednesday of every month 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.
We thank our sponsor