SQL Server 2008 R2 Best Practices Analyser


Yes the SQL Server best practices analyser is back and it can be used to analyse your SQL Server 2008 or 2008 R2 instances.

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

  • Gathers information about a Server and a Microsoft SQL Server 2008 or 2008 R2 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

The following are required for using SQL Server 2008 R2 Best Practices Analyzer:

  • PowerShell V2.0
  • Microsoft Baseline Configuration Analyzer V2.0 (MBCA)

Link to BPA : http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=0fd439d7-4bff-4df7-a52f-9a1be8725591

The tool requires that MBCA is installed, this can be installed from – http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=1b6e9026-f505-403e-84c3-a5dea704ec67 

SQL Server BPA can help you maintain and manage high performing SQL Server environment.

Comments (2)

  1. asew says:

    I think your article is very useful, it might be in more detail further suggest the method clearer method, can be of several categories that you created or any of several methods that should be done in the process of it, thank you very much
    Sign
    http://www.lokerjobindo.com

  2. wq says:

    http://www.michaelkorsoutlets-online.us.com/
    http://www.pandora-charms-canada.ca/ and
    http://www.the-north-face.ca/
    http://www.nikeshoesoutlet.org.uk/ it
    http://www.ralphlaurenoutlet.us.com/
    http://www.tiffany-jewelry.in.net/ covers
    http://www.thejoreseproject.com/
    http://www.rolex-watches-canada.ca/ the
    http://www.uggbootsclearance.com.co/ http://www.yoga-pants.ca/ following
    http://www.northfaceoutlet.com.co/
    http://www.truereligionjeans.net.co/ points:
    http://www.nike-air-max.com.au/
    http://www.toms–outlet.com.co/ ManagingMany
    http://www.oakley-outletstore.us.com/
    http://www.ralph-laurenoutlet.co.uk/ of
    http://www.ugg-boots-australia.com.au/
    http://www.guccihandbags.net.co/ you
    http://www.marcjacobs.us.com/ http://www.reebok.com.de/ new
    http://www.uptocoachoutlet.com/
    http://www.cheapoakleysunglasses.ar.com/ SQL
    http://www.louis-vuitton-taschen.com.de/
    http://www.nfl-jersey.us.com/ Server http://www.new-balance.ca/
    http://www.nike-air-force.de/ DBAs
    http://www.ralph-laurenoutlet.ca/
    http://www.true-religion.com.co/ may
    http://www.the-tnfjackets.us.com/ http://www.jimmychoo.net.co/ be
    http://www.adidas.com.se/
    http://www.basketballshoes.com.co/ wondering
    http://www.michael-kors.com.co/
    http://www.longchampoutlet.com.co/ what
    http://www.swarovski-australia.com.au/
    http://www.cheap-baseballbats.net/ are
    http://www.jordanrelease-dates.us.com/
    http://www.outletonline-michaelkors.com/ the
    http://www.newbalance-outlet.org/ http://www.longchamp.com.co/ things
    http://www.ray–ban.ca/
    http://www.hollister.us.org/ to http://www.uhren-shop.com.de/
    http://www.louis-vuittonblackfriday.com/ lookout
    http://www.chanel-bags.com.co/
    http://www.tnfjackets.us.com/ for http://www.nikefree-run.net/
    http://www.ray-ban-sunglasses-outlet.in.net/ to
    http://www.pradahandbags.net.co/
    http://www.poloralphlaurenoutlet.net.co/ effectively
    http://www.barbour-factory.com/ http://www.pradaoutlet.com.co/ maintain
    http://www.michael-kors.com.es/
    http://www.moncler-outlet.us.org/ a
    http://www.ralphlaurenoutlet-online.us.com/
    http://www.burberryoutletonlinesale.in.net/ production
    http://www.weddingdressesuk.org.uk/
    http://www.louisvuitton.jp.net/ SQL
    http://www.bebeclothing.in.net/ http://www.prada.com.de/ Server
    http://www.hilfigeroutlet.in.net/
    http://www.abercrombieand-fitch.ca/ database.
    http://www.celine-bags.org/