Microsoft SQL Server 2008 provides a policy-based system for managing one or more instances of SQL Server along with tools for performance monitoring, troubleshooting, and tuning that enable administrators to more efficiently manage their databases and SQL Server instances.
This functionality helps streamline tasks related to ensuring security and compliance, deploying patch upgrades, and resource utilization.
Top New Features
Use Performance Data Collection to troubleshoot, tune and monitor SQL Server 2008 instances across the enterprise
Define configuration policies for your enterprise by using Policy-Based Management
Use built-in framework facets and policies to manage surface area configuration and apply best practices