O'Reilly logo

Microsoft SQL Server 2008 R2 Administration Cookbook by Satya Shyam K Jayanty

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Troubleshooting multi-server instances with utility administration

Monitoring and managing multiple instances of SQL Server and databases is a very challenging task. SQL Server tools are easy to use and help to manage multi-server management through automated multi-server jobs, event forwarding and the ability to manage multiple instances from a single-machine console. Using SQL Server 2008 R2, database administrators can define and manage such tasks centrally using Utility Control Point (UCP).

UCP is a model that will represent the organization's SQL Server entities as a unified view. The viewpoints are key sectors to identify which applications use that instance. This can be handled using the SQL Server Management Studio (SSMS) tool. The following ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required