SQL Server 2005 Best Practices Analyzer (July 2007)

  • Article

 

SQL Server 2005 Best Practices Analyzer (July 2007) has been released and is available for public download at https://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 -