Chapter 4: Designing a Strategy to Monitor a Database Solution


Microsoft Exam Objectives Covered in this Chapter:

  • image from book 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.

  • image from book Choose the appropriate information to monitor.

Designing a strategy to monitor a database solutionwe 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 Server books! But we do it for the love, not the money.

The shame, of course, is that although it might require a bit more initial thought, effort, and planning, the benefits of implementing performance baselines and some sort of monitoring strategy will pay off in spades relatively quickly. And the end result of that initial effort is replicable across the board to all SQL Servers within your enterprise.

And it is not difficult to do, because SQL Server 2005 has all the tools you need to implement a database monitoring solution. All you need is time, a rare commodity in the modern world.

In this chapter, you will examine how you go about implementing a strategy to monitor a database solution. We will help you get started by suggesting the important metrics to monitor and what thresholds to use. As always, this represents a starting point, so feel free to customize and expand as required for your environment and operational factors.



MCITP Administrator. Microsoft SQL Server 2005 Optimization and Maintenance Study Guide (70-444)
MCITP Administrator: Microsoft SQL Server 2005 Optimization and Maintenance (Exam 70-444) Study Guide
ISBN: 0470127457
EAN: 2147483647
Year: 2004
Pages: 146

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net