locked
SQL Server 2014 Missing Best Practices Analyzer RRS feed

  • Question

  • Please advise when a version of the SQL Server Best Practices Analyzer will be made public.
    Friday, October 23, 2015 6:48 PM

Answers

  • Hi SQL,

    The latest version of Best Practices Analyzer for SQL Server is SQL Server 2012 Best Practices Analyzer. We still need to wait for the release of SQL Server 2014 Best Practices Analyzer.

    Regarding to the issue that when SQL Server 2014 Best Practices Analyzer will be released, I would recommend you submit a feedback to the Microsoft Connect at this link https://connect.microsoft.com/SQLServer/Feedback. Your feedback enables Microsoft to offer the best software and deliver superior services.

    Additionally, based on my test, SQL Server 2012 Best Practices Analyzer cannot work for SQL Server 2014, below is my screenshot.


    Thanks,
    Lydia Zhang


    Lydia Zhang
    TechNet Community Support


    Monday, October 26, 2015 2:05 AM

All replies

  • I think SQL 2012 version will be working with SQL 2014. This is what mentioned here 

    Install SQL Best Practice Analyzer

    Saturday, October 24, 2015 6:16 AM
  • Hi SQL,

    The latest version of Best Practices Analyzer for SQL Server is SQL Server 2012 Best Practices Analyzer. We still need to wait for the release of SQL Server 2014 Best Practices Analyzer.

    Regarding to the issue that when SQL Server 2014 Best Practices Analyzer will be released, I would recommend you submit a feedback to the Microsoft Connect at this link https://connect.microsoft.com/SQLServer/Feedback. Your feedback enables Microsoft to offer the best software and deliver superior services.

    Additionally, based on my test, SQL Server 2012 Best Practices Analyzer cannot work for SQL Server 2014, below is my screenshot.


    Thanks,
    Lydia Zhang


    Lydia Zhang
    TechNet Community Support


    Monday, October 26, 2015 2:05 AM
  • Best Practice Analyzer has been replaced in SQL 2014 with a Policy Evaluation using built in Best Practice Templates

    See the following Tutorial: Evaluating Best Practices by Using Policy-Based Management > Lesson 1: Evaluate Best Practices on an On-Demand Basis

    https://msdn.microsoft.com/en-us/library/ee342167(v=sql.120).aspx

    Note: the path to the templates is under the 120 directory for SQL Server 2014 not the  110 SQL Server 2012 directory.

    GlobalKnowledge.com

    • Proposed as answer by Graeme_Purves Thursday, August 25, 2016 12:58 PM
    Thursday, August 25, 2016 12:57 PM