Dell PowerEdge 11G四路服务器OLTP负载整合指南-英文

ConsolidatingOLTPWorkloadsonDell™PowerEdge™11G4SocketServersADellTechnicalWhitePaperAuthorsBalamuruganBRaviRamappaConsolidatingOLTPWorkloadsonDell™PowerEdge™11G4socketserversPageiiTHISWHITEPAPERISFORINFORMATIONALPURPOSESONLY,ANDMAYCONTAINTYPOGRAPHICALERRORSANDTECHNICALINACCURACIES.THECONTENTISPROVIDEDASIS,WITHOUTEXPRESSORIMPLIEDWARRANTIESOFANYKIND.©2010DellInc.Allrightsreserved.ReproductionofthismaterialinanymannerwhatsoeverwithouttheexpresswrittenpermissionofDellInc.isstrictlyforbidden.Formoreinformation,contactDell.Dell,theDELLlogo,andtheDELLbadge,PowerConnect,andPowerVaultaretrademarksofDellInc.SymantecandtheSYMANTEClogoaretrademarksorregisteredtrademarksofSymantecCorporationoritsaffiliatesintheUSandothercountries.Microsoft,Windows,WindowsServer,andActiveDirectoryareeithertrademarksorregisteredtrademarksofMicrosoftCorporationintheUnitedStatesand/orothercountries.EMCistheregisteredtrademarkofEMCCorporation.Intel,andXeonareeithertrademarksorregisteredtrademarksofIntelCorporation.April2010ConsolidatingOLTPWorkloadsonDell™PowerEdge™11G4socketserversPageiiiConsolidatingOLTPWorkloadsonDell™PowerEdge™11G4socketserversPage1ContentsEXECUTIVESUMMARY...................................................................................................2INTRODUCTION..........................................................................................................3SYSTEMARCHITHECTURE..............................................................................................4TESTCONFIGURATION.................................................................................................5TESTMETHODOLOGY...................................................................................................5CONSOLIDATIONFACTOR............................................................................................10SUMMARY...............................................................................................................11TablesTable1:TestConfiguration...............................................................................5FiguresFigure1:SystemArchitecture............................................................................4Figure2:BaseConfiguration—TPSComparisonBetweenLegacyProductionandR810TestEnvironment...........................................................................................7Figure3:BaseConfiguration-AQRTComparisonBetweenLegacyProductionandR810TestEnvironment...........................................................................................7Figure4:BaseConfiguration-CPUTimeComparisonBetweenLegacyProductionandR810TestEnvironment.....................................................................................8Figure5:AtLegacySaturatedUserLoad-TPSComparisonBetweenLegacyProductionandR810TestEnvironment...............................................................................9Figure6:AtLegacySaturatedUserLoad-AQRTComparisonBetweenLegacyProductionandR810TestEnvironment...............................................................................9Figure7:AtLegacySaturatedUserLoad-CPUTimeComparisonBetweenLegacyProductionandR810TestEnvironment........................................................................10ConsolidatingOLTPWorkloadsonDell™PowerEdge™11G4socketserversPage2EXECUTIVESUMMARYTheDell™enterpriseportfolioisevolvingtoincorporatebetter‐performing,moreenergy‐efficient,andmorehighly‐availableproducts.WiththeintroductionofDell’slatestserverproductline,customershaveanopportunitytoimprovetheirtotalcostofownershipbyconsolidatingdistributedlegacyenvironments.ThisisthethirdwhitepaperinaseriesthatdiscussesserverconsolidationonDell11Gproductline.EarlierwhitepapersthatdiscusstheDSS/OLTPworkloadconsolidationonDellPowerEdge™11G2socketserversinclude:ConsolidatingDSSWorkloadsonDell™PowerEdge™11GServersUsingOracle®11gDatabaseReplay=ec&l=en&s=genConsolidatingOLTPWorkloadsonDell™PowerEdge™11GServers=us&cs=555&l=en&s=bizThiswhitepaperfocusesonOnlineTransactionProcessing(OLTP)workloadsandconsolidationonDellPowerEdge™11G4/2socketservers.DellstrivestosimplifyITinfrastructurebyprovidingmethodstoconsolidatelegacyproductionenvironmentsandreducedatacentercomplexity.Thetoolsandproceduresdescribedinthiswhitepapercanhelpadministratorstest,compare,validate,andimplementthelatesthardwareanddatabasesolutionbundles.DellestablishedtheseproceduresandguidelinesbasedonlabexperimentsanddatabaseworkloadsimulationsperformedbytheDellDatabaseSolutionsEngineeringteam.Usingthetoolsandproceduresdescribedinthisdocument,customersmaynotonlyselecttheappropriatedatabasesolutionhardwareandsoftwarestack,butalsooptimizethesolutions’totalcostofownershipaccordingtothedatabaseworkloadstheychoosetorun.Theintendedaudienceofthiswhitepaperincludesdatabaseadministrators,ITmanagers,andsystemconsultants.ConsolidatingOLTPWorkloadsonDell™PowerEdge™11G4sock