SQL SERVER – Introduction to Best Practices Analyzer – Quick Tutorial

I previously wrote about SQLAuthority News – Download – Microsoft SQL Server 2008 R2 Best Practices Analyzer earlier and since then I have received many emails requesting to explain how it works. I assume that you can download and install the tool successfully. Once done just follow the steps listed below. You will be successfully able to test multiple instances of SQL Server using this tool.

bpa1 SQL SERVER   Introduction to Best Practices Analyzer   Quick Tutorial

Once the tool is launched, select the product you wish to analysis.

bpa2 SQL SERVER   Introduction to Best Practices Analyzer   Quick Tutorial

Click on Start Scan will take few minutes to analysis the server.

bpa3 SQL SERVER   Introduction to Best Practices Analyzer   Quick Tutorial

Select the appropriate features to include the analysis in report. I have just selected Engine over here.

bpa4 SQL SERVER   Introduction to Best Practices Analyzer   Quick Tutorial

bpa5 SQL SERVER   Introduction to Best Practices Analyzer   Quick Tutorial

Once the analysis is over it will bring three different tabs. Expand the tabs to see your desired results.

bpa6 SQL SERVER   Introduction to Best Practices Analyzer   Quick Tutorial

bpa7 SQL SERVER   Introduction to Best Practices Analyzer   Quick Tutorial

bpa8 SQL SERVER   Introduction to Best Practices Analyzer   Quick Tutorial

bpa9 SQL SERVER   Introduction to Best Practices Analyzer   Quick Tutorial

You can further double-click on error screen and see more details about analysis. It also lists few added links for further reading.

bpa10 SQL SERVER   Introduction to Best Practices Analyzer   Quick Tutorial

You can also export the report in XML format and save it for further usage.

bpa11 SQL SERVER   Introduction to Best Practices Analyzer   Quick Tutorial

Let me know what your thoughts about this tool.

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

6 thoughts on “SQL SERVER – Introduction to Best Practices Analyzer – Quick Tutorial

  1. Pingback: SQLAuthority News – A Monthly Round Up of SQLAuthority Blog Posts Journey to SQL Authority with Pinal Dave

  2. Pingback: SQLAuthority News – Download – Microsoft SQL Server 2008 R2 Best Practices Analyzer Whitepaper Journey to SQL Authority with Pinal Dave

  3. Hello,

    I was wondering if you could help me with a problem using de SQL Server BPA. When I connect to a remote machine with the MSCA and then run de BPA I get the error: Analysis cannot be performed. I already followed the steps for the resolution, but I still get this error. I would appreaciate if you could help me.

    Like

  4. Pingback: SQL SERVER – Weekly Series – Memory Lane – #036 | Journey to SQL Authority with Pinal Dave

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