Unsolved
This post is more than 5 years old
12 Posts
0
12851
September 20th, 2010 09:00
Optimal Storage Configuration for Hyperion Essbase?
We have an opportunity to configure our Essbase server from the ground up. Essbase stored data in a combination if IND and PAG. In my case, a typical database has 1gb of IND, and 2gb of PAG (the largest database is 2gb / 6gb). There are five Essbase databases.
The goal of performance tuning is improving "batch calculation". During a batch calc, the application cycles through the files, reading data in, calculating values, and then writing the values back to disk. It's very I/O intensive. For this reason, we usually try to put the IND and PAG files on different controller channels to split up the I/O. A typical batch calc on a large database takes 30 mins.
Our new (recycled) Essbase server has six HDDs. They are currently configured as: Two drives in a RAID1 set for the OS (channel 0), and Four drives in a RAID5 set with one of the drives as a hot spare for both data drives (channel 1). This doesn't allow the IND and PAG files to be split to the different RAID channels.
Would it help if we configured as follows?
- Two disks in RAID1 on Channel 0, supporting two logical disks, C:\ (OS) and E:\ (IND Files)
- Four disks in RAID10 on Channel 1, supporting one logical disk, F:\ (PAG Files)
Also, does partition alignment really help, and how do you do this in the context of a Dell server with a PERC 6/i with two partitions on one physical set? All the info I found on this addresses setting the offset for the first partition.
The server config is:
- Server Model: PE 2950
- OS: Windows 2003 Standard Edition SP2 64bit.
- Hard Drive Model: FUJITSU MBA3147RC 147GB 15,000RPM SAS Hard Drive (Qty: 6)
- Storage Controller: PERC 6/i


JeffMcDallas
12 Posts
0
September 20th, 2010 14:00
OK, our server group went ahead and configured the server as follows:
They didn't align the partitions. Not sure how much of an impact this is.