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

image

image image image

 

image[9][1]

Find out more here

Cheers,

-Rohan