Hi,
I was wondering if someone could shed some light on a few questions i have.
Currently bought a dell r720 with 192 gigs of ram with 2x 2.90Ghz E5-2690 8 Core Processors, and 10 disks SSD 800 gigs with IT mode dell H310mini.
I was reading about the configuring the VM there's a few options im confused.
1) As for ZFS i would guess putting it on a RAID 10? as i need the best configuration for speed as the VM thats going to be running is MSSQL on windows server 2012r2
2) for that VM which is going to have MSSQL would i use the VirtIO Block controller and check mark the SSD emulation? Because as reading on the wiki it says
3) it also says that the IO Thread enable would work faster but its not able to backup on vzdumps?
4) as for the disk cache it says the best would be the no cache?
5) As for CPU socket currently have SQL standard, correct me if im wrong the standard 2012 allows me with 4 cores?
So in this case whats the rule of thumb for the sockets and core? as for the NUMA would be recommended to enable it?
Thank you
I was wondering if someone could shed some light on a few questions i have.
Currently bought a dell r720 with 192 gigs of ram with 2x 2.90Ghz E5-2690 8 Core Processors, and 10 disks SSD 800 gigs with IT mode dell H310mini.
I was reading about the configuring the VM there's a few options im confused.
1) As for ZFS i would guess putting it on a RAID 10? as i need the best configuration for speed as the VM thats going to be running is MSSQL on windows server 2012r2
2) for that VM which is going to have MSSQL would i use the VirtIO Block controller and check mark the SSD emulation? Because as reading on the wiki it says
Note that Discard is not supported on VirtIO Block drives.
3) it also says that the IO Thread enable would work faster but its not able to backup on vzdumps?
Note that backups do not currently work with IO Thread enabled.
4) as for the disk cache it says the best would be the no cache?
but even though i have a VM with MSSQL?The No cache default means that the guest system will be notified that a write is complete when each block reaches the physical storage write queue, ignoring the host page cache. This provides a good balance between safety and speed
5) As for CPU socket currently have SQL standard, correct me if im wrong the standard 2012 allows me with 4 cores?
So in this case whats the rule of thumb for the sockets and core? as for the NUMA would be recommended to enable it?
but are they talking about memory of the CPU or the memory of the ram?the memory is spread into local banks close to each socket. This can bring speed improvements as the memory bus
Thank you