First published on TECHNET on Oct 13, 2010
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.
|
Best Practice Description
|
Policy Name
|
Policy Definition
|
Database Engine Service Account should not be set to LOCAL SYSTEM
|
Teamcenter_DBEngineServiceAccount
|
Download
|
|
Server Collation should be set to Latin1_General_BIN
|
Teamcenter_ServerCollation
|
Download
|
|
Security Mode should be Mixed Authentication
|
Teamcenter_SecurityMode
|
Download
|
|
Database Engine should be set to Autostart
|
Teamcenter_DBEngineAutostart
|
Download
|
|
SQL Server Agent should be set to Autostart
|
Teamcenter_SQLServerAgentAutostart
|
Download
|
|
TempDB should not be on the C:\ drive
|
Teamcenter_TempDBLocation
|
Download
|
|
Maximum Degree of Parallelism should be set to 1
|
Teamcenter_MAXDOP
|
Download
|
|
Auto Close should be disabled
|
Teamcenter_AutoClose
|
Download
|
|
Auto Shrink should be disabled
|
Teamcenter_AutoShrink
|
Download
|
|
Auto Create and Auto Update Statistics should be enabled
|
Teamcenter_Statistics
|
Download
|
|
All
|
All
|
Download
|
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
