“Microsoft Best Practices Analyzer for Microsoft® Windows® SharePoint® Services 3.0 and the 2007 Microsoft® Office System” has Shipped!

The Microsoft Best Practices Analyzer for Windows SharePoint Services 3.0 and the 2007 Microsoft Office System Best Practices Analyzer programmatically collects settings and values from data repositories such as MS SQL, registry, metabase and performance monitor. Once collected, a set of comprehensive ‘best practice’ rules are applied to the topology.

This is a command line utility that administrators can run to get a detailed report of recommended changes that can be made to their environments to achieve greater performance, scalability and uptime. The below picture shows a snap shot of my staged server after running it:


BPA Report


One thing that you will notice is that it does indeed cover Project Server. There are a number of best practices that are specific to Project. For example, if there has been a failure with the cubes or if there are failed queue jobs the Best Practice Analyzer will warn you of these failures.


It is important to note that this tool is a read only. It will not make any changes to your environment. You should give it a try.


You can get a copy here:



Chris Boyd


Comments (3)

  1. Project 2007 Team Blog : "The Microsoft Best Practices Analyzer for Windows SharePoint Services 3.0 and

  2. Mike Mahoney says:

    I have successfully run this application in my development environment but it fails in the production environment allegedly failing to connect with SQL using my windows credentials.  Or dba suggested it was an incorrect error. His suspicion was that because we are using an instance of SQL the code was not handking the slash in the instance name or was not aware of the correct port for the instance.

    If this is the case how do I get around this problem


Skip to main content