Post reply

SQLRAP

  • May 8, 2009 at 7:35 am

    #129871

    Does anyone know anything about the Risk Assessment Program from Microsoft for SQL and what they look at and is it worth doing?

    Thanks

  • May 8, 2009 at 8:29 am

    #991131

    Checkout the link..........

    http://rais.ornl.gov/homepage/tm/tm117.pdf

    [font="Comic Sans MS"]+++BLADE+++[/font]:cool:

  • May 8, 2009 at 8:47 am

    #991158

    This link is for a US government department, it doesn't mention Microsoft or SQL.

    I was more asking if anyone has used Microsofts service for SQLRAP or knew anything about it.

    Thanks anyway

  • May 8, 2009 at 9:05 am

    #991183

    BU69 (5/8/2009)

    I was more asking if anyone has used Microsofts service for SQLRAP or knew anything about it.

    I've had a couple done. I used to work for a Premier client, so we got them free with the contract.

    If you know everything that happens in your database, if you can smell a bad setting a mile away, if you're totally sure that everything from SQL to OS is configured optimally, you'll get no benefit from it.

    If, however, you've not sure what settings are what and how they should be, it may well be very useful. You will get a doorstop of a document at the end (if you print it, they're usually electronic). The doc will detail just about every setting that's not recommended, why it's a problem and what you should do.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • May 11, 2009 at 12:42 am

    #991910

    Thanks, we get it free on contract here and they're booked in for next month, I was a bit skeptical at first but I'm now quite looking forward to it as I think I will learn something.

    Thanks

  • May 11, 2009 at 1:32 am

    #991929

    Ask to be involved in the data capture for it. You probably would be anyway.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • May 11, 2009 at 1:50 am

    #991932

    Hi,

    How n where can we get this SQLRAP tool.

  • May 11, 2009 at 1:59 am

    #991933

    You have to ask Microsoft to come and do it for you, it's a bit of consultancy on their part, you can download the description, which doesn't tell you much about the processes but just what service they offer:

    http://www.microsoft.com/downloads/details.aspx?FamilyID=016C91A7-5B9F-4BDD-8897-70703A6E832F&displaylang=en

    We got it as part of a support contract but I assume you can also pay for it separately.

  • May 11, 2009 at 3:14 am

    #991960

    madhu (5/11/2009)

    How n where can we get this SQLRAP tool.

    It's not a tool. It's a service offered by Microsoft's Premier Support people. I don't know if you can get an evaluation without being a premier client. If you can it won't be cheap.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • May 11, 2009 at 5:49 am

    #992017

    Microsoft Consulting has a number of RAP services. SQL, Exchange and Active Directory are all worthwhile.

    MS will usually leave the data gathering tool behind when they're done. It is a useful benchmark to measure your progress against the recommendations

    --
    Andrew Hatfield

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply