SQL Server Performance Tuning and Optimization

SQH08 Performance Tuning When It Isn't Your Database


9:30am - 10:45am

Level: Introductory to Intermediate

Don Jones


Curriculum Director for IT Pro Content


So you're stuck maintaining SQL Server, which is being used as the back-end for an application someone else wrote. You don't have access to the code. You can't change the queries. You're scared to do ANYTHING more complicated than backups, because you don't want to break anything. But... performance is lagging. What can you safely do to tune performance without risking application downtime? Believe it or not... quite a bit! You'll learn all about it in this concise session.

You will learn:

  • Discover application self-maintenance routines to determine what's safe to touch
  • Tune indexes, server configuration, storage, and other key performance areas
  • Learn how to capture critical performance problems to report to the application vendor or developer