Microsoft Certified IT Professional/Exam 70-444/Designing a Strategy to Monitor and Maintain a Database Solution

Designing a Strategy to Monitor and Maintain a Database Solution

  • 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.
  • Create and implement a maintenance strategy for database servers.
    • Create a job dependency diagram.
    • Manage the maintenance of database servers.
  • Design a database maintenance plan.
  • Design a strategy to manage Reporting Services.
Last modified on 13 July 2006, at 06:58