Policy-Based Management
E56726
Policy-Based Management is a SQL Server feature that lets administrators define, enforce, and monitor configuration policies across database instances to ensure compliance with organizational standards.
Statements (49)
| Predicate | Object |
|---|---|
| instanceOf |
SQL Server feature
→
configuration management framework → |
| allows |
auditing configuration compliance
→
preventing noncompliant changes → rolling out standard configurations → |
| appliesTo |
SQL Server databases
→
SQL Server instances → SQL Server objects → |
| basedOn |
SQL Server facets metadata
→
|
| canEnforce |
database options
→
index and statistics settings → naming standards → security settings → server configuration options → |
| category |
database administration tool
→
|
| configuredWith |
SQL Server Management Studio
→
|
| developedBy |
Microsoft
→
|
| ensures |
compliance with organizational standards
→
|
| exposes |
system views for policy evaluation results
→
|
| integratesWith |
SQL Server Agent
→
SQL Server Management Data Warehouse → |
| introducedInVersion |
SQL Server 2008
→
|
| partOf |
Microsoft SQL Server
→
|
| policyStoredIn |
msdb database
→
|
| primaryPurpose |
define configuration policies for SQL Server instances
→
enforce configuration policies for SQL Server instances → monitor compliance with configuration policies → |
| supports |
central management of policies
→
graphical policy authoring in SSMS → policy evaluation across multiple servers → |
| supportsEvaluationMode |
On change: log only
→
On change: prevent → On demand → On schedule → |
| supportsExport |
policies as XML files
→
|
| supportsImport |
policies from XML files
→
|
| supportsProduct |
SQL Server 2008
→
SQL Server 2012 → SQL Server 2014 → SQL Server 2016 → SQL Server 2017 → SQL Server 2019 → SQL Server 2022 → |
| usedBy |
SQL Server administrators
→
|
| usesConcept |
condition
→
evaluation mode → facet → policy → target → |
Referenced by (1)
| Subject (surface form when different) | Predicate |
|---|---|
|
SQL Server
→
|
supportsFeature |