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.

SQL SERVER - Introduction to Best Practices Analyzer - Quick Tutorial bpa1

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

SQL SERVER - Introduction to Best Practices Analyzer - Quick Tutorial bpa2

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

SQL SERVER - Introduction to Best Practices Analyzer - Quick Tutorial bpa3

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

SQL SERVER - Introduction to Best Practices Analyzer - Quick Tutorial bpa4

SQL SERVER - Introduction to Best Practices Analyzer - Quick Tutorial bpa5

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

SQL SERVER - Introduction to Best Practices Analyzer - Quick Tutorial 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

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

SQL SERVER - Introduction to Best Practices Analyzer - Quick Tutorial bpa10

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

SQL SERVER - Introduction to Best Practices Analyzer - Quick Tutorial bpa11

Let me know what your thoughts about this tool.

Reference: Pinal Dave (https://blog.sqlauthority.com)

,
Previous Post
SQLAuthority News – A Monthly Round Up of SQLAuthority Blog Posts
Next Post
SQL SERVER – Parallelism – Row per Processor – Row per Thread

Related Posts

3 Comments. Leave new

  • Thanks for sharing the information on this tool.
    Thank you

    Reply
  • 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.

    Reply
  • great help here… thx.

    Reply

Leave a Reply

Menu