Policy-Based Management gives DBAs the ability to define and set policies (standards) and evaluate those policies against the instances of SQL Server in their environment.
As documented in the Best Practices for Running Siemens Teamcenter whitepaper there are a number of installation options and configuration changes needed to help avoid or minimize common problems and optimize the performance of Siemens Teamcenter on SQL Server.
Wouldn’t it be great to be able to have these best practice recommendations available as policies so that you could evaluate your Siemens Teamcenter SQL Server instances automatically? Below is a list of 10 best practices described in the Best Practices for Running Siemens Teamcenter whitepaper and their associated policies which are available to download.
Note: Not all recommendations have been converted into policies so it is important to review and apply the remaining best practices from the Best Practices for Running Siemens Teamcenter whitepaper.
Database Engine Service Account should not be set to LOCAL SYSTEM
Note: In order to be able to evaluate the Teamcenter_SQLServerAgentAutoStart Policy the “Agent XPs” component needs to be enabled. A system administrator can enable the use of “Agent XPs” by using sp_configure.
For information on Importing a Policy-Based Management Policy please see:
How to: Export and Import a Policy-Based Management Policy
For more information on Policy-Based Management please review the links below.
SQL Server 2008 Policy-Based Management white paper
SQL Server Policy-Based Management Blog
Enterprise Policy Management Framework