Databases Reference
In-Depth Information
16
Delivering Manageability and
Performance
WHAT'S IN THIS CHAPTER?
➤
SQL Server manageability
➤
Policy-based management
➤
Automating policy management
➤
Microsoft tools for managing SQL Server
WROX.COM CODE DOWNLOADS FOR THIS CHAPTER
The
wrox.com
code downloads for this chapter are found at
www.wrox.com/remtitle
.cgi?isbn=1118177657
on the Download Code tab. The code is in the Chapter 16 download
and individually named according to the names throughout the chapter.
IMPROVE EFFICIENCY WITH SQL SERVER MANAGEABILITY
FEATURES
This chapter provides information for database administrators who are responsible for data-
base environments consisting of a large number SQL Servers. It provides guidance on tools
and techniques to improve efi ciency and effectiveness as a DBA by utilizing some of the man-
ageability features of SQL Server.
In many organizations, the number and variety of SQL Server instances, combined with a lack
of proper management, means the operational DBA team can be very busy with reactive tasks.
In these situations it can be difi cult to invest the time required to address the root cause, stan-
dardize the environment, and reduce the l ow of break/i x support incidents.
Search WWH ::
Custom Search