O'Reilly logo

Microsoft SQL Server 2012 Performance Tuning Cookbook by Bihag Thaker, Ritesh Shah

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 18. Policy-based Management

In this chapter we will cover:

  • Evaluating database properties
  • Restricting database objects

Introduction

Microsoft made database administrators very happy by introducing a feature called Policy-based Management (PBM). PBM helps administrators to manage one or more instances of SQL Server and manage database entities and/or other SQL Server objects, based on the policy defined in PBM. It helps DBAs to apply/enforce policies for server objects and databases, or to manage different tasks effortlessly and effectively.

The following terms will be needed in the recipes coming up in this chapter, so keep them in mind to ensure that you can understand all the recipes properly:

  • Policies: Defined rules for the database or server ...

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