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.