© Peter A. Carter 2019
P. A. CarterPro SQL Server 2019 Administrationhttps://doi.org/10.1007/978-1-4842-5089-1_23

23. Policy-Based Management

Peter A. Carter1 
(1)
SOUTHAMPTON, UK
 

Policy-Based Management (PBM) is a system DBAs can use to report on or enforce standards across the enterprise, when used with a central management server. This chapter first introduces you to the concepts used by PBM and then demonstrates how to use PBM to effectively manage an estate through the GUI and with PowerShell.

PBM Concepts

Policy-Based Management uses the concepts of targets, facets, conditions, and policies. Targets are entities PBM manages, such as databases or tables. Facets are collections of properties that relate to a target. For example, the database facet ...

Get Pro SQL Server 2019 Administration: A Guide for the Modern DBA 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.