SQL Server 2008 R2 - Application and Multi-Server Management

SQL Server Technical Article

Writers: Geoff Allix

Technical Reviewers: Joanne Hodgins, Omri Bahat, Morgan Oslake

Published: February 2010

Applies to: SQL Server 2008 R2

Summary

SQL Server 2008 R2 introduces new management tools to help improve IT efficiency and productivity. Investments in application and multi-server management will help organizations proactively manage database environments efficiently at scale through centralized visibility into resource utilization. Such investments can help streamline consolidation and upgrade initiatives across the application lifecycle—all with tools that make it fast and straightforward.

This paper introduces the new extensions in SQL Server Management Studio and the new Utility Explorer, and it discusses the simple process of setting up a SQL Server managed server group, including Control Point installation, enrolling an instance into central management, and upgrading SQL Server databases to SQL Server 2008 R2 using the data-tier application component.

To review the document, please download the SQL Server 2008 R2 - Application and Multi-Server Management Word document.