SQH08 Performance Tuning When It Isn't Your Database

11/21/2013

9:30am - 10:45am

Level: Introductory to Intermediate

Don Jones

MVP

Curriculum Director for IT Pro Content

Pluralsight

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