Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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 -