SQL Distributed Management Framework

The SQL Distributed Management Framework (SQL-DMF) is an integrated framework of objects, services, and components used to manage Microsoft® SQL Server™ 2000. SQL-DMF provides a flexible and scalable management framework that is adaptable to the requirements of an organization. It lessens the need for user-attended maintenance tasks (such as database backup and alert notification) by providing services that interact directly with SQL Server 2000.

The key components of SQL-DMF support the proactive management of the instances of SQL Server on your network by allowing you to define:

• All SQL Server objects and their permissions.
  
  
• Repetitive administrative actions to be taken at specified intervals or times.
  
  
• Corrective actions to be taken when specific conditions are detected. The corrective actions can either be tasks defined to resolve the issue, or alerts by pages or e-mail to people who can resolve the issue.

This illustration shows the main components of SQL-DMF.