SQL Server 2008 Manageability

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



Find out more here



Technorati Tags: Server Server Manageability