March 25, 2010 at 1:43 pm
I understand by default best practices polices are not installed with SQL 2008. It's my understanding I should find them where the installation files get installed:
C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Policies\DatabaseEngine\1033
Below is the directory, I do not see Best Practices Policy.XML
Am I missing something?
Volume in drive C has no label.
Volume Serial Number is C4CF-8605
Directory of C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Policies\DatabaseEngine\1033
03/25/2010 03:38 PM <DIR> .
03/25/2010 03:38 PM <DIR> ..
07/03/2008 10:04 PM 18,183 Asymmetric Key Encryption Algorithm.xml
07/03/2008 10:04 PM 12,551 Backup and Data File Location.xml
07/03/2008 10:04 PM 12,537 CmdExec Rights Secured.xml
07/03/2008 10:04 PM 21,393 Data and Log File Location.xml
07/03/2008 10:04 PM 16,738 Database Auto Close.xml
07/03/2008 10:04 PM 20,490 Database Auto Shrink.xml
07/03/2008 10:04 PM 13,369 Database Collation.xml
07/03/2008 10:04 PM 15,810 Database Page Status.xml
07/03/2008 10:04 PM 12,580 Database Page Verification.xml
07/03/2008 10:04 PM 19,352 File Growth for SQL Server 2000.xml
07/03/2008 10:04 PM 20,435 Guest Permissions.xml
07/03/2008 10:04 PM 14,281 Last Successful Backup Date.xml
03/25/2010 03:38 PM 0 policy.txt
07/03/2008 10:04 PM 10,581 Public Not Granted Server Permissions.xml
07/03/2008 10:04 PM 21,984 Read-only Database Recovery Model.xml
07/03/2008 10:04 PM 13,460 SQL Server 32-bit Affinity Mask Overlap.xml
07/03/2008 10:04 PM 16,043 SQL Server 64-bit Affinity Mask Overlap.xml
07/03/2008 10:04 PM 10,556 SQL Server Affinity Mask.xml
07/03/2008 10:04 PM 13,868 SQL Server Blocked Process Threshold.xml
07/03/2008 10:04 PM 12,578 SQL Server Default Trace.xml
07/03/2008 10:04 PM 12,671 SQL Server Dynamic Locks.xml
07/03/2008 10:04 PM 13,324 SQL Server I_O Affinity Mask For Non-enterprise SQL Servers.xml
07/03/2008 10:04 PM 10,774 SQL Server Lightweight Pooling.xml
07/03/2008 10:04 PM 10,624 SQL Server Login Mode.xml
07/03/2008 10:04 PM 10,729 SQL Server Max Degree of Parallelism.xml
07/03/2008 10:04 PM 15,328 SQL Server Max Worker Threads for 32-bit SQL Server 2000.xml
07/03/2008 10:04 PM 16,606 SQL Server Max Worker Threads for 64-bit SQL Server 2000.xml
07/03/2008 10:04 PM 13,042 SQL Server Max Worker Threads for SQL Server 2005 and above.xml
07/03/2008 10:04 PM 10,712 SQL Server Network Packet Size.xml
07/03/2008 10:04 PM 12,781 SQL Server Open Objects for SQL Server 2000.xml
07/03/2008 10:04 PM 14,324 SQL Server Password Expiration.xml
07/03/2008 10:04 PM 14,252 SQL Server Password Policy.xml
07/03/2008 10:04 PM 12,580 SQL Server System Tables Updatable.xml
07/03/2008 10:04 PM 25,217 Surface Area Configuration for Database Engine 2005 and 2000 Features.xml
07/03/2008 10:04 PM 22,765 Surface Area Configuration for Database Engine 2008 Features.xml
07/03/2008 10:04 PM 16,001 Surface Area Configuration for Service Broker Endpoints.xml
07/03/2008 10:04 PM 15,741 Surface Area Configuration for SOAP Endpoints.xml
07/03/2008 10:04 PM 20,462 Symmetric Key Encryption for User Databases.xml
07/03/2008 10:04 PM 18,487 Symmetric Key for master Database.xml
07/03/2008 10:04 PM 19,088 Symmetric Key for System Databases.xml
07/03/2008 10:04 PM 16,542 Trustworthy Database.xml
07/03/2008 10:04 PM 12,507 Windows Event Log Cluster Disk Resource Corruption Error.xml
07/03/2008 10:04 PM 12,432 Windows Event Log Device Driver Control Error.xml
07/03/2008 10:04 PM 12,364 Windows Event Log Device Not Ready Error.xml
07/03/2008 10:04 PM 12,614 Windows Event Log Disk Defragmentation.xml
07/03/2008 10:04 PM 12,369 Windows Event Log Failed I_O Request Error.xml
07/03/2008 10:04 PM 12,364 Windows Event Log I_O Delay Warning.xml
07/03/2008 10:04 PM 12,479 Windows Event Log I_O Error During Hard Page Fault Error.xml
07/03/2008 10:04 PM 12,305 Windows Event Log Read Retry Error.xml
07/03/2008 10:04 PM 12,489 Windows Event Log Storage System I_O Timeout Error.xml
07/03/2008 10:04 PM 12,439 Windows Event Log System Failure Error.xml
51 File(s) 743,201 bytes
2 Dir(s) 5,891,092,480 bytes free
March 26, 2010 at 7:09 am
Those things you're looking at are considered the best practices.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
March 26, 2010 at 7:49 am
That's what I was afraid of. Thank you!
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply