SQL Server Performance Tuning and Optimization

SQW04 Does Your Performance Tuning Need a 12-Step Program?


9:30am - 10:45am

Level: Introductory to Intermediate

Janis Griffin

Database Performance Evangelist


Performance tuning can be complex. It's often hard to know which knob to turn or button to press to get the biggest performance boost. In this presentation, Database Performance Evangelist Janis Griffin will detail 12 steps to quickly identify performance issues and resolve them.

You will learn:

  • How to quickly fine tune a SQL statement
  • How to identify performance inhibitors to help avoid future performance issues
  • How to recognize and understand how new SQL Server features can help improve query performance