Table 2, Virtual server configuration details – Dell PowerEdge R820 User 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.