Policy Based Management (PBM)

External Article

Checking SQL Server with Policy-Based Management

  • Article

Policy-Based Management, a feature of SQL Server, is a flexible tool that can help DBAs manage one or more SQL Server instances. It's used for monitoring and enforcing a standard set of policies for SQL Server throughout an organization. While there are many built-in conditions from which to choose, Dennes demonstrates how to set up a custom policy as well as a standard one. Viewing the policy status over many servers can be tedious, so he also explains how DBAs can evaluate the states of multiple servers with just one glance.

2017-12-12

2,640 reads

Technical Article

Setup Alerts for PBM

  • Article

PBM raises errors for policy violations. We can create alerts on those errors to be notified of policy violations. In order to setup alerts on these errors there are three prerequisites. Note that violations for the “On Demand” evaluation mode do not raise errors. A policy must be set to

2011-12-09

1,094 reads

Blogs

Daily Coping 1 Dec 2022

By

Today’s coping tip is to discover your artistic side. Design a friendly greeting card....

New Database Job – The 6 Month Plan

By

So, we made it through our first 90 days, things start getting tougher now...

SQL Homework – December 2022 – What’s new in SQL Server?

By

SQL Server 2022 has been released! Long live SQL Server! No really, I’ve still...

Read the latest Blogs

Forums

Replication Statistics

By coolchaitu

In Transactional Replication, create index and Alter index commands do not get replicated to...

The Last Valid Restore Time

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Last Valid Restore Time

Getting started with ROUND() and Its Use Cases

By Manvendra Deo Singh

Comments posted to this topic are about the item Getting started with ROUND() and...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers