SQL SERVER – 2005 Best Practices Analyzer (July BPA)

The SQL Server 2005 Best Practices Analyzer (BPA) gathers data from Microsoft Windows and SQL Server configuration settings. BPA uses a predefined list of SQL Server 2005 recommendations and best practices to determine if there are potential issues in the database environment.


Reference : Pinal Dave (http://blog.SQLAuthority.com)

3 thoughts on “SQL SERVER – 2005 Best Practices Analyzer (July BPA)

  1. Pingback: SQL SERVER - 2005 Best Practices Analyzer Tutorial - Sample Example Journey to SQL Authority with Pinal Dave

  2. Hi pinal,
    I am wondering what kind of tests this tool peforms. Who will benefit from it? Is it the DBA? or a developer?

    Is it similar to FXCOP or Code analyzer which will test the TSQL code or Index, or other DB definition and will report the health of the system?

    I did a scan and what i could see is a dozen errors which says that I need to set autogrowth to be a lower value. I could not find any useful information after the scan.

    Am I missing something?


  3. Hi Jacob,

    Great Question! I really enjoy answering question, which reader are interested.

    I am running this on our production server and I find it is mostly for Database Administrator. However Database Developer will be also find it useful.

    I am not sure about FXCOP as I have not used it before. As I said it is more focused on Administrator stuff than Developer. I have yet to find where it analyzes Index (may be not).

    Well, it suggest that when was last backup taken, password policy, database health, restoration status etc. I find it useful as we have lots of database and we can easily monitor with one click.

    We have Jr. DBA run all this report and export to one master table on one of the server. Where we query everyday and bring back reports of all the database we are running on production. It does provide good information once it is running on many server and report is generated for review.

    Anybody interested in looking at demo of how to start with BPA please visit : SQL SERVER – 2005 Best Practices Analyzer Tutorial – Sample Example

    Pinal Dave (SQLAuthority.com)


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s