Performance of Virtualized SQL Server–Based VMware vCenter Database
Nov 19, 2010
VMware vSphere is a sound platform on which to virtualize SQL Server databases. One overlooked database to consider for virtualization is the VMware vCenter database. Experiments discussed in this paper show the impact on performance of a SQL Server-based vCenter database when virtualized on VMware vSphere 4.1. Load generators, which model real world workload activity on the database, consisted of various SQL stored procedures that access and modify the performance data stored in the database. The execution time of these stored procedures was measured in virtual and native environments.