SQL Server Consolidation at Micro

《SQL Server Consolidation at Micro》由会员上传分享，免费在线阅读，更多相关内容在行业资料-天天文库。

1、SQLServerConsolidationatMicrosoftPublished:March2009MicrosoftIToperatesthousandsofSQL Serverinstances.Mostresideondedicatedphysicalhardwareandaretypicallyunderutilized.Microsoft ITwantedtoreduceexpensesbyprovidingautilityforSQL Serverinstances.SolutionOverviewBusinessChallengeSolutionRe

2、sults/BenefitsMicrosoft ITproducedtheSQL UtilitytoimproveSQL Servermanageabilitythroughhostconsolidation,virtualization,andstandardization.ReducedoperatingandcapitalexpensesImprovedbusinesscontinuity,scalability,andavailabilityImprovedenvironmentalsustainabilityStandardizedbuildforSQL S

3、erverinstancesProductsandTechnologyWindowsServer2008SQLServer2005SQLServer2008Hyper-VSQLUtilityComputeUtilityStorageUtilityPositiveEffectsofConsolidationUtilitiesinMicrosoftITIdentificationofUnderutilizedServersServertemperatureMeanCPUpercentageMaximumCPUpercentagePermafrost≤1≤5Cold≤5≤2

4、0Warm≤20≤50Hot>20>50ConsolidationApproachesThreeprimaryapproachesHostconsolidationInstanceconsolidationDatabaseconsolidationMicrosoftITusedhostconsolidationtoreduceriskssuchasSLAconflictsandsharedresourcesVirtualizationPlatform:WSRMvs.Hyper-VApproachtoresourcemanagementisanimportantdeci

5、sionMicrosoftITevaluatedWSRMandHyper-VandultimatelychoseHyper-VMicrosoftITusesHyper-VtomanageprocessorandmemoryuseonhostandguestpartitionsWindowsSystemResourceManagerHyper-VImplementationofSQLUtilityMicrosoftITisimplementingtheSQLUtilityinphasesSQLServerhostsscheduledforEOLreplacementar

6、ethefirstcandidatesforconsolidationSQLUtilityserviceisconsumptionbasedSelectedimplementationprovidesalways-onhighavailabilitywithflexiblebusinesscontinuityanddisasterrecoverySQLUtilityArchitectureServiceOfferingsOfferingRAM(SQL Server+operatingsystem)ProcessorsVirtualinstancesmall2or41V

7、irtualinstancemedium4or82Virtualinstancelarge164ServiceOfferings:DeterminingtheConfigurationServiceOfferings:Hyper-VandtheSDLCIdentificationofCandidatesforMigrationMicrosoftITusesseveralcriteriatoqualifycandidateSQL ServerinstancesformigrationRightSizingdataandcapacitymanagemen