Chapter 1

Optimizing the Performance of Databases and Database Servers

MICROSOFT EXAM OBJECTIVES COVERED IN THIS CHAPTER:

  • Troubleshoot physical server performance.
  • Troubleshoot instance performance.
  • Troubleshoot database performance.

images One of the core responsibilities of a database administrator (DBA) is to optimize the performance of your database servers and databases. Database solutions are invariably running mission-critical systems for organizations, and it is important to quickly troubleshoot and correct any performance problems, be they at the physical server, instance, or database level.

Anyone who is not a DBA probably is not aware of ...

Get MCITP Administrator: Microsoft® SQL Server™ 2005 Optimization and Maintenance (70-444): Study Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.