MCITP Administrator: Microsoft® SQL Server™ 2005 Optimization and Maintenance (70-444): Study Guide

Chapter 4

Designing a Strategy to Monitor a Database Solution

MICROSOFT EXAM OBJECTIVES COVERED IN THIS CHAPTER:

• Define and implement monitoring standards for a physical server.
  • Establish the thresholds for performance.
  • Establish the baselines for performance.
  • Define which types of information to monitor on the physical server.
  • Define traces.
  • Set alerts.
  • Set notifications.
• Choose the appropriate information to monitor.

Designing a strategy to monitor a database solution…we wish we had a dollar for every site that we have worked at that did not have some monitoring solution for its SQL Server instances. We'd be rich and not have to write SQL ...