Some of the things covered in the online documentation are: There is a online help file included in the installation of the SQL Server Best Practices. Links to more detailed information about the issue and related topics.Issues that were detected in the scanned SQL Server instance.It then reports issues.įor every issue, the SQL Server Best Practices Analyzer provides three kinds of data: It compares the data that it gathers to a set of predefined rules for SQL Server settings and configurations. The SQL Server Best Practices Analyzer uses a configuration file to determine what information to gather from the SQL Server instance. This helps you diagnose problems that are caused by configuration changes in the instance of SQL Server.Ĭompares a set of servers to a baseline configuration and report all differences in configuration. Reports recent changes in the instance of SQL Server.Reports all settings that differ from the default settings.Proactively verifies that the configuration is set according to recommended best practices.Performs specific tests on the instance of SQL Server.Gathers configuration information from an instance of Microsoft SQL Server.The Microsoft SQL Server Best Practices Analyzer is a diagnostic tool that performs the following functions: The references in this wiki are slanted towards SQL 2005's BPA. There are 2 versions of SQL BPA: one for SQL 2000 and the other for SQL 2005. This tool can be used for initial troubleshooting and performance tuning scenarios. SQLBPA uses a predefined list of SQL Server reocmmendations and best practices to determine if there are potential issues in the database environment. The SQL Server Best Practice Analyzer is used to gather data from Microsoft Windows and SQL Server configuration settings.

Apex sql analyzer