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 (https://blog.sqlauthority.com)
3 Comments. Leave new
Thanks for sharing the information on this tool.
Thank you
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.
great help here… thx.