SQL Server 2008 R2 – Application and Multi-Server Management
SQL Server Technical Article
Title: SQL Server 2008 R2Application and Multi-Server Management Introduction
Writers: Geoff Allix
Technical Reviewers: Joanne Hodgins, Omri Bahat, Morgan Oslake
Published: February 2010
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 easy.
This paper introduces the new extensions in SQL Server Management Studio and the Control Point Explorer, and it walks through the simple process of setting up a SQL Server managed server group, including SQL Server Control Point installation, enrolling an instance into central management, extracting Data-tier Applications from existing deployments, and deploying Data-tier Applications to the new managed server group.
Abstract courtesy : Microsoft
Reference : Pinal Dave (https://blog.sqlauthority.com)