This discussion is archived
6 Replies Latest reply: Jul 18, 2013 1:49 AM by user3259298 RSS

Using SSD in Essbase 11.1.2.2

rrinaldi Newbie
Currently Being Moderated
Hi Experts,
Is using SSD in Essbase is a good investments? We're trying to using SSD in Essbase but we're need to find out is it a good investments since SSD is quite expensive. Thanks.

Regards,

Ricki
  • 1. Re: Using SSD in Essbase 11.1.2.2
    621032 Oracle ACE
    Currently Being Moderated
    Hi Ricki,

    I've become a firm believer in SSD for Essbase. Especially with Intel's recent entry into the PCI SSD market. You can also take a look at my KSCOPE presentation which you can find at: http://www.emergenow.com/images/files/file/KSCOPE12_Planning_for_and_Managing_Hyperion_Infrastructure_JBooth.pdf

    Regards,

    John A. Booth
    http://www.metavero.com
  • 2. Re: Using SSD in Essbase 11.1.2.2
    rrinaldi Newbie
    Currently Being Moderated
    Hi John,
    Thank you for helping me here. I wonder, where is the suitable area for Essbase? FYI, we have about 1TB data (using ASO cube). If we put SSD in data file (*.dat), it will be very expensive investments. What do you think John? Do we need to put SSD for other purpose? Kindly need your advice. Thanks.
  • 3. Re: Using SSD in Essbase 11.1.2.2
    621032 Oracle ACE
    Currently Being Moderated
    Hello,

    You have to consider the expense of SSD in relation to memory as well as what level of investment you have to provide better performance.

    You can arrive at 1 TB of SSD in several different ways whether that be 2 of Intels PCI cards, internal drives, Fusion IO, ... so it sounds like your real question is about the price. This can run from $8,000 for a pair of the Intel cards to the mid tens of thousands of dollars for Fusion IO.

    I would suggest you try to prototype something using more consumer level hardware to confirm you will get the performance boost you may be hoping for by taking advantage of SSD and/or partner with someone who can assist you with benchmarking.

    Regards,

    John A. Booth
    http://www.metavero.com
  • 4. Re: Using SSD in Essbase 11.1.2.2
    908690 Newbie
    Currently Being Moderated
    The link for Essbase SSD document no longer exists. Can you post the new link. This looks interesting.We are about to do a POC.
    Thanks
    Jim
  • 5. Re: Using SSD in Essbase 11.1.2.2
    user3259298 Newbie
    Currently Being Moderated

    Hi John,

     

    I'm actually facing a similar discussion. Getting the your document mentioned above and perhaps additional information you presented on recent KScope13 could be very helpful for me.

     

    Thanks,

    Eric

  • 6. Re: Using SSD in Essbase 11.1.2.2
    user3259298 Newbie
    Currently Being Moderated

    Hi Jim,

     

    can you share some results of your PoC please.

     

    Thanks,

    Eric

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points