SQL Server 2005 Best Practices Analyzer (July 2007)
SQL Server 2005 Best Practices Analyzer (July 2007) has been released and is available for public download at http://www.microsoft.com/downloads/details.aspx?FamilyId=DA0531E4-E94C-4991-82FA-F0E3FBD05E63&displaylang=en
SQL Server Best Practices Analyzer (SQL BPA) is a diagnostic tool that gathers configuration information and provides a report of recommended best practices for SQL Server.
SQL BPA analysis includes information about configuration settings for the instance of SQL Server, Transact-SQL query syntax, the Windows file system and registry, and Windows Management Instrumentation settings.
Approximately 100 rules are checked. The current rules are in a xml file located at SQLBPA.Config.xml. This file is stored by default at C:\Program Files\Microsoft SQL Server 2005 Best Practices Analyzer\EN
New rules will be added over time by Microsoft. Under the “Update and customer feedback” option there is a “Check for updates now” option. This will connect to the Microsoft web site and download a new SQLBPA.Config.xml file.
To minimize impact on performance, install the SQL Server Best Practices Analyzer on a computer that has SQL Server management tools installed, or a computer that does not host a production environment for SQL Server instances.
- Beatrice Nicolini -
