1 / 21

Governing Your Enterprise with Policy-Based Management

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.

sandra_john
Télécharger la présentation

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. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. 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

  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 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

  6. Policy Evaluation Modes

  7. 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”

  8. Policy Evaluation demo Introduction to Policy-Based Management Evaluating Policies with Windows PowerShell™

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

  10. Extend to the Enterprise Bringing It All Together policy results Central Management Server policy results policy results policy results policy results policy results

  11. Enterprise Policy Management demo Implementing the Enterprise Policy Management Framework

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

  13. 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

  14. 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

  15. 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

  16. 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

  17. EPM Framework V3: What’s Coming… • Report Filters by Server Group • Centralization of SQL Server 2008 Policy History

  18. 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

  19. 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

  20. 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

More Related