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
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.