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
Bill Detwiler has nothing to disclose. He doesn't hold investments in the technology companies he covers.
Bill Detwiler is Managing Editor of TechRepublic and Tech Pro Research 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 social research and energy industries. He has bachelor's and master's degrees from the University of Louisville, where he has also lectured on computer crime and crime prevention.