Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag Policy Based Management (PBM) Rss

   Items 1 to 20 of 35    Older >>
 

PBM Policy / WMI query to see which CPUs are in power-saving mode

A simple PBM policy which uses WMI to find out if the CPUs in the target are running at their maximum clock speed.  Read more...
By Ben Whitman 2014/02/13 | Source: SQLServerCentral.com | Category: cpu
Rating: |  Discuss |   Briefcase | 1,369 reads

Using Policy-Based Management to Check Number of SQL Server Data and Log Files

To meet our database configuration standards we want to make sure that we have only one database transaction log file and more than one data file. In this tip we look at how this can be done using a policy.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 1,853 reads

Using Policy Based Management for checking SQL Server database file extensions

We need to exclude SQL Server database files from Antivirus and Third Party Backup Software (to make sure that files are not accessed directly). How can we be sure that all of our SQL Server file extensions are using the standard file extensions for database files?  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 2,062 reads

Creating Custom T-SQL Conditions and Policies for SQL Server Policy-Based Management

In SQL Server, the built in conditions and policies are a great place to get started with monitoring your environment, but there are no facets for some aspects of SQL Server I want to monitor. How can I check on my environment using Policy Based Management? Check out this tip to learn more.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 2,808 reads

Evaluating Policies on Multiple SQL Server Instances using Central Management Server

you have created a SQL Server Policy to check database recovery models. Now you need to check the databases on all of your SQL Server instances. In this tip we will show how you can evaluate a SQL Server policy against multiple instances.   Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 2,167 reads

Manage By Delegation

There always seem to be more and more instances to manage, but not more and more staff. Steve Jones talks about the key to good management being delegation of the work.  Read more...
By Steve Jones 2012/10/17 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 120 reads

Standardization with PBM

How to enforce standards using PBM. Everything from setup to deployment.  Read more...
Rating: |  Discuss |   Briefcase | 5,149 reads

Policies

Rating: (not yet rated) |  Discuss |   Briefcase | 1,836 reads

Setup Alerts for PBM

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  Read more...
By Site Owners 2011/12/09 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 550 reads

PBM Alert

By Jason Brimhall 2011/07/22 | Category: security
Rating: (not yet rated) |  Discuss |   Briefcase | 1,996 reads

Implementing Database Settings Using Policy Based Management

This article demonstrates how a DBA can check for policy compliance by leveraging the Policy Based Management Feature of SQL Server.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 2,546 reads

PBM Policy / WMI query to see which CPUs are in power-saving mode

A simple PBM policy which uses WMI to find out if the CPUs in the target are running at their maximum clock speed.  Read more...
By Ben Whitman 2014/02/13 | Source: SQLServerCentral.com | Category: cpu
Rating: |  Discuss |   Briefcase | 1,369 reads

Monitor SQL Server Agent Jobs with Policy Based Management

I need to monitor all the SQL Agents to find out if a job failed in the last 24 hours. Could this be done with policy based management? If so, can you show me how to create the policy?  Read more...
By Additional Articles 2011/01/05 | Source: MSSQLTips.com | Category: sql server agent
Rating: (not yet rated)  Rate this |   Briefcase | 3,866 reads

Policy-based Management and Central Management Servers

Whilst it may be more exciting as a DBA to rush around fixing broken databases, it is far better to forestall problems by making sure that your servers conform with best-practices. It is even better if you can also manage your servers centrally, and monitor that they are all adhering to company policies.  Read more...
Rating:  Rate this |   Briefcase | 1,897 reads

Renaming SQL Server Policy-Based Management Policies

I have created several policies using Policy-Based Management and need to rename some of them. I don’t see an option in the GUI to rename a Policy. Is there any way I can rename them without dropping and recreating them?   Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 1,845 reads

Identify Databases Not in SQL Server 2008 Compatibility Level Using Policy Based Management

You need to periodically ascertain if there are any databases in your production environment which are not in SQL Server 2008 Compatibility Level. In this tip we cover the step by step process for setting up a policy to identify databases that are not in SQL Server 2008 Compatibility Level.  Read more...
Rating:  Rate this |   Briefcase | 2,071 reads

Configuring Alerts for Policy-Based Management

How can I receive notifications when the policies I have implemented have been violated so I don't have to manually look at each server?  Read more...
Rating:  Rate this |   Briefcase | 2,507 reads

Configure Surface Area Configuration for SQL Server 2008 Analysis Services Using Policy Based Management

I have installed a new instance of SQL Server 2008 Analysis Services and I am unable to find the Surface Area Configuration tool that I used to use in SQL Server 2005. How can I manage the Analysis Services features in SQL Server 2008?   Read more...
Rating:  Rate this |   Briefcase | 2,055 reads

How to Evaluate Policies on Multiple Instances

This article describes how to Evaluate Policies on Multiple Instances using EPM and PowerShell.  Read more...
Rating: |  Discuss |   Briefcase | 3,973 reads

Policy-Based Management

By Sqlchicken 2010/03/26 | Category: policy based management (pbm)
Rating: (not yet rated) |  Discuss |   Briefcase | 2,607 reads
   Items 1 to 20 of 35    Older >>
 
Tags
sql server 2008 (8)    
administration (5)    
blogs (2)    
central management server (cms) (2)    
powershell (2)    
security (2)    
alerts (1)    
analysis services (ssas) (1)    
backup / restore (1)    
cpu (1)    
editorial (1)    
enterprise policy management framework (epm) (1)    
epm (1)    
filestream (1)    
monitoring (1)    
performance tuning (1)    
sql server agent (1)    
video (1)    
wmi query (1)