FWSSUG Monthly Meetup - October - Performance Internals - By Andy Eggers

Performance Monitoring and SQL Server Internals for the Poor Man

Presented by Andy Eggers
Meet & Greet at 6:30PM Presentation at 7PM

Abstract:
We will look at how to gather performance-tuning data, review of the SQL Server Internals and where the wait stats are collected and how to use them to determine what changes can be made to increase performance.

The Why “it Depends” is always a good starting point and where to look for setup areas to check / review. We will discover where SQL Server hides its information in public. We will only be looking at the SQL Server engine and its components.

Bio:
Andy is one of our FWSSUG officers and is about the most enthusiastic supporter of education for the SQL community. He is always the first to volunteer his support in any SQL Saturday event, and is always ready to help teach and mentor anyone who asks.
Andy keeps us focused and driving toward education with pure intent. If you want to see this guy get passionately animated, let him start talking about his business intelligence initiatives or educating the community.
Andy has end to end expertise in Data Architecture, Statistical Analysis, BIML, SQL Server 2008 through 2016 and the full Microsoft BI stack, and thrives in solving complex business problems. He holds Graduate Certifications from SMU in both Analytics and Marketing and earned his MBA from the University of Dallas.