Feb
20
2013

Enable Policy Based Management using Central Management Servers

While trying to configure policy based management (PBM) across 100+ SQL servers in my domain faced issue that by default you need to import policies on individual servers or evaluate by connecting to a central policy server. Although this dilemma was broken by the articles written by several DBA’s across several forums and communities that Central management server (CMS) can be used to deploy or evaluate policies across set of servers or all SQL servers in a domain; I am sharing few article link which benefitted me using which I am able to accomplish task in time and with ease.

 

One of finest article to give you detailed information with example on the Policy based management using Central Management Servers; also tell how to utilize PowerShell as well,

https://www.simple-talk.com/sql/database-administration/policy-based-management-and-central-management-servers/

 

Below are few other reference links helped me in finding out more about Policy based management,

http://msdn.microsoft.com/en-us/library/bb510667(v=sql.100).aspx

http://blog.sqlauthority.com/2009/11/13/sql-server-policy-based-management-create-evaluate-and-fix-policies/

 

 

Now once you test it using methods described above by renowned authors, you also look forward to some reporting, for same some great minds developed an open source project Enterprise Policy Management Framework v3.0 (EPMF), get more details at below link, this EPMF is nothing but the way of utilizing PBM using CMS via PowerShell way and then use reporting system to show data collected in great looking reports to showcase your findings,

 

http://epmframework.codeplex.com

http://epmframework.codeplex.com/releases/view/28621

 

Hope the article will help you in getting info on how PBM can be used and implemented effectively and the wonders CMS can do 🙂

Download PDF

About the Author: Nitin G

Indian born, trekker, biker, photographer, lover of monsoons. I've been working full time with SQL Server since year 2005 and blogs to post the content aquired during my research on new topics or fixing issues faced by me as a DBA while working in different kind of projects, hope some of my posts may helps others in SQLDBA community. Everything you read on my blog is my own personal opinion and any code is provided "AS-IS" with no warranties!

Leave a comment

Subscribe to this blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 263 other subscribers

Translate this blog!

EnglishFrenchGermanItalianPortugueseRussianSpanish

Calender

December 2020
M T W T F S S
« Nov    
 123456
78910111213
14151617181920
21222324252627
28293031  

View Post by Categories

%d bloggers like this: