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

Articles with tag Policy Based Management (PBM) Rss

Search for any content tagged policy based management (pbm)

   Items 1 to 20 of 23    Older >>
 

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,856 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,065 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,816 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,174 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,154 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 | 556 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,548 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,872 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,900 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,849 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,074 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,511 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,060 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,976 reads

Using SQL Server 2008 PBM to Monitor Free Space

Keeping track of the space used and free in your database files is something that all experienced DBAs need to do. And something many new DBAs forget. New author Jayakumar Krishnan brings us an easy technique to do this in SQL Server 2008 with Policy Based Management.  Read more...
Rating: |  Discuss |   Briefcase | 7,606 reads

Enterprise Policy Management Framework with SQL Server 2008

The Enterprise Policy Management (EPM) Framework leverages and extends the new Microsoft SQL Server 2008 Policy-Based Management feature across an entire SQL Server enterprise, including down-level instances of SQL Server such as SQL Server 2000 and SQL Server 2005.  Read more...
By Additional Articles 2009/08/28 | Source: Microsoft MSDN | Category: sql server 2008
Rating: (not yet rated)  Rate this |   Briefcase | 1,862 reads

Validate SQL Server Backups Exist with Policy Based Management

I recently submitted a tip regarding the existence of your backup files using the undocumented system stored procedure xp_fileexist. But how would you go about executing that script against all your SQL Server 2005 and SQL Server 2008 instances? I took that script and decided to go one step further using Policy Based Management to create a custom policy that you can then run against all your SQL Server 2005 and SQL Server 2008 instances.  Read more...
By Additional Articles 2009/08/25 | Source: MSSQLTips.com | Category: backup / restore
Rating: (not yet rated)  Rate this |   Briefcase | 2,280 reads

New features in SQL Server 2008 justify migration

New features such as the FILESTREAM data type and Policy-Based Management offer clear performance enhancements that may make the decision to migrate to SQL 2008 a no-brainer.  Read more...
By Additional Articles 2009/04/16 | Source: SearchSQLServer | Category: sql server 2008
Rating: (not yet rated)  Rate this |   Briefcase | 3,735 reads

Policy Based Management - On Change Prevent, Doesn't

SQL Server 2008 introduces " Policy Based Management " (PBM) as a way to better manage your servers. This was a feature that I really thought had, and still has a lot of potential for making the life of a DBA easier. The tagline for PBM is "manage...   Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 1,873 reads
   Items 1 to 20 of 23    Older >>