Chapter 14

Performance Monitoring and Tuning

TOPICS COVERED IN THIS CHAPTER:

  • Performance Tuning Principles
  • Performance and Troubleshooting Tools
  • Blocks, Locks, and Deadlocks
  • SQL Server Profiler
  • Database Engine Tuning Advisor
  • Performance Monitoring with System Monitor
  • Using the New Resource Governor
  • Performance Studio
  • Advanced Monitoring Tools

image SQL Server 2008 database servers can be optimized to improve performance without requiring hardware upgrades; however, you must understand the tools used to analyze the performance of the server before you can decide whether or not a hardware upgrade is needed. In this chapter, you will learn about the ...

Get SQL Server® 2008 Administration: Real World Skills for MCITP Certification and Beyond now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.