Writers: Tom Davidson, Lara Rubbelke, Dmitri Tchikatilov

Contributor: Sanjay Mishra

Technical Reviewers: Lindsey Allen, Hongfei Guo, Prem Mehra, Joseph Sack, Jimmy May, Glenn Berry (SQL Server MVP), Michael Thomassy

 

The Enterprise Policy Management (EPM) Framework leverages and extends the new Microsoft SQL Server 2008 Policy-Based Management feature across an entire SQL Server enterprise, including down-level instances of SQL Server such as SQL Server 2000 and SQL Server 2005. In addition, the EPM Framework can be used to:

  • Automate the evaluation of policies against a defined set of SQL Server instances, including SQL Server 2000 and SQL Server 2005.
  • Centralize the policy evaluation history to a single source for enterprise policy reporting.
  • Define best practices for implementing policy evaluation in extremely large enterprise environments.

This document provides best practice guidance on the use of the EPM Framework as a means of collecting and reporting on policy compliance across an entire SQL Server enterprise.

For more information, please refer to the Enterprise Policy Management Framework with SQL Server 2008 whitepaper.