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

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