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
