| Best disk config for SME scale datawarehouse [message #584595] |
Wed, 15 May 2013 21:55  |
 |
clementstore
Messages: 11
Registered: December 2011
|
Junior Member |
|
|
Hello guys,
We are working on a Datawarehouse (ard 50G ) architecture with the following acquired environment:
Single server X3650 M4 Dual CPU ( 16 core in total ) with 48G ram
Oracle standard 10g x64
Windows 2008 x64
128 SSD x 8
IBM ServeRAID M5110e SAS/SATA Controller
Due to budget concern, we will be running the App server(Business OBjects 4.0 w/ Tomcat and DB server on the same machine. )
We have a user base of around 30 ppl on the app server.
We intend to have external redundancy using IBM raid card on raid 10 configuration. I wonder what kind of disk config yield better performance if we only have write update in the morning and 95% read for the rest ?
Raid 1 for OS (128SSD x 2 including DB logfile )
Raid 10 for DB server ( 128 SSD x 6 )
I heard ASM provides better disk management but just wonder it helps in performance in anyway.
Any advice on better disk configuration, segment size, block size ?
thanks
Clement
|
|
|
|
| Re: Best disk config for SME scale datawarehouse [message #584618 is a reply to message #584595] |
Thu, 16 May 2013 05:51  |
John Watson
Messages: 8960
Registered: January 2010
Location: Global Village
|
Senior Member |
|
|
Quote:I heard ASM provides better disk management but just wonder it helps in performance in anyway.
Any advice on better disk configuration, segment size, block size ?
ASM should help performance hugely. I would use your RAID to present four ASM disks striped with RAID 10 across the six SSDs. One diskgroup, 4M allocation units (assuming you don't want a sparate FRA).
|
|
|
|
| Re: Best disk config for SME scale datawarehouse [message #584888 is a reply to message #584618] |
Mon, 20 May 2013 04:27 |
|
clementstore
Messages: 11
Registered: December 2011
|
Junior Member |
|
|
|
Thanks very much for your input. I will try out your advice and hopefully see some improvement in production environment. I suspect it would be ok for one instance to use filebase database and another use ASM since I see ASM use its own instance. Also It might happen that we will only have 4 SSD for the DB now and I think i might still use 4 ASM disk as suggested. Cheers.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
