Chapter 16. Multiserver management and Utility Explorer—best tools for the DBA

Satya Shyam K Jayanty

As a DBA, you need to be proactive to be able to multitask database maintenance, security, availability, manageability, and performance-tuning chores. SQL Server 2008 and SQL Server 2008 R2 tools will help you accomplish the required level of responsibilities.

In this chapter, we’ll go through the SQL Server tools that can help you manage and administer multiple SQL Server instances and data-tier applications. We’ll also spotlight the Utility Control Point (UCP) feature, which can help DBAs to accomplish the multiserver management and administration of their data platform. This chapter highlights the importance of SQL Server 2008 R2 tools that ...

Get SQL Server MVP Deep Dives, Volume 2 now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.