Home » RDBMS Server » Performance Tuning » Best disk config for SME scale datawarehouse (Oracle std 10Gx64, windows 2008 x64)
Best disk config for SME scale datawarehouse [message #584595] Wed, 15 May 2013 21:55 Go to next message
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 Go to previous messageGo to next message
John Watson
Messages: 8922
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 Go to previous message
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.
Previous Topic: Need help in performance tunning for querying table
Next Topic: Help required in analyzing Network waits from AWR
Goto Forum:
  


Current Time: Thu Mar 28 18:31:52 CDT 2024