agreementwindowsmail

TESTREPORTFEBRUARY2006VirtualizedOLTPworkloadperformancecomparisonofend-to-endsolutions:DellPowerEdgeM610withDellEqualLogicstoragevs.
HPProLiantBL465cwithHPStorageWorksEVA4400storageTESTREPORTMARCH2009KEYFINDINGSzTheDellPowerEdgeM610serverandDellEqualLogicstoragesupported22.
2percentmorevirtualmachinesthandidtheHPProLiantBL465cserverandHPStorageWorksEVA4400storage.
(SeeFigure1.
)zTheDellPowerEdgeM610serverandDellEqualLogicstoragehada32.
5percentperformance-per-wattadvantageovertheHPProLiantBL465cserverandHPStorageWorksEVA4400storage.
(SeeFigure2.
)ExecutivesummaryDellInc.
(Dell)commissionedPrincipledTechnologies(PT)tocomparevirtualizedonlinetransactionprocessing(OLTP)performanceoftwobladeserver-and-storagesolutions:DellPowerEdgeM610serverandDellEqualLogicstorageHPProLiantBL465cserverandHPStorageWorksEVA4400storageTheDellPowerEdgeM610solutionhadtwo2.
4GHzIntelXeonE5530processorsand72GBofRAMwhiletheHPProLiantBL465csolutionhadtwo2.
7GHZAMDOpteron2384processorsand64GBofRAM.
(TheDellPowerEdgeM610currentlysupportsuptothe2.
93GHzXeonX5570processor.
)ThedifferenceinthequantityandspeedofRAMinthesystemswasduetothedifferenceinsystemarchitecturesandwasnotafactorinperformanceaseachvirtualmachine(VM)waslimitedto4GBofRAM.
WeconnectedtheDellPowerEdgeM610totheEqualLogicstorageviaiSCSIandconnectedtheHPProLiantBL465ctotheEVA4400storageviaFibreChannel.
Weinstalledbuild148592ofaversionofESXstillunderdevelopmentasthehypervisorforeachserver.
ESXbuild148592supportsthenewvirtualizationtechnologiessuchasIntelVTExtendedPageTables(EPT).
Forthiscomparison,weselectedtheDVDStoreVersion2(DS2)testtool.
DS2isanopen-sourcesimulationofanonlinee-commerceDVDstore,wherecustomerslogin,browse,andorderproducts.
EachserverundertestranmultipleMicrosoftSQLServer2008workloads,oneperVM.
OnecopyoftheDS2databasewasoneachVM,witha20GBdatabaseperVM.
Bycombiningmultiplevirtualmachines,allrunningaCPU,memory,anddiskintensiveworkload,thetestplacedaheavyloadonboththeserverandthestorage.
Thus,itmeasuredtheperformanceoftheoverallsolution—serverandstorage,especiallyasitrelatestoanactiveOLTPenvironment.
ThemainDS2metricisordersperminute(OPM).
WereportOPMresultsfroma300-secondperiodofsteadyactivityandheavyloadduringtheDS2testrun.
TheWorkloadsectionexplainsinmoredetailtheMicrosoftSQLServer2008databaseworkload.
Figure1comparesthepeaknumberofvirtualmachinesrunningaMicrosoftSQLServer2008databaseworkloadthateachserverranwithacceptableperformance(allVMscoreshigherthanthebaseline).
TheDellPowerEdgeM610ran11suchsimultaneousVMs,whiletheHPProLiantBL465cran9suchsimultaneousVMs.
Thus,theDellPowerEdgeM610solutionhada22.
2percentperformanceadvantageovertheHPProLiantBL465csolution.
Inaddition,theDell024681012PeaknumberofvirtualmachinesMicrosoftSQLServer2008workloadresultsHigherresultsarebetterHPProLiantBL465cserverandHPStorageWorksEVA4400storageDellPowerEdgeM610serverandDellEqualLogicstorageServerandstoragesolutionFigure1:MicrosoftSQLServer2008workloadperformanceresultsforthetwosolutions.
Highernumbersarebetter.
2PrincipledTechnologies,Inc.
:VirtualizedOLTPworkloadperformancecomparisonofend-to-endsolutions:DellPowerEdgeM610withDellEqualLogicstoragevs.
HPProLiantBL465cwithHPStorageWorksEVA4400storagePowerEdgeM610solutionhad4.
7percentmoreaverageOPMsperVMthandidtheHPProLiantBL465csolution.
AsFigure2shows,theDellM610solutiondelivered32.
5percentmoreperformance/wattthandidtheHPBL465csolution.
Wenormalizedtheresultsforeachworkloadtothoseoftheserverwithlowerperformance/watt.
Wecomputeperformance/wattbydividingthebenchmark'sscorebytheaveragepowerconsumption,inwatts,ofthesolutionduringtheperiodthebenchmarkwasdeliveringpeakperformance.
WeinstalledandrantheDS2clientfromVMsonaseparateESX3.
5hostwithfourIntelX74602.
66Ghzprocessorsand64GBofRAM.
WeranasingleinstanceoftheclientperVM,andeachclientVMtargetedonlyoneserverVM.
Weassigned2virtualprocessorsand4GBofRAMtoeachclientVM.
WedefinedthepeaknumberofVMsperserverasthemaximumnumberofconcurrentVMsunderloadwhereeachVMhadatleasttheperformanceoutputinOPMasthebaseline.
BasedonouranalysisandexperiencewithDS2,wesetthebaselineat2600OPM.
EachVMonboththePowerEdgeM610andProLiantBL465chadtoscoreaminimumof2,600OPMtobevalid.
CPUutilizationwasnear100%onbothserverswhenrunningatpeakVMlevels.
WorkloadWeconductedourtestingusingDVDStoreVersion2,anopen-sourceapplicationwithaback-enddatabasecomponent,afront-endWebapplicationlayer,andadriverlayerthatoperatesasthemiddletierandactuallyexecutestheworkload.
Becauseourgoalwastoisolateandtestdatabaseserverstorage,wedidnotusetheWebapplicationlayer.
Instead,weranthedriverapplicationdirectlyviaitscommand-lineinterface.
DS2modelsanonlineDVDstore.
Virtualcustomerslogin;browsemoviesbyactor,title,orcategory;andpurchasemovies.
Theworkloadalsocreatesnewcustomers.
Browsingmoviesinvolvesselectoperations,someofwhichusefull-textsearchandsomeofwhichdonot.
Thepurchase,login,andnewcustomerproceduresinvolveupdatesandinserts,aswellasselects.
Theworkload'smainreportingmetricisordersperminute(OPM).
FormoredetailsabouttheDS2tool,seehttp://www.
delltechcenter.
com/page/DVD+Store.
EachclientVMranasingleinstanceofDS2,whichspawned32threads,anduseda15:1search-to-orderratio,whichweimplementedviatheprovidedn_searchesparameterinDVDStore.
Thissimulatedaheavilyloadedenvironment;theload-generatingclientVMsranwithnothinktime,blastingrequestsasquicklyastheserverscouldhandlethem.
0.
000.
200.
400.
600.
801.
001.
201.
40Normalizedcomparison-MicrosoftSQLServer2008Performance/wattresultsHigherresultsarebetterHPProLiantBL465cserverDellPowerEdgeM610serverServerFigure2:Performance/wattresultsforthesolutionsnormalizedtothatoftheHPProLiantBL465csolution.
Highernumbersarebetter.
3PrincipledTechnologies,Inc.
:VirtualizedOLTPworkloadperformancecomparisonofend-to-endsolutions:DellPowerEdgeM610withDellEqualLogicstoragevs.
HPProLiantBL465cwithHPStorageWorksEVA4400storageTheDS2driverapplicationcreatesanorders-per-minuteperformancecounterontheclientVM.
WhiletheDVDStoreclientapplicationoutputsOPMat10secondintervalsvisually,wechosetocollectthisOPMmetricviaaPerformanceMonitorcounteroneachclientVMatone-secondintervals.
Weranthisworkloadonallvirtualmachinessimultaneouslyfor30minutes.
WeconsideredasolutiontohavedeliveredacceptableperformanceiftheminimumOPMscoreoneveryclientVMduringthe23to28minuteperiodofthetestwasabovethebaselineOPM.
TestresultsFigure3showsthepeaknumberofvirtualmachineseachsolutioncouldhandleduringtestingbeforedippingbelowtheacceptablethresholdandtheminimumclientscorefromthemedianrun.
BasedonouranalysisandexperiencewithDS2,wesetthebaselineat2,600OPM.
EachVMonboththePowerEdgeM610andProLiantBL465chadtoscoreaminimumof2,600OPMtobevalid.
ServerPeaknumberofvirtualmachinesAverageOPMScoreDellPowerEdgeM610andDellEqualLogicstorage113012.
65HPProLiantBL465candHPStorageWorksEVA4400storage92877.
40Figure3:ThepeaknumberofvirtualmachinesforthetwosolutionsandtheaverageOPMscore.
Highernumbersarebetter.
Figure4showstheindividualVMOPMscoresandtheminimumOPMscoreforeachrunontheDellPowerEdgeM610solution.
Run1isthemedianrun.
DellPowerEdgeM610andDellEqualLogicstorageRun1Run2Run3VM1OPMs2719.
642952.
152683.
73VM2OPMs2994.
952965.
552910.
87VM3OPMs3078.
843034.
803077.
00VM4OPMs2996.
722940.
002992.
86VM5OPMs3068.
553044.
623143.
99VM6OPMs3026.
232971.
873013.
44VM7OPMs3064.
133061.
583135.
41VM8OPMs3070.
242874.
693013.
90VM9OPMs3051.
023069.
943024.
83VM10OPMs3009.
682949.
713010.
02VM11OPMs3059.
133014.
083642.
30MinimumOPMs2719.
642874.
692683.
73Figure4:IndividualVMscoresandtheminimumOPMscorefromthethreerunsontheDellPowerEdgeM610solution.
Highernumbersarebetter.
Figure5showstheindividualVMOPMscoresandtheminimumOPMscoreforeachrunontheHPProLiantBL465cserver.
Run3isthemedianrun.
4PrincipledTechnologies,Inc.
:VirtualizedOLTPworkloadperformancecomparisonofend-to-endsolutions:DellPowerEdgeM610withDellEqualLogicstoragevs.
HPProLiantBL465cwithHPStorageWorksEVA4400storageHPProLiantBL465candHPStorageWorksEVA4400storageRun1Run2Run3VM1OPMs2673.
542714.
952777.
49VM2OPMs2981.
153001.
642858.
88VM3OPMs2889.
642787.
492765.
96VM4OPMs2712.
402623.
062776.
15VM5OPMs3061.
163043.
133178.
67VM6OPMs2782.
322935.
132942.
31VM7OPMs3114.
323022.
562943.
86VM8OPMs2781.
102892.
592659.
43VM9OPMs3011.
333003.
512993.
80MinimumOPMs2673.
542623.
062659.
43Figure5:IndividualVMscoresandminimumOPMscorefromthethreerunsontheHPProLiantBL465csolution.
Highernumbersarebetter.
Figure6detailsthepowerconsumption,inwatts,oftheserverswhileidleandduringthemedianrunoftheMicrosoftSQLServer2008databaseworkload.
ServerIdlepower(watts)Averagepower(watts)DellPowerEdgeM610508.
19633.
82HPProLiantBL465c561.
55686.
95Figure6:Averagepowerusage(inwatts)ofthetwoserverswhileidleandduringthemedianrunofMicrosoftSQLServer2008databaseworkload.
Lowernumbersarebetter.
TestmethodologySettingupandconfiguringthestorageDellEqualLogicstorageconfigurationEachofthefourDellEqualLogicarrayshas16drives,foratotalof64drives.
EachofthefiveHPStorageWorksEVA4400storagetrayshas12drives,foratotalof60drives.
Inordertomatchthedrivecountofthetwostorageconfigurations,weconfiguredtwoDellEqualLogicarraysinRAID10no-sparesmode(16activedriveseach)andtwoDellEqualLogicarraysinregularRAID10mode(14activedriveseach),foratotalof60drives.
WeconnectedtheDellServertotheDellEqualLogicstorageviathree1Gb/sEthernetcables.
WeconfiguredtheDellEqualLogicstorageintotwostoragepools.
Figure7showsthestoragelayout.
TheVMoperatingsystemandlogstoragepool(StoragePool1)containedoneDellEqualLogicPS6000Array.
Thedatabasestoragepool(StoragePool2)containedthreeDellEqualLogicPS5000XVArrays.
Wecreatedone1.
28TBvolumeintheVMoperatingsystemandlogstoragepool.
FollowingVMware'sbestpracticesregardingaddingstoragetoESX,weusedvSpheretoconnectthisstoragepooltoESXServerasasingledatastoreviatheESXiSCSIinitiatorusingonephysicalNIC.
Wecreated1160GBvolumesinthedatabasestoragepool.
WeusedtheMicrosoftiSCSIInitiatorwiththeEqualLogicHostIntegrationToolkit(HIT)withineachVMtoconnectone60GBvolumetoeveryVMthroughtwovirtualNIC'ssharedbetweeneveryVM.
5PrincipledTechnologies,Inc.
:VirtualizedOLTPworkloadperformancecomparisonofend-to-endsolutions:DellPowerEdgeM610withDellEqualLogicstoragevs.
HPProLiantBL465cwithHPStorageWorksEVA4400storageFigure7:ThelayoutoftheDellEqualLogicstorage.
Settingupthestorage1.
Usingthecommandline,setupastoragegroupwiththefollowingRAIDpolicies:a.
PS5000XV-1:RAID-10(no-spares)b.
PS5000XV-2:RAID-10c.
PS5000XV-3:RAID-10(no-spares)d.
PS6000:RAID-102.
Createastoragepoolnameofdatabasewiththefollowingmembers:a.
PS5000XV-1b.
PS5000XV-2c.
PS5000XV-33.
CreateastoragepoolnameofOS-Logwiththefollowingmember:a.
PS60004.
EnableallnetworkconnectionsoneachPS5000XVandPS6000usingthefollowingIPaddressscheme:a.
IPAddress:192.
168.
1.
##(##beinganynumberbetween10and60)b.
SubnetMask:255.
255.
248.
05.
Create1160GBvolumesinthedatabasestoragepoolwithnosnapshotreserve,andnamethemdvd-store#(#being1-11)6.
Createone1.
28TBvolumeinthedatabasestoragepoolwithnosnapshotreserve,andnameitOS-Log.
7.
EnablesharedaccesstotheiSCSItargetfrommultipleinitiatorsoneveryvolume.
8.
Createanaccesscontrolrecordforeveryvolumewithoutspecifyinganylimitations.
9.
Createaread-onlySNMPcommunitynametouseforgroupmonitoring.
HPStorageWorksstorageconfigurationWeconnectedtheHPServertotheHPStorageWorksstorageviatwo4Gb/sFibreChannelcables.
WeconfiguredtheHPStorageWorksstorageintotwodiskgroupsusingRAID10.
Figure8showsthestoragelayout.
Ourdatabasediskgroup(DiskGroup1)contained48disks.
OurVMoperatingsystemandlogdiskgroup(Disk6PrincipledTechnologies,Inc.
:VirtualizedOLTPworkloadperformancecomparisonofend-to-endsolutions:DellPowerEdgeM610withDellEqualLogicstoragevs.
HPProLiantBL465cwithHPStorageWorksEVA4400storageGroup2)contained12disks.
Wecreatedone819GBvolumeintheoperatingsystemandlogdiskgroup,whichweconnectedtoESXServerasasingledatastoreandassignedtoonefibrechannelport.
FollowingVMwarebestpractices,weusedthevSphereclienttoconnectthestoragetoESXtoensureproperalignment.
Wecreatedtwo1,569GBvolumesinthedatabasediskgroup,whichweconnectedtoESXServerastwodatastoresandassignedtoonefibrechannelport.
Figure8:ThelayoutoftheHPStorageWorksstorage.
Settingupthestorage1.
Createadiskgroupwiththefollowingparameters:a.
Name:Databaseb.
Disks:1-48c.
Diskdrivefailureprotection:Noned.
AlarmLevel:100%2.
Createadiskgroupwiththefollowingparameters:a.
Name:OS-Logb.
Disks:49-60c.
Diskdrivefailureprotection:Noned.
AlarmLevel:100%3.
CreateanewvDiskwiththefollowingparameters:a.
Name:Database17PrincipledTechnologies,Inc.
:VirtualizedOLTPworkloadperformancecomparisonofend-to-endsolutions:DellPowerEdgeM610withDellEqualLogicstoragevs.
HPProLiantBL465cwithHPStorageWorksEVA4400storageb.
Size:1,569GBc.
DiskGroup:Databased.
Redundancy:Vraid14.
CreateanewvDiskwiththefollowingparameters:a.
Name:Database2b.
Size:1,569GBc.
DiskGroup:Databased.
Redundancy:Vraid15.
CreateanewvDiskwiththefollowingparametersa.
Name:OS-Logb.
Size:819GBc.
DiskGroup:OS-Logd.
Redundancy:Vraid16.
CreateaHost,andaddtheworldwidenameforbothFibreChanneladaptersoneachserverundertest.
AdjustingBIOSsettingsTomaximizeperformanceforeachserver,weadjustedtheBIOSsettingsasfollows:DellPowerEdgeM610system:Weenabledvirtualization.
HPProLiantBL465csystem:WeenabledvirtualizationandenabledNo-ExecutePage-Protection.
SettingupthehostserverWeinstalledbuild148592ofaversionofESXstillunderdevelopmentonthehostserver.
ESXbuild148592supportsthenewvirtualizationtechnologiessuchasEPT.
WealsoinstalledthevSphereclienttoolonamanagementworkstation,whichwasanIntelPentium4,6303.
00GHzrunningWindowsVistaUltimateSP1(6001)with2GBRAM.
InstallingESXBuild1485921.
InsertESXBuild148592DVD,andrestartthecomputer.
2.
Whilebooting,pressF11toenterBootMenu.
3.
Pressthedownarrowtonavigatetotheappropriatebootdevice,andpressEnter.
4.
TostartESXingraphicalmode,pressEnter.
5.
OntheWelcomescreen,clickNext.
6.
Clickthecheckboxtoacceptthetermsofthelicenseagreement,andclickNext.
7.
Acceptthedefaultkeyboardlayout,andclickNext.
8.
OntheCustomDriversscreen,chooseNotoinstallcustomdrivers,andclickNext.
9.
YouwillreceiveawarningifyouchoseNo.
ClickYestoproceed.
Driverswillloadatthispoint.
10.
ClickNext.
11.
Enteryourserialnumbernow,orchoosetoenteronelater.
ClickNext.
12.
OntheNetworkConfigurationscreen,choosetheNICthatyouwilluseforsystemtasks.
ClickNext.
13.
OnthenextNetworkConfigurationscreen,setyourIPaddressinginformation,subnetmask,DNS,andhostname.
ClickNext.
14.
OntheSetupTypescreen,choosestandardsetup.
15.
SelectthevirtualdiskyouwishtoinstallESXon,andclickNext.
16.
OntheDataLosswarningscreen,clickOK.
17.
OntheTimeZoneSettingsscreen,chooseyourappropriatetimezone,andclickNext.
18.
OntheDateandTimescreen,modifythedateandtimeasyouwish,andclickNext.
19.
AssignarootpasswordforESX.
Optionally,addadditionalusersifyouwish,andclickNext.
20.
OntheSummaryscreen,clickNexttoinstall.
21.
Whentheinstallationiscomplete,clickNext.
22.
ClickFinishtorebootthesystem.
Enablingsecureshell(ssh)accessfortherootuser1.
UsingPutty,Cygwin,oranotherterminal,sshtotheESXServer.
2.
Typethefollowingcommandtoswitchtotherootuser:8PrincipledTechnologies,Inc.
:VirtualizedOLTPworkloadperformancecomparisonofend-to-endsolutions:DellPowerEdgeM610withDellEqualLogicstoragevs.
HPProLiantBL465cwithHPStorageWorksEVA4400storage#su-3.
Entertherootuserpassword.
4.
Typethefollowingcommandtochangetotheappropriatedirectory:#cd/etc/ssh5.
Editthesshd_configfileusingvi.
Usethefollowingcommand:#visshd_config6.
PressthedownarrowkeytomovethecursortothePermitRootLoginline,andthenmovethecursortothewordno.
Presstheikeytoinserttext.
7.
Typethewordyesanddeletethewordno.
8.
PresstheEscapekeytoreturntocommandmode.
9.
Typethefollowingcommandtosaveandexitthefile::wq10.
Typethefollowingcommandtoreboottheserver:#init6InstallingvSphereonamanagementworkstation1.
NavigatetotheIPaddressofyourESXServer.
2.
Acceptcertificatewarnings,andcontinue.
3.
ClickvSpheretodownloadthevSphereclient.
4.
ChooseRuntoinstall.
5.
Chooseyourlanguage,andclickOK.
6.
OntheWelcomescreen,clickNext.
7.
Acceptthelicenseterms,andclickNext.
8.
Enteruserandorganizationdetails,andclicknext.
9.
Optionally,clickthecheckboxtoinstalltheupdateutility.
ClickNext.
10.
OntheDestinationFolderscreen,clickNext.
11.
ClickInstall.
12.
ClickOK.
ConnectingthestoragetothehostOntheDellEqualLogicstorage,weconnectedtheOS-LogvolumetotheESXServerVMkernelusingonephysical1GbNIC.
Wepresentedeachvirtualmachinewithtwo1GbvirtualNIC'sconnectedtotwophysicalNIC'sthatweusedtoconnecttheMicrosoftiSCSIInitiatorwithintheVirtualMachinetoitsindividualiSCSIdatabasevolume.
OntheHPStorageWorksstorage,weconnectedtheOS-LogvolumetoESXServerusingthefirstFibreChanneladapter.
WeconnectedthetwodatabasevolumestoESXServerusingthesecondFibreChannelAdapter.
WeconnectedanadditionalvirtualNICtoaphysical1GbNICforDVDStoreclienttoservercommunications.
AddingtheiSCSIstorageadapterinESX(Dellonly)1.
ClickStart,AllPrograms,VMware,VMwarevSphereclient.
2.
ClicktheConfigurationtab.
3.
ClickNetworking.
4.
ClickAddNetworking…5.
SelecttheVMkernelradiobutton,andclickNext.
6.
DeselectanyselectedNICsthatvSphereshowsas"down".
SelectthefirstoftheavailablefourNICsthatvSpheredoesnotshowas"down"intheSpeedcolumn.
ClickNext.
7.
Assignalabeltothenetwork.
ClickNext.
8.
EnteravalidIPaddressandsubnet.
ClickNext.
9.
ClickFinish.
10.
ClickNowhentheapplicationpromptsyoutoenteradefaultgateway.
11.
ClicktheConfigurationtab.
12.
ClickStorageAdaptersunderHardwarepane.
13.
ClickiSCSISoftwareAdapter.
Then,clickProperties.
9PrincipledTechnologies,Inc.
:VirtualizedOLTPworkloadperformancecomparisonofend-to-endsolutions:DellPowerEdgeM610withDellEqualLogicstoragevs.
HPProLiantBL465cwithHPStorageWorksEVA4400storage14.
ClickConfigure.
15.
ClickEnabled.
16.
ClickOK.
17.
Aftertheapplicationdisablesthedevice,clicktheDynamicDiscoverytab.
18.
ClickAdd.
19.
EntertheIPaddressofthestoragegroup.
20.
ClickClose.
21.
ClickYeswhentheapplicationpromptsyoutorescanforchanges.
AddingthestoragevolumestoESXstorage1.
InvSphere,clicktheConfigurationtab2.
ClickStorageintheHardwarepane.
3.
ClickAddStorage…4.
ChooseDisk/LUN.
ClickNext.
5.
SelecttheappropriateLUN.
ClickNext.
6.
ClickNext.
7.
Enteranameforthedatastore.
ClickNext.
8.
ClickNexttoacceptthedefaultsforblocksize.
9.
ClickFinishtocompletetheadditionoftheLUN.
10.
Repeatsteps1through9twomoretimes(HPonly).
SettinguptheiSCSINICswithvSphere(Dellonly)1.
ClicktheConfigurationtab.
2.
ClickNetworking.
3.
ClickAddNetworking.
4.
ClickVirtualMachine.
5.
ChoosetoCreateavirtualswitch.
AssigntherelevantNICinthesystem.
ClickNext.
6.
Assignanetworkname.
7.
ClickFinish.
8.
Repeatsteps1through7oncemore.
CreatingandconfiguringtheVMsCreatingthevirtualmachinewithvSphere1.
ClickStart,AllPrograms,VMware,VMwarevSphereclient.
2.
EntertheIPaddressorhostname,username,andpassword.
ClickLogin.
3.
ClicktheVirtualMachinestab.
4.
Right-click,andchooseNewVirtualMachine.
5.
ChooseCustom,andclickNext.
6.
Assignanametothevirtualmachine.
ClickNext.
7.
Selectadatastoreforthevirtualmachinefiles.
WechosetheOS-LogDatastore.
ClickNext.
8.
ChooseVirtualMachineVersion7toutilizebuild148592ofESX.
ClickNext.
9.
ChooseMicrosoftWindows,thenMicrosoftWindowsServer2008(64-bit).
ClickNext.
10.
Choosetwovirtualprocessors.
ClickNext.
11.
Choose4GBRAM.
ClickNext.
12.
ClickNoneforthenumberofNICs.
ClickNext.
13.
ChooseLSILogicSASastheSCSIcontroller.
ClickNext.
14.
Choosetocreateanewvirtualdisk.
ClickNext.
15.
MaketheOSvirtualdisksize50GB,andclickNext.
16.
Keepthedefaultvirtualdevicenode,andclickNext.
17.
ClickFinish.
18.
Right-clicktheVM,andchooseEditSettings.
19.
OntheHardwaretab,clickAdd…20.
ChooseEthernetAdapter,andclickNext.
21.
ChooseVMXNet3,andClickNext.
22.
ClickFinish.
10PrincipledTechnologies,Inc.
:VirtualizedOLTPworkloadperformancecomparisonofend-to-endsolutions:DellPowerEdgeM610withDellEqualLogicstoragevs.
HPProLiantBL465cwithHPStorageWorksEVA4400storage23.
ClickOK.
Installingtheguestoperatingsystem1.
InserttheinstallationDVDforWindowsServer2008x64intotheDVDdrive.
2.
InvSphere,right-clickthevirtualmachine,andchooseCD/DVDdrive.
3.
ClicktheHostDeviceradiobutton,andchoosetheappropriatedrive.
4.
ClickOK.
5.
Right-clickthemachine,andchoosePower,PowerOn.
6.
Right-clickthemachine,andchooseOpenconsole.
7.
Choosethelanguage,timeandcurrency,andkeyboardinput.
ClickNext.
8.
ClickInstallNow.
9.
ChooseWindowsServerEnterprise(FullInstallation).
ClickNext.
10.
Acceptthelicenseterms,andclickNext.
11.
ClickCustom.
12.
ClicktheDisk,andclickDriveoptions(advanced).
13.
ClickNew,Apply,Format,andthenclickNext.
14.
Lettheinstallationprocesscontinue.
TheVMwillrebootseveraltimes.
15.
Aftertheinstallationcompletes,clickOKtosettheAdministratorpassword.
16.
Entertheadministratorpasswordtwice,andclickOK.
17.
Whentheoperatingsystemsfinishesbooting,chooseVM,Guest,Install/UpgradeVMwareTools.
18.
OntheinformationInstallVMwareToolsscreen,clickOK.
19.
Ontheautoplaymenu,clickRunsetup.
exe.
20.
OntheWelcomescreen,clickNext.
21.
OntheSetupTypescreen,chooseTypical,andclickNext.
22.
ClickInstall.
23.
OnthevariousWindowsSecurityscreens,clickInstalleachtime.
24.
ClickFinishtocompletetheinstallation.
25.
ClickYestoreboottheVM.
26.
LogintotheVMafterreboot.
27.
ClickStart,ControlPanel,thendouble-clickSystem.
28.
ClickChangeSettings.
29.
ClickChange.
30.
Enterthenewcomputername,andclickOK.
31.
ClickOKtorestart,clickClose,andclickRestartNow.
ConfiguringnetworkingintheVM1.
PowerontheVM,andopentheconsole.
2.
ClickStart,ControlPanel,NetworkConnections,thenclickManageNetworkConnections.
3.
Right-clicktheNIC,andchooseproperties.
4.
SelectTCP/IP(v4),andchooseproperties.
5.
SettheIPaddress,subnet,gateway,andDNSserverforthisNIC,whichwillhandleoutgoingservertraffic(i.
e.
,thepublicIP).
ClickOK,thenclickClose.
6.
OntheDellserver,repeatsteps2through5twice,buttheseNIC'sshouldbeonthesamenetworksegmentastheDellEqualLogicstorage.
InstallingtheHostIntegrationtoolkitontheVM(Dellonly)1.
Downloadthehostintegrationtoolkit(Setup64.
exe).
2.
DoubleclickSetup64.
exe.
3.
Acceptthesecuritywarnings,andchoosetoruntheexe.
4.
ClickNext.
5.
ClickAccept,thenNext.
6.
ClickTypical,thenNext.
7.
YouwillseeaWindowsFirewallwarning;leaveitopenforaminute.
8.
ClicktheStartbutton,thenchooseAdministrativeToolsWindowsFirewallwithAdvancedSecurity.
9.
Intheleftpanel,clickInboundRules.
10.
InthecenterInboundRulespanel,right-clickiSCSIService(TCP-In),andchooseEnableRule.
11PrincipledTechnologies,Inc.
:VirtualizedOLTPworkloadperformancecomparisonofend-to-endsolutions:DellPowerEdgeM610withDellEqualLogicstoragevs.
HPProLiantBL465cwithHPStorageWorksEVA4400storage11.
InthecenterOutboundRulespanel,right-clickiSCSIService(TCP-In),andchooseEnableRule.
12.
ClosetheWindowsFirewalldialog.
13.
Clearthemessagebox.
14.
ClickInstall.
15.
ClickYestoinstallmultipathsoftwareautomatically.
16.
Choosetorestartthecomputerwhentheapplicationpromptsyoutodoso.
InstallingWindowsupdates1.
PowerontheVM,andopentheconsole.
2.
LogintotheVM.
3.
ClickStart,WindowsUpdate.
4.
ClickViewAdvancedOptions.
5.
ClickNeverCheckforUpdates.
6.
ClickOK.
7.
ClickCheckforUpdates.
8.
ClickInstallNowwhentheapplicationpromptsyoutoinstallanupdateforWindowsupdate.
9.
ClickViewavailableupdatestoensureyouinstallthenecessaryupdates.
Note:Weinstalledthefollowingupdates:HotfixforWindows(KB942288)SecurityUpdateforWindowsServer2008x64Edition(KB958687)UpdateforWindowsServer2008x64Edition(KB957388)SecurityUpdateforWindowsServer2008x64-basedSystems(KB938464)SecurityUpdatesforWindowsServer2008x64Edition(KB955069)CumulativeSecurityUpdateforInternetExplorer7forWindowsServer2008x64Edition(KB961260)SecurityUpdatesforWindowsServer2008x64Edition(KB954459)SecurityUpdatesforWindowsServer2008x64Edition(KB957097)SecurityUpdatesforWindowsServer2008x64Edition(KB958623)SecurityUpdatesforWindowsServer2008x64Edition(KB953733)SecurityUpdatesforWindowsServer2008x64Edition(KB950762)UpdateforWindowsServer2008x64Edition(KB955839)SecurityUpdatesforWindowsServer2008x64Edition(KB958624)SecurityUpdatesforWindowsServer2008x64Edition(KB950974)UpdateforWindowsServer2008x64Edition(KB951978)Microsoft.
NETFramework3.
5ServicePack1and.
NETFramework3.
5FamilyUpdate(KB951847)x64SecurityUpdatesforWindowsServer2008x64Edition(KB954211)SecurityUpdateforWindowsMailforWindowsServer2008x64Edition(KB951066)UpdateRollupforActiveXKillbitsforWindowsServer2008x64Edition(KB960715)SecurityUpdatesforWindowsServer2008x64Edition(KB956841)SecurityUpdatesforWindowsServer2008x64Edition(KB956802)UpdateforWindowsServer2008x64Edition(KB957321)UpdateforWindowsServer2008x64Edition(KB952287)WindowsMaliciousSoftwareRemovalToolx64–Febuary2009(KB890830)SecurityUpdatesforWindowsServer2008x64Edition(KB958644)SecurityUpdatesforWindowsServer2008x64Edition(KB958644)UpdateforWindowsServer2008x64Edition(KB950050)CumulativeSecurityUpdateforActiveXKillbitsforWindowsServer2008x64Edition(KB950760)UpdateforWindowsServer2008x64Edition(KB955302)WindowsUpdatesoftware7.
2.
6001.
78810.
ClickInstall.
11.
Agreetothelicenseterms,andclickFinish.
12.
ReboottheVMwhentheapplicationrequestsyoudoso.
12PrincipledTechnologies,Inc.
:VirtualizedOLTPworkloadperformancecomparisonofend-to-endsolutions:DellPowerEdgeM610withDellEqualLogicstoragevs.
HPProLiantBL465cwithHPStorageWorksEVA4400storage13.
Afterreboot,checkWindowsupdateagainforfurtherupdates.
ClickStart,WindowsUpdate.
14.
ClickCheckforupdates.
15.
IfWindowslistsnoimportantupdates,thenclosetheupdateswindow.
InstallingSQLServer2008ontheVM1.
InserttheDVDintothephysicalDVDdrive.
2.
Right-clicktheVM,andchoosePower,PowerOn.
3.
Right-clicktheVM,andchooseOpenConsole.
4.
ClicktheConnectCD/DVDbutton.
ChooseCD/DVDDrive1,Connecttohostdevice…5.
ClickRunSETUP.
EXEontheautoplaymenu.
6.
Whentheapplicationpromptsyoutoinstallthe.
NETFramework,clickOK.
7.
SelecttheAcceptradiobutton,andclickInstall.
8.
Whentheinstallationfinishes,clickExit.
9.
Whentheapplicationpromptsyou,clickOKtoinstallahotfixforWindows(KB942288).
10.
ClickRestartnowtorestarttheVMuponcompletion.
11.
Afterrebooting,logintotheVM.
12.
ClickStart,Computer.
13.
Double-clicktheCD/DVDdrive.
14.
ClickInstallation.
15.
ClickNewSQLServerstand-aloneinstallation.
16.
OntheSetupsupportrulesscreen,clickOK.
17.
SpecifytheEnterpriseEvaluationfreeedition.
ClickNext.
18.
Clickthecheckboxtoacceptthelicenseterms.
ClickNext.
19.
ClickInstalltoinstallthesetupsupportfiles.
20.
YoumayseeaWindowsFirewallwarning.
Fornow,ignorethis,andclickNext.
21.
OntheFeatureSelectionscreen,selectDatabaseEngineServices,Full-TextSearch,ClientToolsConnectivity,ClientToolsBackwardCompatibility,ManagementTools–Basic,andManagementTools–Complete.
ClickNext.
22.
OntheInstanceconfigurationscreen,clickNext.
23.
OntheDiskspacerequirementsscreen,clickNext.
24.
OntheServerconfigurationscreen,chooseNTAUTHORITY\SYSTEMforSQLServerAgent,andchooseNTAUTHORITY\SYSTEMforSQLServerDatabaseEngine.
ClickNext.
25.
OntheDatabaseEngineConfigurationscreen,selectMixedMode.
26.
Enterapasswordforthesystemadministratoraccount.
27.
ClickAddCurrentuser.
Thismaytakeseveralseconds.
28.
ClickNext.
29.
OntheErrorandusagereportingscreen,clickNext.
30.
Ontheinstallationrulesscreen,clickNext.
31.
OntheReadytoInstallscreen,clickNext.
32.
Afterinstallationiscomplete,clickStart,AdministrativeTools,AddinganadditionaldrivetotheVMviatheiSCSIinitiator(Dellonly)1.
PowerontheVM,andopentheconsole.
2.
ClickStart,ControlPanel,anddouble-clickiSCSIInitiator.
3.
ClicktheDiscoverytab.
4.
ClickAddPortal…5.
AddtheIPaddressoftheDellEqualLogicstoragegroup.
6.
ClickOK.
7.
ClicktheTargetstab.
8.
FindtherelevantSQLDatavolumeforthisVM,andselectit.
ClickLogOn…9.
Checkthecheckboxtoallowautomaticlogononreboot,andtoalsoenablemultipath.
10.
ClickOK.
AddinganadditionalvirtualdrivetotheVMviavSphere(HPonly)1.
PowerofftheVM,right-clickandchooseEditSettings.
13PrincipledTechnologies,Inc.
:VirtualizedOLTPworkloadperformancecomparisonofend-to-endsolutions:DellPowerEdgeM610withDellEqualLogicstoragevs.
HPProLiantBL465cwithHPStorageWorksEVA4400storage2.
ClickAdd3.
ChooseHardDisk,andclickNext.
4.
ChooseCreateanewvirtualdisk,andclickNext.
5.
Choose60GBforthesizeandselectSpecifyadatastore.
ClickBrowse.
6.
Selecttheappropriatedatastore.
WealternateddatabasestoragebetweenthetwodatastoresavailableontheHPStorage.
ClickOK.
7.
ClickNext.
8.
ClickNext.
9.
ClickFinish.
10.
ClickOK.
ConfiguringadditionaldrivesinDiskManagement1.
PowerontheVM,andopentheconsole.
2.
ClickStart,AdministrativeTools,ComputerManagement.
3.
ClickDiskManagement4.
Rightclicktheuninitializeddisks(ifany),andchooseInitializeDisk.
5.
ChooseMBR.
6.
Right-clickthevolumeandchooseNewSimpleVolume.
ClickNext.
7.
KeepthedefaultdrivespaceandclickNext.
8.
KeepthedefaultdriveletterassignmentandclickNext.
9.
ChooseNTFS,64KBallocationunitsize,andcheckthePerformaquickformatcheckbox.
ClickNext.
10.
ClickFinish.
11.
Createfoldersnecessaryforthedatabaserestore.
Weused:\SQLData.
CreatingtheadditionalVMsonthehostserverAfterinstallingandconfiguringtheinitialVM,wecreatedtheadditionalVMsthroughautomatedcloningscripts.
CloningtheVMsWeusedashellscriptontheESXServertocopytheVirtualDisks,andclonetheVMs.
ThisshellscriptcopiedtheVMdefinitionandvirtualdisks,andregisteredthenewVMinESX,usingthevmware-cmdutility.
UsingtheseautomatedcloningscriptssavedtimeandletusconfirmthatweconfiguredallVMssimilarly.
ConfiguringtheadditionalVMsaftercloning1.
InvSphere,expandthehost,thenclicktheVM.
2.
Clicktheconsoletab.
3.
StarttheVMbyright-clickingtheVM,andchoosingPowerPowerOn.
4.
ClickStartControlPanelNetworkandInternetNetworkConnections,anddouble-clicktheLocalAreaConnection.
5.
SelectInternetProtocolVersion4(TCP/IPv4),andclickProperties.
6.
IntheInternetProtocolVersion4(TCP/IPv4)Propertiesscreen,selecttheUsethefollowingIPaddressradiobutton.
7.
EnteravalidstaticIPaddressforthisnewVM,subnetmask,anddefaultgateway.
8.
SelecttheUsethefollowingDNSserveraddressesradiobutton,andenteratleastonevalidDNSserver,iftheapplicationrequiresyoutodoso.
9.
ClickOK,andclickClosetoexit.
10.
ClickStartControlPanelSystem.
11.
ClickChangeSettingstochangethecomputername.
12.
ClicktheChangebutton13.
Typethenewcomputername14.
ClickOK,thenclickOKagain.
15.
ReboottheVMasprompted.
14PrincipledTechnologies,Inc.
:VirtualizedOLTPworkloadperformancecomparisonofend-to-endsolutions:DellPowerEdgeM610withDellEqualLogicstoragevs.
HPProLiantBL465cwithHPStorageWorksEVA4400storageCreatingthevirtualclientmachinesFortheDVDStorescripts,weusedanumberofclientvirtualmachinestosimulateanumberofusersputtingaloadontheserver.
Toensurethattheaccuracyofvirtualclientsiscomparabletophysicalclientsweperformedasimilartestonphysicalclientsaswell.
ForourclientVMs,weinstalledafreshcopyofESX3.
5update3onourclienthost;aDellPowerEdgeR900serverwithfour4IntelX74602.
66Ghzprocessors,eight73GB,15kSASdrivesand64GBRAM.
Wecreatedandconfiguredamasterclientaswedescribeabove,andalsoinstalledafreshcopyofWindowsServer2003R2x86w/SP2ontheinitialclientandinstalledWindowsUpdatesavailableasofFeb.
24,2009.
WecreatedafoldercalledC:\ClientSharetostoreworkloadscripts,andsharedthisfolderforaccessfromourcontrollermachine.
Weinstalledthe.
NET2.
0frameworkoneachclientVM,astheDVDStoretestexecutablerequiresthis.
Wecreatedaperformancecounterlogoneachclientmachinetotrackthenumberofordersperminute(OPM)eachvirtualdatabaseserverreturns.
WeusedtheWindowsServer2003versionofthesystempreparationtooltopreparetheVMforcloning,andthenusedthecloningshellscriptstocreatetheadditionalclients.
Wefollowedthisprocessforeachinstallation:1.
FollowthestepsintheearlierCreatingavirtualmachinesectionusingthefollowingVMspecifications:a.
Name:SQLClientb.
Virtualprocessors:2c.
Virtualmemory:4096MBd.
VirtualDiskSize:8GBe.
Virtualnetwork:ExternalNetwork2.
InstallMicrosoftWindowsServer2003R2Enterprisex86EditionServicePack2ontheVM.
3.
AssignacomputernameofClientxforthedatabaseclient,wherexistheclientnumber.
4.
Forthelicensingmode,usethedefaultsettingoffiveconcurrentconnections.
5.
Enterapasswordfortheadministratorlogon.
6.
SelectEasternTimeZone.
7.
UsetypicalsettingsfortheNetworkinstallation.
8.
TypeWorkgroupfortheworkgroup.
9.
InstallWindowsUpdates,.
NET2.
0framework,andDVDStoreclientexecutableDVDStoresetupDatagenerationoverviewWebuiltthedatabaseschemausingthescriptsintheDS2distributionpackage,thoughwemadeafewminormodifications.
TheDS2stresstoolprovidesoptionstogenerate10MB,1GB,or100GBdatasets.
Togetthetooltogeneratethe20GBofuserdataweusedinthistest,wehadtomakeafewstraightforwardchangestothesourcecodeandtotheDVDStoreapplication'sscripts.
Note:WecreatedourtestdataonaLinuxsystemtotakeadvantageofthelargerRANDMAX.
Editingtheds2_create_orders.
cmoduleThemoduleds2_create_orders.
cdefinesconstantsthatdefinethemaximumvaluesforthecustomerIDandtheproductID.
Theconstantsforthe20GBdatabasesizedidnotexist.
Weaddedtheconstantsforthissize.
Onthecommandlinefortheds2_create_orders.
cmodule,wespecifiedthesize.
TheavailableoptionswereS(small),M(medium),andL(large).
WeaddedthecaseWforthe20GBdatabase.
Intheswitchstatementthatsetsthevaluesforthevariablesmax_cust_idandmax_prod_id,weaddedcasesthatassignedthemthepropervaluesforthe20GBdatabasesize.
Werecompiledtheds2_create_orders.
cmoduleonLinux,followingtheinstructionsintheheadercomments.
Weusedthefollowingcommandline:gcc–ods2_create_ordersds2_create_orders.
c–lmEditingtheds2_create_cust.
cmoduleWehadtomakethesamechangestotheds2_create_cust.
cmodulethatwemadetotheds2_create_orders.
cmodule.
Onthecommandlinefortheds2_create_cust.
cmodule,wespecifiedthesize.
TheavailableoptionswereS(small),M(medium),andL(large).
WeaddedthecaseWforthe20GBdatabase.
Intheswitchstatement15PrincipledTechnologies,Inc.
:VirtualizedOLTPworkloadperformancecomparisonofend-to-endsolutions:DellPowerEdgeM610withDellEqualLogicstoragevs.
HPProLiantBL465cwithHPStorageWorksEVA4400storagethatsetsthevaluesforthevariablesmax_cust_idandmax_prod_id,weaddedcasesthatassignedthemthepropervaluesforthe20GBdatabasesize.
Werecompiledtheds2_create_cust.
cmoduleonLinux,followingtheinstructionsintheheadercomments.
Weusedthefollowingcommandline:gcc–ods2_create_custds2_create_cust.
c–lmGeneratingthedataforthe20GBdatabaseWeusedshellscriptstorunallfouroftheexecutablesthatgeneratethedata.
Thedistributiondidnotincludeshellscriptsforthe20GBsize.
Wewroteshellscriptsbasedontheds2_create_cust_large.
shandds2_create_orders_large.
shscripts.
Theds2_create_prodandds2_create_invexecutablesdidnotshipwithassociatedshellscripts,sowecreatedshellscriptsusingtheinstructionsinthereadmefiles.
Werantheshellscriptsinthefollowingordertogeneratethedataforthe20GBdatabase:1.
ds2_create_orders_20gb.
sh2.
ds2_create_inv_20gb.
sh3.
ds2_create_prod_20gb.
sh4.
ds2_create_cust_20gb.
shWewaiteduntiltheprocessesfinishedbeforewemovedontothenextstep.
CreatingthedatabaseWemodifiedthedatabasecreationSQLServerscriptsintheDVDStoredistributionpackagetobuildthedatabaseschema,whichincludesthefilestructure,tables,indices,storedprocedures,triggers,andsoon.
Webuiltamastercopyofthe20GBdatabaseversionforSQLServer2008,andthenusedthatmastercopytorestoreourtestdatabasetoeachtestserverVMbetweeneachtestrun.
WestoredthebackupfileontheVMC:driveforquickaccess.
Wefollowedthesestepstocreatethedatabase:1.
WecreatedthedatabaseandfilestructureusingdatabasecreationscriptsprovidedwithDS2.
Wemadesizemodificationsspecifictoour20GBdatabaseandtheappropriatechangestodriveletters.
2.
Wecreateddatabasetables,storedprocedures,andobjects.
3.
Wesetthedatabaserecoverymodeltobulk-loggedtopreventexcesslogging.
4.
Weloadedthedatathatthedatabasegenerated.
Fordataloading,weusedtheimportwizardinSQLServerManagementStudio.
Wherenecessary,weretainedoptionsfromtheoriginalscripts,suchasEnableIdentityInsert.
5.
Wecreatedindices,full-textcatalogs,primarykeys,andforeignkeysusingthedatabase-creationscripts.
6.
Weupdatedstatisticsoneachtableaccordingtodatabase-creationscripts,whichsample18percentofthetabledata.
7.
Wecreatedds2userSQLServerloginanduserfortestingusingthefollowingTransactSQL(TSQL)script.
USE[master]GOCREATELOGIN[ds2user]WITHPASSWORD=N'',DEFAULT_DATABASE=[master],DEFAULT_LANGUAGE=[us_english],CHECK_EXPIRATION=OFF,CHECK_POLICY=OFFGO8.
Wesetthedatabaserecoverymodelbacktofull.
Wemadethefollowingchangesinthebuildscripts:Becausewevariedthesizeofthedatasets,wesizedthefilesinourscriptstoreflectthedatabasesizeandthenumberoffilesperfilegroup.
Weallowedforapproximately40percentfreespaceinourdatabasefilestoensurethatfilegrowthactivitydidnotoccurduringthetesting.
16PrincipledTechnologies,Inc.
:VirtualizedOLTPworkloadperformancecomparisonofend-to-endsolutions:DellPowerEdgeM610withDellEqualLogicstoragevs.
HPProLiantBL465cwithHPStorageWorksEVA4400storageWefollowedMicrosoft'srecommendationofhaving0.
25to1fileperfilegrouppercore.
Weusedtwofilesperfilegrouponour2virtualprocessorVMs.
WedidnotusetheDBCCPINTABLEcommandfortheCATEGORIESandPRODUCTStables,bothbecauseMicrosoftrecommendsagainstthispracticeandbecausethecommandsdonothinginSQLServer2008.
WeaddedtheFORCESEEKhintintheBROWSE_BY_ACTORstoredprocedurebecauseininitialtestingwefoundthatSQLServer2008waschoosinganindexscaninsteadofthepreferredindexseek,addingunnecessaryoverhead.
WecreatedaSQLServerlogincalledds2userandmappedadatabaseusertothislogin.
Wemadeeachsuchuseramemberofthedb_ownerfixeddatabaserole.
UsingtheDVDStorescriptsasareference,wecreatedthefull-textcatalogandindexonthePRODUCTStablemanuallyinSQLServerManagementStudio.
Inourpre-testexperimentation,wefoundthatSQLServer2008wouldoccasionallychooseaninefficientqueryplanintheDVDStoreworkload.
Toflushtheplancacheduringthesecases,weusedtheDBCCFREEPROCACHEcommand.
Wethenperformedafullbackupofthedatabase.
ThisbackupallowedustorestoreeachserverVMtoapristinestaterelativelyquicklybetweentests.
Editingtheworkloadscript-ds2xdriver.
csmoduleTousethe20GBdatabasewecreatedearlier,wehadtochangethefollowingconstants:IntheroutineController(),wechangedthestringsizes.
WeaddedtheWoptionforthe20GBdatabasesize.
DS2usesthesizesstringtointerpretthedb_size_stroption.
IntheclassController,wechangedthearraysMAX_CUSTOMERandMAX_PRODUCT.
Toeach,weaddedvaluesspecifyingtheboundsforthecustomerandproductIDs.
TheController()routineusesthesearrays.
Weaddedacommandlineparameterforthedatabasename:—database_nameEditingtheworkloadscript-ds2sqlserverfns.
csmoduleWechangedtheconnectionstringtoincreasethenumberofavailableconnections,tonotusethedefaultadministrator("sa")account,andtoincludeaparameterforthedatabasename.
Weraisedtheavailableconnectionslimitfromthedefaultof100to200toallowroomforexperimentation.
Wecreatedauseraccountcalledds2Userandusedthataccount.
Theds2connectroutineintheds2sqlserverfns.
csmoduledefinessConnectionString.
Weusedthefollowingstring;thechangeswemadeappearinbold.
stringsConnectionString="UserID=ds2User;InitialCatalog="+dbname+";MaxPoolSize=200;ConnectionTimeout=120;DataSource="+Controller.
target;Recompilingtheds2sqlserverdriver.
exeexecutableWerecompiledtheds2xdriver.
csandds2sqlserverfns.
csmoduleonWindowsbyfollowingtheinstructionsintheheadercomments.
BecausetheDS2instructionswereforcompilingfromthecommandline,weusedthefollowingsteps:1.
Openacommandprompt.
2.
Usethecdcommandtochangetothedirectorycontainingoursources.
3.
RunthebatchfileC:\ProgramFiles\MicrosoftVisualStudio9.
0\Common7\Tools\vsvars32.
bat.
Thissetsuptheenvironmentvariablesforus.
4.
Executethefollowingcommand:csc/out:ds2sqlserverdriver.
exeds2xdriver.
csds2sqlserverfns.
cs/d:USE_WIN32_TIMER/d:GEN_PERF_CTRS17PrincipledTechnologies,Inc.
:VirtualizedOLTPworkloadperformancecomparisonofend-to-endsolutions:DellPowerEdgeM610withDellEqualLogicstoragevs.
HPProLiantBL465cwithHPStorageWorksEVA4400storageTestingprocedureToperformthetest,weusedaseriesofbatchfiles.
Westoredbatchfilesrespectivetoeachsystemonthatsystem,eitherundertheC:\ServerSharefolderortheC:\ClientSharefolder,andweusedthepsexec,plink,andwinscputilitiestocoordinatethetestproceduresamongsttheclientmachine,servermachine,andcontroller.
Weusesimplefilesharing,orsecureftptocopyfilesfrommachinetomachineasweneeded.
Thetestingprocedureconsistedofthefollowingsteps:1.
Executebatchfilesandshellscriptstocleanupprioroutputsonclientvirtualmachines,theserverphysicalmachine,andthecontroller.
2.
DropthedatabaseoneachserverVM.
3.
RestorethedatabaseoneachserverVM.
4.
Pausefor5minutestowaitforbackgroundtaskstocompletebeforeserverreboot.
5.
Rebootthephysicalmachines,andwaitforapingresponsefromthephysicalmachine,aswellasfromallVMsinvolvedintesting.
6.
Wait10additionalminutesforanybackgroundtaskstocomplete.
7.
Recordidlepowerfor2minutes.
8.
Startperformancecountersonclientvirtualmachines,andstartesxtopontheserverundertest.
9.
Starttheworkloadconnections.
10.
Starttheworkloadrampupperiod.
RuntheDBCCFREEPROCACHEcommandifnecessary(seetheCreatingthedatabasesection).
11.
Starttheworkload.
12.
Stoptheworkload.
13.
Copyalloutputfilestothecontroller.
PowermeasurementprocedureTorecordeachserver'spowerconsumptionduringeachtest,weusedanExtechInstruments(www.
extech.
com)380803PowerAnalyzer/Datalogger.
WeconnectedthepowercordfromtheserverundertesttothePowerAnalyzer'soutputloadpoweroutlet.
WethenpluggedthepowercordfromthePowerAnalyzer'sinputvoltageconnectionintoapoweroutlet.
Forthestoragearrays,whichhavemultiplepowercords,wepluggedallofthecordsforeacharrayintoapowerstripandthenpluggedthepowerstripintothePowerAnalyzer'soutputloadpoweroutlet.
WeusedthePowerAnalyzer'sDataAcquisitionSoftware(version2.
11)tocaptureallrecordings.
WeinstalledthesoftwareonaseparateIntelprocessor-basedPC,whichweconnectedtothePowerAnalyzerviaanRS-232cable.
Wecapturedpowerconsumptionatone-secondintervals.
Togaugetheidlepowerusage,werecordedthepowerusagefortwominuteswhileeachsystemwasrunningtheappropriatenumberofVMs,butotherwiseidle,meaningtheywerenotrunninganytestworkload.
Wethenrecordedthepowerusage(inwatts)foreachsystemduringthetestingatone-secondintervals.
Tocomputetheaveragepowerusage,weaveragedthepowerusageduringthetimethesystemwasproducingitspeakperformanceresults.
Becausewemeasuredthepoweroftheserverandstorageseparately,weaddedtheaveragepowerofbothtogethertogetthetotalpower.
Wecallthistimethepowermeasurementinterval.
SeeFigure6(idleandaveragepeakpower)fortheresultsofthesemeasurements.
18PrincipledTechnologies,Inc.
:VirtualizedOLTPworkloadperformancecomparisonofend-to-endsolutions:DellPowerEdgeM610withDellEqualLogicstoragevs.
HPProLiantBL465cwithHPStorageWorksEVA4400storageAppendixA–ServerconfigurationinformationThisappendixprovidesdetailedconfigurationinformationabouttheservers,whichwepresentinalphabeticalorder.
Figure9providesdetailedsystemconfigurationinformation.
Pleasenotethatbothsystemsarebladeservers.
VMwareBuild148592caveat:AllinformationinthisdisclosureregardingfuturedirectionsandintentaresubjecttochangeorwithdrawalwithoutnoticeandshouldnotbereliedoninmakingapurchasingdecisionofVMware'sproducts.
TheinformationinthisdisclosureisnotalegalobligationforVMwaretodeliveranymaterial,code,orfunctionality.
ThereleaseandtimingofVMware'sproductsremainsatVMware'ssolediscretion.
ServersDellPowerEdgeM610HPProLiantBL465cEnclosureDellPowerEdgeM1000eHPBladeSystemc7000GeneraldimensioninformationHeight(inches)17.
317.
5Width(inches)17.
617.
5Depth(inches)29.
732.
0Usizeinserverrack(U)1010PowersuppliesTotalnumber66Wattageofeach(W)2,3602,250CoolingfansTotalnumber910Dimensions(hxw)ofeach3.
1"x3.
5"2.
75"x2.
25"Voltage(V)1212Amps(A)7.
016.
5GeneralprocessorsetupNumberofprocessorpackages22Numberofcoresperprocessorpackage44Numberofhardwarethreadspercore21SystempowermanagementpolicyOScontrolHPDynamicPowerSavingsModeCPUVendorIntelAMDNameXeonE5530Opteron2384Stepping42SockettypeLGA1366SocketFCorefrequency(GHz)2.
42.
7L1cache32KB+32KB(percore)64KB+64KB(percore)L2cache1MB(4x256KB)2MB(4x512MB)L3cache1x8MB1x6MBPlatformVendorandmodelnumberDellPowerEdgeM610HPProLiantBL465cMotherboardmodelnumberPWB5N793447463-00119PrincipledTechnologies,Inc.
:VirtualizedOLTPworkloadperformancecomparisonofend-to-endsolutions:DellPowerEdgeM610withDellEqualLogicstoragevs.
HPProLiantBL465cwithHPStorageWorksEVA4400storageServersDellPowerEdgeM610HPProLiantBL465cMotherboardrevisionnumberX02A02BIOSnameandversionDell0.
2.
15HPBIOSA13BIOSsettingsVirtualizationenabledAMDVirtualizationenabledNo-ExecutePage-ProtectionenabledMemorymodulesTotalRAMinsystem(GB)7264Numberoftypesofmemorymodules21FirsttypeofmemorymodulesVendorandmodelnumberCrucialCT51272BB1339SamsungM393T1K66AZATypePC3-10600DDR3PC2-5300DDR2Speed(MHz)1,333667Speedinthesystemcurrentlyrunning@(MHz)1,066667Timing/latency(tCL-tRCD-iRP-tRASmin)9-9-9-245-5-5-15Size(GB)2464NumberofRAMmodules6x4GB8x8GBChiporganizationDouble-sidedDouble-sidedSecondtypeofmemorymodulesVendorandmodelnumberSamsungM393B1K70BH1N/ATypePC3-8500DDR3N/ASpeed(MHz)1,066N/ASpeedinthesystemcurrentlyrunning@(MHz)1,066N/ATiming/Latency(tCL-tRCD-iRP-tRASmin)8-8-8-24N/ASize(GB)48N/ANumberofRAMmodules6x8GBN/AChiporganizationDouble-sidedN/AHarddiskVendorandmodelnumberSeagateST973451SSHPDH072BAAKNNumberofdisksinsystem22Size(GB)7372Buffersize(MB)1616RPM15,00015,000TypeSASSASOperatingsystemNameVMwareESXVMwareESXBuildnumber148592148592Filesystemext3(server)vmfs3(virtualmachines)ext3(server)vmfs3(virtualmachines)LanguageEnglishEnglish20PrincipledTechnologies,Inc.
:VirtualizedOLTPworkloadperformancecomparisonofend-to-endsolutions:DellPowerEdgeM610withDellEqualLogicstoragevs.
HPProLiantBL465cwithHPStorageWorksEVA4400storageServersDellPowerEdgeM610HPProLiantBL465cNetwork/storagesubsystemVendorandmodelnumberBroadcomNetXtremeII5709Dual-PortEthernetBroadcomNetXtremeII5706EthernetTypeIntegratedIntegratedBladeswitchmodulesTwoCiscoWS-CBS3130X-SCatalystBladeSwitchModulesTwoHP1:10EthernetBladeSwitchModulesBladepass-throughmodulesTwoGigabitEthernetPass-ThroughModulesTwoHP4GbFibreChannelPass-ThroughModulesUSBportsNumber2ontheblade,4onthechassis(2ontheiKVM)2withattachmentTypeUSB2.
0USB2.
0Figure9:Detailedsystemconfigurationinformationforthetwotestservers.
21PrincipledTechnologies,Inc.
:VirtualizedOLTPworkloadperformancecomparisonofend-to-endsolutions:DellPowerEdgeM610withDellEqualLogicstoragevs.
HPProLiantBL465cwithHPStorageWorksEVA4400storageAppendixB–StoragearrayconfigurationinformationThisappendixprovidesdetailedconfigurationinformationaboutthearraysystems,whichwepresentinalphabeticalorder.
Figure10presentsdetailedconfigurationinformationforthestoragearrays.
DellEqualLogiciSCSISANHPStorageWorksFibreChannelSANArraysThreeDellEqualLogicPS5000XVarraysandoneDellEqualLogicPS6000ArrayHPStorageWorksEVA4400EnterpriseVirtualArraywithfivefulldiskshelvesDisks60active15,000RPMSASdiskstotalforthefourshelves60active15,000RPMFCdiskstotalforthefiveshelvesActivestoragecache5GB(1GBperPS5000XVand2GBperPS6000)4GBNumberofactivestoragecontrollers4(1perarray)2Numberofpassivestoragecontrollers4(1perarray)0Numberofactivestorageports10(3perPS5000XVarray;4perPS6000)4Firmwarerevisionv4.
1.
1XCSv9.
00.
10Switchtype/model/firmwarerevisionTwoDellPowerConnect6248v2.
2.
0.
3TwoBrocade200EFabricOSv6.
0.
0bDiskvendorandmodelnumber32xSeagateST3146855SS16xSeagateST3450856SS16xMaxtorATLAS15K2_147SAS36xHPBDF146DA47A24xHPBF146DA47ADisksize146GBand450GB146GBDiskbuffersize(MB)1616DiskRPM15,00015,000DisktypeSASFibreChannelFigure10:Detailedconfigurationinformationforthestoragearrays.
22PrincipledTechnologies,Inc.
:VirtualizedOLTPworkloadperformancecomparisonofend-to-endsolutions:DellPowerEdgeM610withDellEqualLogicstoragevs.
HPProLiantBL465cwithHPStorageWorksEVA4400storageAboutPrincipledTechnologiesWeprovideindustry-leadingtechnologyassessmentandfact-basedmarketingservices.
Webringtoeveryassignmentextensiveexperiencewithandexpertiseinallaspectsoftechnologytestingandanalysis,fromresearchingnewtechnologies,todevelopingnewmethodologies,totestingwithexistingandnewtools.
Whentheassessmentiscomplete,weknowhowtopresenttheresultstoabroadrangeoftargetaudiences.
Weprovideourclientswiththematerialstheyneed,frommarket-focuseddatatouseintheirowncollateraltocustomsalesaids,suchastestreports,performanceassessments,andwhitepapers.
Everydocumentreflectstheresultsofourtrustedindependentanalysis.
Weprovidecustomizedservicesthatfocusonourclients'individualrequirements.
Whetherthetechnologyinvolveshardware,software,Websites,orservices,weoffertheexperience,expertise,andtoolstohelpyouassesshowitwillfareagainstitscompetition,itsperformance,whetherit'sreadytogotomarket,anditsqualityandreliability.
Ourfounders,MarkL.
VanNameandBillCatchings,haveworkedtogetherintechnologyassessmentforover20years.
Asjournalists,theypublishedoverathousandarticlesonawidearrayoftechnologysubjects.
TheycreatedandledtheZiff-DavisBenchmarkOperation,whichdevelopedsuchindustry-standardbenchmarksasZiffDavisMedia'sWinstoneandWebBench.
TheyfoundedandledeTestingLabs,andaftertheacquisitionofthatcompanybyLionbridgeTechnologiesweretheheadandCTOofVeriTest.
DisclaimerofWarranties;LimitationofLiability:PRINCIPLEDTECHNOLOGIES,INC.
HASMADEREASONABLEEFFORTSTOENSURETHEACCURACYANDVALIDITYOFITSTESTING,HOWEVER,PRINCIPLEDTECHNOLOGIES,INC.
SPECIFICALLYDISCLAIMSANYWARRANTY,EXPRESSEDORIMPLIED,RELATINGTOTHETESTRESULTSANDANALYSIS,THEIRACCURACY,COMPLETENESSORQUALITY,INCLUDINGANYIMPLIEDWARRANTYOFFITNESSFORANYPARTICULARPURPOSE.
ALLPERSONSORENTITIESRELYINGONTHERESULTSOFANYTESTINGDOSOATTHEIROWNRISK,ANDAGREETHATPRINCIPLEDTECHNOLOGIES,INC.
,ITSEMPLOYEESANDITSSUBCONTRACTORSSHALLHAVENOLIABILITYWHATSOEVERFROMANYCLAIMOFLOSSORDAMAGEONACCOUNTOFANYALLEGEDERRORORDEFECTINANYTESTINGPROCEDUREORRESULT.
INNOEVENTSHALLPRINCIPLEDTECHNOLOGIES,INC.
BELIABLEFORINDIRECT,SPECIAL,INCIDENTAL,ORCONSEQUENTIALDAMAGESINCONNECTIONWITHITSTESTING,EVENIFADVISEDOFTHEPOSSIBILITYOFSUCHDAMAGES.
INNOEVENTSHALLPRINCIPLEDTECHNOLOGIES,INC.
'SLIABILITY,INCLUDINGFORDIRECTDAMAGES,EXCEEDTHEAMOUNTSPAIDINCONNECTIONWITHPRINCIPLEDTECHNOLOGIES,INC.
'STESTING.
CUSTOMER'SSOLEANDEXCLUSIVEREMEDIESAREASSETFORTHHEREIN.
PrincipledTechnologies,Inc.
1007SlaterRd.
,Suite250Durham,NC27703www.
principledtechnologies.
cominfo@principledtechnologies.
comPrincipledTechnologiesisaregisteredtrademarkofPrincipledTechnologies,Inc.
Allotherproductnamesarethetrademarksoftheirrespectiveowners