Dell PowerEdge R820 - Manual (Page 11)

Dell Virtualization Solution for Microsoft SQL Server 2012 using PowerEdge R820
11
Test VM configuration for SQL Server
It is important to configure Virtual machines to give better performance when you deploy high I/O
extension workload on them. For the VM scalability experiments, the below VM configuration (Table 1)
was chosen to be the standard (baseline) configuration for the guest SQL server deployments.
Virtual Server Configuration Details Table 2.
Component Medium VM
Large VM
Processor
2VCPU
4VCPU
Memory 24 GB 24 GB
Storage OS: 100 GB VHD
Data:1 TB(RAID 10) OS: 100 GB VHD
Data:1 TB(RAID 10)
Operating System Windows 2008 R2 SP1
Standard Edition Windows 2008 R2 SP1
Standard Edition
Database size 50 GB 50 GB
Database Software SQL Server 2012
Standard Edition SQL Server 2012
Standard Edition
Users 12 24
SQL server enterprise edition may also be used in the guest VMs, in case the customers need additional
features like database encryption, database availability features, etc.
Figure 4 shows the storage layout between the VMs that we have used for the VM scalability tests.