1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Best disk segment / size config with SMall scale dataware house ; ASM needed ?

Discussion in 'General' started by clementstore, May 16, 2013.

  1. clementstore

    clementstore Guest

    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 ?