23. Policy-Based Management

• Targets - entities managed
• Facets - collection of properties (target)
• Conditions
• Policies - bind conditions to targets

SELECT name FROM msdb.dbo.syspolicy_managements_facets

Evaluation Modes

• on demand
• on schedule
• on change: log only
• on change: prevent

Error 43053 sev 16

CMS - central management server

Nested triggers need to be enabled on an instance

EXEC sp_configure 'nested triggers',1;
RECONFIGURE

Part of PBM, not T-SQL:

• ExecuteSQL()
• ExecuteWql() - security risk
• sys.dm_server_services
• Win32-Service

Powershell:

• Invoke - PolicyEvaluation
• 2000,2005 use XML for policy source