Dell PowerEdge R820 - Manual (Page 13)

Dell Virtualization Solution for Microsoft SQL Server 2012 using PowerEdge R820
13
Database Transactions per Second Figure 5.
Database Batch Requests per Sec Figure 6.
Medium VMs: We observed a more or less linear scalability of SQL transactions per second (TPS) and
SQL batch requests per second on adding multiple VMs. The observed average TPS per virtual machine
was around 118, 120, 122, 126, 124, 121 and 121 for 1 VM, 2 VMs, 3 VMs, 4 VMs, 5 VMs, 6 VMs and 7 VMs
respectively. Similar trend observed in SQL batch requests per second counter as well.
We could not find any major performance impact on the virtual machines on increasing the number of
Virtual machines and running similar workloads on different virtual machines simultaneously.
Large VMs: We observed a more or less linear scalability of SQL transactions per second (TPS) and SQL
batch requests per second on adding 1 to 4 VMs; however, adding 5 to 7 VM’s resulted in slight
performance degradation.
The performance impact was seen due to high processor utilization on the host machine; the observed
processor utilization was around 84.9, 93.1, 96.6 and 98.3 for 4VMs, 5VMs, 6VMs and 7VMs respectively.