My first post so hello to everyone for the first time 🙂
I work for a company who make a large ERP product and my role is to spec hardware for the onsite Managed Service i.e. we manage from hardware up but in the customers data centre. There are around 10 non DB Server VM's and 2 SQL Server VM's for Production and a Dev that hosts multiples of Production database.
Currently we use the following systems
VMWare ESXi 5.1 + vCenter
HP DL380 x 2 | 64GB | Quad Core Xeons x 2
HP iSCSI P2000 | 10k for VM OS Drives and 15k for SQL Server 2008
GB Cisco Switches x 2
I am now working on an IBM solution and for a similar cost I can get the same spec with a few less disks in the SAN and 1 x 365 GB Fusion I/O card for one of the hosts. I have a 765GB one on loan at the moment and wow its fast but that's just in ATTO and IOMeter tests..
Some of our customers have 200GB DB's plus BLOB tables stored on slower disks.
Do you think it would be better to fill the VM Hosts with loads more memory and allocate this to the virtualised DB server or to stick with 64GB and use a Fusion I/O card to host the database?
1 x 8GB DIMM = £75
1 x 16GB DIMM = £160
1 x 365GB Fusion I/O card = £3508
If my memory allocation is bigger than my database what are my bottlenecks? CPU and Disk Writes?
If you have any ideas on hardware HP or IBM then please let me have them 🙂 Go wild...