Governing your enterprise with policy based management
Download
1 / 21

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


  • 309 Views
  • Updated On :

Governing Your Enterprise with Policy-Based Management. Lara Rubbelke Technology Specialist Data Platform Microsoft [email protected] 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

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

PowerPoint Slideshow about 'Governing Your Enterprise with Policy-Based Management' - sandra_john


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

[email protected]

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




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



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


ad