Data Management

Optimize SQL Server administration with Microsoft's SQL Server Best Practices Analyzer (BPA)

SQL Server Best Practices Analyzer

By Steven Warren

In the past, you would have to tweak your SQL Server settings manually to find the ideal configuration. Now, Microsoft has released a tool called the Microsoft SQL Server Best Practices Analyzer (BPA). With this tool, you can test and implement a combination of SQL Server best practices and then implement them on your SQL Server. I am going to go over how to install the tool and show you how it works.

After downloading this tool from Microsoft's Web site, you simply run the BPASETUP Windows Installer Package. The installer does a check to make sure you have the correct .NET Framework version installed. If you do not have this installed, you will be directed to Microsoft's Web site to download it. In addition to having the correct .NET Framework, you must also have Internet Explorer 6.0 or later. You can install the SQL Server Best Practices Analyzer on any of the following platforms:

  • Microsoft Windows XP
  • Microsoft Windows 2000 Professional
  • Microsoft Windows Server
  • Microsoft Windows Server 2003
  • Internet Explorer 6.0 or later
This gallery was orginialy posted in Steven Warren's TechRepublic blog - The Hot Button.

By Bill Detwiler

Bill Detwiler is Editor in Chief of TechRepublic and the host of Cracking Open, CNET and TechRepublic's popular online show. Prior to joining TechRepublic in 2000, Bill was an IT manager, database administrator, and desktop support specialist in the ...