Post reply

Improving SSAS performance with SSD Drives

  • December 29, 2009 at 5:03 pm

    #215352

    Hi does anyone have experience implementing solid state drives to improve Analysis Services cube performance. In particular we are interested in improving the performance of discount count measures in our cubes.

    How would everyone utilize the drives? The database files as well as the OLAP database files on the SSD drives?

  • January 1, 2010 at 9:49 am

    #1098095

    Hi.

    Please refer to the url below:

    http://www.sqlmag.com/Article/ArticleID/41230/sql_server_41230.html

    I wish it will be helpful.

    Regards,

    becklery.

    RAQ Report: Web-based Excel-like Java reporting tool[/url]

  • January 1, 2010 at 11:12 am

    #1098109

    Thanks, unfortunately I don't subscribe so that link doesn't help me, anyone else have any experience with this?

    Colin

  • January 14, 2010 at 9:44 am

    #1103738

    BUMP.

    This is something I have been wondering about.

    A Mirrored and Stripped array, 4 disks plus (2 striped and then mirrored) could achieve 170mbps per disk write and 200mbps read per disk. Now we have a SAN but I doubt it could compete on cost with those stats. OUr SAN disk is prohibitively expensive and I wonder if these may prove a cost effective solution, in an external NAS or other array that could be utilised by a cluster.

Viewing 4 posts - 1 through 3 (of 3 total)

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