Browsing articles in "Policy Based Management"
May
7
2013

Overhead of using Policy-Based Management on SQL Server

050713_1302_Overheadofu1.png

I Policy-Based Management is a very useful feature of SQL Server 2008 and later, if you like to audit certain parameters or enforce certain restriction on particular SQL Server/s, but first this to notice is will there be any overhead on current performance of SQL Server or not, basically the answer depends upon the way you are going to use it,   Q. What is the overhead of Policy-Based Management on my SQL Server? A. […]

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 […]

Subscribe to this blog via Email

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

Join 446 other subscribers

Translate this blog!

EnglishFrenchGermanItalianPortugueseRussianSpanish

Calender

June 2017
M T W T F S S
« May    
 1234
567891011
12131415161718
19202122232425
2627282930  

View Post by Categories

%d bloggers like this: