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™. SQL-DMF provides a flexible and scalable management framework that is adaptable to your needs. 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.

The key components of SQL-DMF are core elements of SQL Server. SQL-DMF allows you to proactively manage the SQL Server installations 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.

The illustration shows the main components of SQL-DMF.