共用方式為

SQL Server 2012 Best Practices Analyzer

  • 發行項

Copied from an internal email from a PM on the team, Jakub -

I’m pleased to announce that SQL Server 2012 Best Practices Analyzer (BPA) has been released and is available for download at https://www.microsoft.com/download/en/details.aspx?id=29302.

Customer Value

The Microsoft SQL Server 2012 BPA is a diagnostic tool that
performs the following functions:

  • Gathers information about a Server and a
    Microsoft SQL Server 2012 instance installed on that Server.

  • Determines if the configurations are set
    according to the recommended best practices.

  • Reports on all configurations, indicating
    settings that differ from recommendations.

  • Indicates potential problems in the installed
    instance of SQL Server.

  • Recommends solutions to potential problems.## Comments

  • Anonymous
    June 08, 2012
    The comment has been removed
  • Anonymous
    October 24, 2013
    Is there any Whitepaper available? By now I have some trouble running the BPA
  • Anonymous
    October 25, 2013
    Dirk, unfortunately there isn't a whitepaper for it.
  • Anonymous
    March 14, 2014
    Installed the MS Baseline Configuration Analyzer 2.0 on Win 2012 server running SQL Server 2012. Installed SQL Server 2012 BPA (appeared to install successfully). Launched MS Baseline Config Analyzer (GUI) and don't see any options under 'Select a product'  - was expected to see the SQL Server 2012 BPA. Anything I need to check / update to get this to show up under 'Select a product'?
  • Anonymous
    April 15, 2014
    No Auto update
  • Anonymous
    April 17, 2014
    SQL 2012 BPA fails with generic message Analysis cannot be performed. when run on windows 2008R2 serverusing any scan option under BPA same error will show..Test remote shell using enter-pssession command which will show an error that shell access is disabled and running the following winrm command belowwinrm get winrm/configshows following under sectionWinrs    AllowRemoteShellAccess = false [Source="GPO"]Group Policy is one way to fix this issue but if we need to just run on one server we can get around by doing following registry key updateHklmsoftwarepolicieswindowsWinRMServicewinRSAllowRemoteShellAccess=1 change from 0 to 1Make sure you backup registry before making any changes as any wrong registry update may warrant OS reinstall in some cases.BPA will run successfully,Subsequent runs may fail as GPO will override AllowRemoteShellAccess  when gpudate runs unless it is set at GPO level via AD.
  • Anonymous
    May 08, 2014
    I notice that Windows Server 2012 is not listed as a supported OS. I've given this a bash regardless and (not surprisingly I suppose ) am having no success in getting it working.  You can mess about copying the models folder contents from c:program dataetc.. to c:windowssystem32etc...  and can at least get the BPA to appear as a selectable option - however still cannot get this working (as I say though not suprised - just thought I'd try it).So, does anyone have any ideas when this will be officially supported on Windows Server 2012? Or have they got it working?  
  • Anonymous
    September 22, 2014
    The SQL 2012 BPA is a joke. Doesn't install properly and even when you get it installed it usually doesn't scan properly without fighting with it. Why should we have to put in so much work to get a BPA tool to run? Please try again MS.
  • Anonymous
    December 17, 2014
    Not an easy setup and haven't go it working. Same as Ken B:Installed the MS Baseline Configuration Analyzer 2.0 on Win 2012 server running SQL Server 2012. Installed SQL Server 2012 BPA (appeared to install successfully). Launched MS Baseline Config Analyzer (GUI) and don't see any options under 'Select a product'  - was expected to see the SQL Server 2012 BPA. Anything I need to check / update to get this to show up under 'Select a product'?
  • Anonymous
    January 06, 2015
    The comment has been removed