O'Reilly logo

Professional SQL Server 2012 Internals and Troubleshooting by Amit Banerjee, Gavin Payne, Justin Langford, Glenn Berry, James Rowland-Jones, Christian Bolton

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

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 ...

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