Fort Worth SQL Server Users Group

 

Posts From October, 2017

-March 2024+
SMTWTFS
252627282912
3456789
10111213141516
17181920212223
24252627282930
31123456
  • RSS
  • Add To My MSN
  • Add To Windows Live
  • Add To My Yahoo
  • Add To Google

Statistics

  • Entries (106)
  • Comments (0)

Archives

Performance Monitoring and SQL Server Internals for the Poor Man 

By Andy Eggers
Posted by altadmin Monday, October 16, 2017 3:21:00 PM


Meet & Greet at 6:30PM Presentation at 7PM
Please join and RSVP at our FWSSUG MEETUP page!

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.



Freese and Nichols graciously host our group once a month at their Fort Worth location. We’re on the ground floor in their beautiful training center. Follow the tile hallway to the left of the reception desk as you walk in the front doors. 4055 International Plaza Fort Worth, Texas 76109
http://www.fwssug.com/Blog/ViewArchive.aspx?month=10&year=2017&pageid=2&mid=2