United States   Change   |   All Microsoft Sites

Home

Microsoft Home  |  Servers and Tools


Manageability

Elevating Administrator Productivity

Microsoft SQL Server 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.
  • Scale with ease

    New Policy-Based Management scales across multiple servers, making it easy to enforce consistent configuration policies across the enterprise.

  • Conform to desired intent

    Administrators can get a logical view of the system configuration with innovative policy framework, enabling them to proactively define the desired configuration of data services.

  • Monitor and optimize to maximize performance

    Monitor and optimize the performance of your data services.

  • Increase visibility into system health

    SQL Server Management Studio includes a number of standard administrative reports that you can use to view information about your SQL Server instances, databases, and other objects.

Highlighted Capability

Policy-Based Management

Policy-Based Management

Click image to see larger view

Top New Features

  • Use Performance Studio 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 Policy-Based Management facets and policies to manage surface area configuration and apply best practices.

News and Reviews

 

Compare all features supported by the SQL Server 2008 editions.

Take a closer look

Related Links

TechNet - Resources for IT Professionals