Microsoft® SQL Server® 2008 R2 Best Practices Analyzer is now available

The SQL Server Best Practices Analyzer (BPA) gathers data from Microsoft Windows and SQL Server configuration settings. BPA uses a predefined list of SQL Server recommendations and best practices to determine if there are potential issues in the database environment. For SQL Server 2008 R2 Microsoft has come up with new version. Here is the link for it.


The Microsoft SQL Server 2008 R2 BPA is a diagnostic tool that performs the following functions:

  • Gathers information about a Server and a Microsoft SQL Server 2008 or 2008 R2 instance installed on that Server
  • Determines if the configurations are set according to the recommended best practices
  • Reports on all configurations, indicating settings that differ from recommendations
  • Indicates potential problems in the installed instance of SQL Server
  • Recommends solutions to potential problems
System Requirements

  • Supported Operating Systems:Windows 7;Windows Server 2003;Windows Server 2008;Windows Server 2008 R2;Windows Vista

SQL Server 2008 R2 Best Practices Advisor is supported on the following Operating Systems:

  • Windows Server 2003
  • Windows Server 2008
  • Windows Vista
  • Windows Server 2008 R2
  • Windows 7

The following are required for using SQL Server 2008 R2 Best Practices Analyzer:


Finally! SQL Server 2008 R2 is available.

Finally! MICROSOFT has delivered  the most recent version of SQL Server…SQL Server 2008 R2. In this release MICROSOFT has expanded its reporting and analytics through business intelligence. SQL Server 2008 R2 delivers several breakthrough capabilities that will enable your organization to scale database operations with confidence, improve IT and developer efficiency, and enable highly scalable and well managed Business Intelligence on a self-service basis for your users.

Read more on :

Download SQL Server 2008 R2: click here to download SQL Server 2008 R2 for free.