Governing Your Enterprise with PolicyBased Management - PowerPoint PPT Presentation

1 / 21
About This Presentation
Title:

Governing Your Enterprise with PolicyBased Management

Description:

Policy-Based Management Framework. Introduction to the Framework ... Buck Woody's Blog. http://blogs.msdn.com/buckwoody/default.aspx. Additional Resources ... – PowerPoint PPT presentation

Number of Views:93
Avg rating:3.0/5.0
Slides: 22
Provided by: stls8
Category:

less

Transcript and Presenter's Notes

Title: 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
Write a Comment
User Comments (0)
About PowerShow.com