Skip to content

Instantly share code, notes, and snippets.

@airtank20

airtank20/SQL Server Performance Tuning for Beginners.md

Created March 6, 2020 01:10
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save airtank20/520e97500c2d061d08faafb67a7dbf18 to your computer and use it in GitHub Desktop.
Save airtank20/520e97500c2d061d08faafb67a7dbf18 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
SQL Server Performance Tuning for Beginners.md

SQL Server Performance Tuning for Beginners

We've all had to start somewhere in our current career path. My own adventure started what feels like eons ago when I became an accidental DBA overnight and I had absolutely zero clue on how to performance tune our SQL Servers. I was stuck and wasn't quite sure where to turn. Things had to perform better but no idea where to start. Does this sound familiar? Ringing any bells? If so, this session is for you! We'll start at the ground floor and talk about the basics of how-to performance tune your SQL servers so that they run at peak performance! We'll look at configuration settings, database options, trace flags, query tuning and a few tools that can help you squeeze every ounce of performance out of SQL Server! By the end of this session, you'll walk away with a good solid understanding of how to start performance tuning. You will take away some scripts and tool suggestions that will enable you to hit the ground running back at the office!
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment