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.

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

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

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

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

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

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

Let me know what your thoughts about this tool.

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

About these ads

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