The TriPass group in Raleigh, NC has started a Special Interest Group on Advanced DBA Topics. This means we are looking for talks at a level 300 and above. Our group will normally meet the second Tuesday of the month at 6PM Eastern Standard Time. Our ambition is to have 50% female speakers. With PASS membership only being 20% female this will be a high bar to meet so we will need help to meet this goal. With the technical depth of the talks the group will be covering, we realize a lot of the speakers will be presenting remotely, which we fully set up to do. So if you are interested in speaking for this group (male or female) please email me.
To RVSP for these events join our Meetup group and watch out for the invites.
Using Extended Events to Expose Application Performance Issues by Mindy Curnutt
October 10 @ 18:00 - 20:00
When an application is performing poorly, the database is almost always suspected to be the source of the problem. Not so fast! In this session, learn how to use Extended Events in three different ways.
- The traditional “long running query” identification.
- The “thousand paper cut” diagnosis.
- Reading BETWEEN the lines to determine what is missing.
The final method, analyzing the space BETWEEN calls to the SQL Server is a non-traditional technique that can be used to identify where an application is actually the source of a performance issue and not the SQL Server.
In this session, we’ll go over all three. I’ll show you how to script each using Extended Events and Profiler Server Side traces.
Mindy Curnutt is 4X Microsoft Data Platform MVP and Idera ACE. She has been actively involved in the SQL Server Community for over a decade, presenting at various User Group Meetings, SQLPASS Summits, as well as SQLSaturdays across North America. For two years, she was a Team Lead for the SQLPASS Summit Abstract Review Process and since 2015 has served as one of the 3 SQLPASS Summit Program Managers. She was a SME for a couple of the SQL 2012 and 2014 Microsoft SQL Server Certification Exams and helped to author the MS Press Book “SQL Server 2014 – Step by Step” and is currently working on “SQL Server 2017 Inside Out”. She serves on the Board of Directors for the North Texas SQL Server User’s Group.
Mindy serves as a mentor to others, helping to educate and promote scalable and sustainable SQL Server architecture and design. She is passionate about Data Security, Accessibility, Usability, Scalability and Performance. Mindy Curnutt is an Independent Consultant. You can follow Mindy at her blog, mindycurnutt.com and on Twitter where she’s known as @sqlgirl.
She also tinkered with databases in middle school to keep her sports card collection organized.
Tracy has volunteered through the NC Guardian ad Litem program since 2003 advocating for abused and neglected foster children in court.This is her passion outside of SQL Server and favorite job.More information about this program in North Carolina can be found at http://volunteerforgal.org or the national organization CASA at http://www.casaforchildren.org.
Latest posts by Tracy Boggiano (see all)
- Creating a PowerShell Module from a DBA’s Perspective - September 26, 2017
- Automatically Fixing High VLF Count on SQL Server 2012+ - September 19, 2017
- T-SQL Tuesday #94 – Automation Through PowerShell Checking the Status of AGs - September 12, 2017