Taking advantage of the two new manageability features Policy Based Management and Data Collector of SQL Server 2008 which are independent of each other the multi-server management addresses problems by providing further solutions to the DBAs. The lack of manageability tools to manage multiple instances by understanding resource utilization and enhancing effective reporting tools is plugged in using multi-server management from SQL Server 2008 R2.

This recipe is intended to design the multi-server management component using SQL Server 2008 R2 for data-tier applications (DAC). By operating the SQL Server Management Studio or Visual Studio with the help of Utility Explorer (UE), we can design the Multi-Server Management (MSM) component. The MSM provides several ways to view summary and detailed data about the health state of managed instances of SQL Server. An additional capability of UE enables the interface to view and manage policy...