Title: Governing Your Enterprise with PolicyBased Management
1Governing 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
2www.codeplex.com/EPMFramework
3Enterprise Policy Management
4Agenda
- 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
5Policy-Based Management
Policy
Condition
Facet
6(No Transcript)
7Policy Evaluation Modes
8On 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
9Policy Evaluation
- Introduction to Policy-Based Management
- Evaluating Policies with Windows PowerShell
10Agenda
- Policy-Based Management Framework
- Extending Policy-Based Management to the
Enterprise - Solution Architecture
- Considerations for Large-Scale Environments
- Centralized Reporting
11Extend to the Enterprise Bringing It All Together
policy results
Central Management Server
policy results
policy results
policy results
policy results
policy results
12Enterprise Policy Management
- Implementing the Enterprise Policy Management
Framework
13Extend to the Enterprise Bringing It All Together
Central Management Server
policy results
policy results
policy results
policy results
policy results
policy results
14Extend 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
15Extend 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
16Extend 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
17Extend 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
18EPM Framework V3 Whats Coming
- Report Filters by Server Group
- Centralization of SQL Server 2008 Policy History
19Centralizing 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
20Additional 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
21Additional 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