Governing Your Enterprise with Policy-Based Management - PowerPoint PPT Presentation

Governing your enterprise with policy based management l.jpg
Download
1 / 21

Governing Your Enterprise with Policy-Based Management. Lara Rubbelke Technology Specialist Data Platform Microsoft larar@microsoft.com http://sqlblog.com/blogs/lara_rubbelke/default.aspx. www.codeplex.com/EPMFramework. Enterprise Policy Management. Agenda.

Related searches for Governing Your Enterprise with Policy-Based Management

I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.

Download Presentation

Governing Your Enterprise with Policy-Based Management

An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript


Governing your enterprise with policy based management l.jpg

Governing Your Enterprise with Policy-Based Management

Lara Rubbelke

Technology Specialist Data Platform

Microsoft

larar@microsoft.com

http://sqlblog.com/blogs/lara_rubbelke/default.aspx


Slide2 l.jpg

www.codeplex.com/EPMFramework


Enterprise policy management l.jpg

Enterprise Policy Management


Agenda l.jpg

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


Policy based management l.jpg

Policy-Based Management

Set of related logical properties

Policy

Specifies a set of allowed states of a managed target with regard to a facet

Condition

Defines the evaluation mode, target filters, and schedule of the conditions.

Facet


Policy evaluation modes l.jpg

Policy Evaluation Modes


On demand evaluation windows powershell integration l.jpg

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”


Policy evaluation l.jpg

Policy Evaluation

demo

Introduction to Policy-Based Management

Evaluating Policies with Windows PowerShell™


Agenda10 l.jpg

Agenda

  • Policy-Based Management Framework

  • Extending Policy-Based Management to the Enterprise

    • Solution Architecture

    • Considerations for Large-Scale Environments

    • Centralized Reporting


Extend to the enterprise bringing it all together l.jpg

Extend to the Enterprise Bringing It All Together

policy results

Central

Management Server

policy results

policy results

policy results

policy results

policy results


Enterprise policy management12 l.jpg

Enterprise Policy Management

demo

Implementing the Enterprise Policy Management Framework


Extend to the enterprise bringing it all together13 l.jpg

Extend to the Enterprise Bringing It All Together

Central

Management Server

policy results

policy results

policy results

policy results

policy results

policy results


Extend to the enterprise central management server l.jpg

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


Extend to the enterprise scaling powershell evaluation l.jpg

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


Extend to the enterprise scaling powershell evaluation16 l.jpg

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


Extend to the enterprise benefits of upgrading to sql server 2008 l.jpg

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


Epm framework v3 what s coming l.jpg

EPM Framework V3: What’s Coming…

  • Report Filters by Server Group

  • Centralization of SQL Server 2008 Policy History


Centralizing policy history sql server 2008 l.jpg

Centralizing Policy HistorySQL Server 2008

Central

Management Server

policy results

policy results

SSIS

policy results

syspolicy_policy_execution_history

syspolicy_policy_execution_history_details

policy results


Additional resources policy based management l.jpg

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 Rubbelke’s Blog

    • http://sqlblog.com/blogs/lara_rubbelke/default.aspx

  • Dan Jones’ Blog

    • http://blogs.msdn.com/dtjones/default.aspx

  • Buck Woody’s Blog

    • http://blogs.msdn.com/buckwoody/default.aspx


Additional resources windows powershell l.jpg

Additional ResourcesWindows PowerShell™

  • To learn more about the Windows PowerShell™ scripting Language

    • http://www.microsoft.com/downloads/details.aspx?FamilyID=b4720b00-9a66-430f-bd56-ec48bfca154f&DisplayLang=en

  • Windows PowerShell™ Blog

    • http://blogs.msdn.com/powershell/

  • Allen White’s Blog

    • http://sqlblog.com/blogs/allen_white/

  • SQL Server PowerShell Overview

    • http://msdn.microsoft.com/en-us/library/cc281954.aspx


  • Login