OraFAQ Forum: Performance Tuning » Best disk config for SME scale datawarehouse

Home » RDBMS Server » Performance Tuning » Best disk config for SME scale datawarehouse (Oracle std 10Gx64, windows 2008 x64)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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

Report message to a moderator

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: 8976
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).

Report message to a moderator

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.

Report message to a moderator

Previous Topic:	Need help in performance tunning for querying table
Next Topic:	Help required in analyzing Network waits from AWR

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat May 03 14:26:13 CDT 2025