Chapter 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 database environments consisting of a large number SQL Servers. It provides guidance on tools and techniques to improve efficiency and effectiveness as a DBA by utilizing some of the manageability 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 difficult to invest the time required to address the root cause, standardize the environment, and reduce the flow of break/fix support incidents.

The topic of manageability is broad and means different things to different groups of people. Manageability can mean developing build and deployment standards, rationalizing high-availability technologies, and implementing standardized database maintenance procedures. The benefits of effective manageability ...

Get Professional SQL Server 2012 Internals and Troubleshooting 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.