Solved!
Go to SolutionL
lirecsicnarf
3 Posts
0
1975
January 14th, 2017 11:00
Help: New Server Configuration
Hi.
I was tasked to purchase a new server for the new Oracle ERP (customized, not from Oracle itself) for a company. ERP users will be less than 50 users.
I am currently looking at R730 with the following configurations in mind.
1x Intel Xeon E5-2650 v4
8x 16GB 2400MT/s RDIMM
8x 300GB 15K 12GB/s SAS Drives
This would be my first implementation of a server so I honestly don't know it this config is enough for an Oracle database with less than 50 concurrent users. Or maybe it is even an overkill.
Also, I don't know what to do with the drives, should I get 8x300GB and run in RAID 10? What RAID and size is applicable for an ERP system(Oracle database)?
This are the client's requirements.
1. Hyper-V
2. 2 VM - 1 ERP, 1 Domain Controller
That's it. That's the info they gave me.
So my questions again are.
1. Does my initial config OK for an ERP system?
2. What RAID configuration and size of disk should I get? Client said that from their current system data size is 2-3GB/year.
theflash1932
11 Legend
•
16255 Posts
756
1
Posted January 14th, 2017 13:00
I would recommend:
- TWO processors. You will never regret the extra processing power, but you will likely one day regret not having configured it with two from the outset.
- RAID 10 would probably be the best choice for the array if going with SAS/15K, but ...
- I would recommend SSD's instead of HDD.
I'm not sure why you need a separate VM for the domain controller. Unless the DC and ERP are going to be a completely separate domain, there is no real need to have the DC be a VM. Can be, just make sure to have access to a local administrator on the host in case your DC doesn't boot. Two 250GB SSD's in RAID 1 should be fine for the OS, whether it is baremetal or holds the VHD.
Get a couple of SSD's in RAID 1 for the ERP VM. At 5GB/year for 5 years, even 240GB is way bigger than you need for the VM and the growth you mentioned, but I'd probably go 480GB just to ensure you never need to add space. SSD's will probably give you more than the speed you expect from a 4-spindle RAID 10, but if you needed higher performance than your SSD mirror can provide, then do four SSD's in a RAID 10, OR use a PCIe/NVMe drive.
lirecsicnarf
3 Posts
756
0
Posted January 14th, 2017 22:00
Two 250GB SSD's in RAID 1 should be fine for the OS, whether it is baremetal or holds the VHD.
Do I need a separate RAID for the OS? I am planning to run Hyper-V core on the same single RAID 10 config.
I have read from other sources that databases benefits more on RAM, do I need SSDs?
theflash1932
11 Legend
•
16255 Posts
756
1
Posted January 15th, 2017 12:00
Do I need a separate RAID for the OS? I am planning to run Hyper-V core on the same single RAID 10 config. Not necessarily ... a single RAID 10 for everything would probably be adequate if they are SSD or a very small/not highly utilized database, otherwise, you'd probably be wise to separate the database location physically on different disks.
I have read from other sources that databases benefits more on RAM, do I need SSDs? It depends on too many factors to give a blanket "yes" or "no" answer to that question, whether or not you "need" them, but you will never be sorry for having SSD's, and regardless of how much goes on in memory, writes must be committed to disk at some point.
lirecsicnarf
3 Posts
756
0
Posted January 16th, 2017 01:00
Ok, now I am really confused.
When you said RAID for the OS, does this mean this will be used for all the OS of all VM I will create and the hypervisor(Hyper-V)??
And a separate RAID 10 for the database files?
What my understanding now is:
1. Buy 6 or 8 SSD and configure 2 for RAID 1 for OSes, and 4 or 6 RAID 10 for database files.
2. I will install Hyper-V on the RAID 1.
3. Create VM from RAID 1, install Windows Server 2012 R2. Make and attached a new Disk created from the RAID 10 where Oracle will be installed?
Or did I misunderstood everything. Trying to learn everything from net.
Thanks BTW for helping.
theflash1932
11 Legend
•
16255 Posts
756
1
Posted January 16th, 2017 05:00
Hyper-V will be installed on the RAID 1. Hyper-V will manage all your VM's. The VHD (Virtual Hard Disk) for you VM's can be stored anywhere. IF you create a domain controller as a VM, you would put the VHD for that VM on the RAID 1, OR you could simply set up the host as a VM ... I don't see any reason to make it a VM. The VHD for your DB would be on the RAID 10.
1. Yes, although if you were considering 4xSAS RAID 10, you would probably be fine with 2xSSD.
2. Yes.
3. Yes, if that is what you want to do.