Governing Your Enterprise with PolicyBased Management

1
Governing Your Enterprise with Policy-Based
Management

• Lara Rubbelke
• Technology Specialist Data Platform
• Microsoft
• larar_at_microsoft.com
• http//sqlblog.com/blogs/lara_rubbelke/default.asp
  x

2
www.codeplex.com/EPMFramework
3
Enterprise Policy Management
4
Agenda

• Policy-Based Management Framework
• Introduction to the Framework
• Evaluation Modes
• Extending Policy-Based Management to the
  Enterprise
• Solution Architecture
• Considerations for Large-Scale Environments
• Centralized Reporting

5
Policy-Based Management
Policy
Condition
Facet
6
(No Transcript)
7
Policy Evaluation Modes
8
On Demand EvaluationWindows PowerShell
Integration

• Windows PowerShell is a framework and runtime
  for executing management commands
• Cmdlets are instances of .NET classes that
  process input objects from the pipeline
• SQL Server Provider for Windows PowerShell
  encompasses SMO

Invoke-PolicyEvaluation Policy
DatabaseStatus.xml, Trustworthy.xml
-TargetServerName inst1 Invoke-SQLCMD Query
SELECT name FROM sys.Databases ServerInstance
MyServer\Instance
9
Policy Evaluation

• demo

• Introduction to Policy-Based Management
• Evaluating Policies with Windows PowerShell

10
Agenda

• Policy-Based Management Framework
• Extending Policy-Based Management to the
  Enterprise
• Solution Architecture
• Considerations for Large-Scale Environments
• Centralized Reporting

11
Extend to the Enterprise Bringing It All Together
policy results
Central Management Server
policy results
policy results
policy results
policy results
policy results
12
Enterprise Policy Management

• demo

• Implementing the Enterprise Policy Management
  Framework

13
Extend to the Enterprise Bringing It All Together
Central Management Server
policy results
policy results
policy results
policy results
policy results
policy results
14
Extend to the Enterprise Central Management
Server

• Logically group instances based on business
  function(s)
• Centrally publish policies to groups of SQL
  Server 2008 instances
• Evaluate policies on-demand against a group of
  servers
• Filter by logical groups in Windows PowerShell
  scripts

15
Extend to the Enterprise Scaling PowerShell
Evaluation

• Add Intelligence to Policies
• Place each policy in a category
• Define server restrictions for versions and
  editions where appropriate

16
Extend to the Enterprise Scaling PowerShell
Evaluation

• Create Custom Server Groups in the CMS
• Run specific policies against a list of servers
• Examples Production, Development, PCI
• Define Concurrent Jobs
• Define multiple concurrent executions based on
  Policy Category and/or logical Central Management
  Server group

17
Extend to the Enterprise Benefits of Upgrading
to SQL Server 2008

• Real-Time Enforcement and Reporting
• Monitor the event log through Alerting
  integration
• Advanced functionality and integration with SSMS
• Dependency, health states, subscriptions, history
• Scale
• Security
• Access to other rich features in SQL Server 2008

18
EPM Framework V3 Whats Coming

• Report Filters by Server Group
• Centralization of SQL Server 2008 Policy History

19
Centralizing Policy HistorySQL Server 2008
Central Management Server
policy results
SSIS
policy results
policy results
syspolicy_policy_execution_history
syspolicy_policy_execution_history_details
policy results
20
Additional ResourcesPolicy Based Management

• Enterprise Policy Management Framework
• http//www.codeplex.com/EPMFramework
• Policy Based Management Blog
• http//blogs.msdn.com/sqlpbm/default.aspx
• Lara Rubbelkes Blog
• http//sqlblog.com/blogs/lara_rubbelke/default.asp
  x
• Dan Jones Blog
• http//blogs.msdn.com/dtjones/default.aspx
• Buck Woodys Blog
• http//blogs.msdn.com/buckwoody/default.aspx

21
Additional Resources Windows PowerShell

• To learn more about the Windows PowerShell
  scripting Language
• http//www.microsoft.com/downloads/details.aspx?Fa
  milyIDb4720b00-9a66-430f-bd56-ec48bfca154fDispla
  yLangen
• Windows PowerShell Blog
• http//blogs.msdn.com/powershell/
• Allen Whites Blog
• http//sqlblog.com/blogs/allen_white/
• SQL Server PowerShell Overview
• http//msdn.microsoft.com/en-us/library/cc281954.a
  spx