北京-微软课堂-如何在企业应用中管理和优化SQLServe

微软企业级计算实现与企业应用集成（EAI)概述MicrosoftEnterpriseComputingSolutionOverview余学俊微软中国有限公司企业客户支持部Agenda企业级计算：高可用性,高可扩展性热点：实现企业应用集成（EAI)企业应用集成（EAI)的需求成功的EAI引入的阶段与策略打造成功的企业应用集成结论一、企业级计算：实现高可扩展性与高可用性两种互为补充计算扩展的方法HardwareScaleviabiggerindividualserversSoftwareScaleviaclustersofservers+++…HardwareScale•Hardwareapproach•Expensivehardware•Costincreasesw/scale•Singlepointoffailure•Serverreliability•Programonesystem•ManageonesystemSoftwareScale•Softwareapproach•Highvolumehardware•Costlinearw/scale•Nosinglepointoffailure•Application可用性•Programmultiplesystems•Managemultiplesystems基于Intel的主机(mainframe)计算WindowsDatacenterUnisysES7000withCellularMultiprocessing(CMP)Upto32ProcessorsPartitionable64GBofmainmemoryCanbeshared96PCIchannelsCrossbar(mainframe-like)technologyThirdlevelcachememoryFullyredundantsubsystemsMultipleOSsupport.NET企业服务器FirewallandcacheWebBusinessLogicStorageInternetSecurity&AccelerationServerSQLServer2000可扩展性的测量IndustryBenchmarksApplicationBenchmarksCustomerDeploymentsIndustryBenchmark:TPC-CResultsasof1-8-02.Source:(logo)xSeries370c/s2345SunSolaris8SymfoWAREServerFujitsuPRIMEPOWER2000c/s222,772$43.42$9.7M678910CompaqTru64UNIXOracle9i230,533709,220$14.96$10.6M$44.62CompaqAlphaServerGS320$10.3MRankOperatingSystemDatabaseHardwareSystemModeltpmCPrice/tpmCTotalPrice567,882$14.04$8.0MMicrosoftWindows2000SQLServer2000CompaqProLiantDL760-900-192PMicrosoftWindows2000SQLServer2000IBMe(logo)xSeries370c/s363,130$21.80$8.0MMicrosoftWindows2000SQLServer2000410,770$13.02CompaqProLiantDK760-900-128P$5.3M455,818$28.58$12.0MSunSolarisFujitsuPRIMEPOWER2000c/sSymfoWAREServerMicrosoftWindows2000SQLServer2000IBMe(logo)xSeries370c/s440,880$25.03$11.0M389,434$21.24$8.3MHewlett-PackardHP9000SuperdomeEnterpriseServerOracle9iIndustryBenchmark:TPC-CTopTPC-CNon-ClusteredBenchmarkPerformanceOSDatabaseOEMAvailable$/perftpmCSolaris8SymfoWAREFujitsu2/28/2002$28.58455,818HPUX11iOracle9iHP5/15/02$21.24389,434Tru64UNIXV5.1Orcacle9i.9.0.1Compaq7/30/2001$44.62230,533Solaris8SymfoWAREFujitsu/ICL6/30/2001$43.42222,772AIX4.3.3Oracle8EEIBM4/13/2001$34.18220,807AIX4.3.3Oracle8iEEBull5/28/2001$34.67220,807HPUX11.i64-bitOracle8EEHP5/1/2001$43.25197,024WindowsDatacenterServerLimitedEditionSQLServer2000Ent.Ed.Unisys3/10/2002$21.33165,219IBMOS/400V4R5IBMDB2IBM12/15/2000$51.58163,776Tru64UNIXV5.1Oracle8iEECompaq2/2/2001$52.88155,179IBMOS/400V4R5IBMDB2IBM9/15/2000$44.52152,346WindowsDatacenterServerLimitedEditionSQLServer2000Ent.Ed.Unisys3/10/2002$23.84141,138Resultsasof1-8-02.Source::可扩展性LargeeBusinesseshandlehugeworkloadsonIntel®serverswithWindows2000对可用性讨论People&ProcessHighlySkilledpeopleOperationalexcellenceTechnologyMinimizeUnplanneddowntimeRedundantSystemsServicesHigh&Continuous可用性ServicesTechnologyIsNotEnoughCausesofDowntimeApplicationFailure40%OperatorError40%Other20%•App/SolsnotTested•ChangeManagement•OverloadedCapacity•ProblemDetectionnotdefined•ForgotSomething•LackofProcedures•BackupErrors/Security•Hardware/Platform•Network•PowerandDisasterGartnerGroupOperationsPeople&ProcessAreMOREImportantPeople&Process=OperationalExcellenceBuildITRight-MSFEnterpriseArchitectureInfrastructureDeploymentApplicationDevelopmentConsulting(e.g.W2KArchitecture&Deploy)TrainingManagementContent(e.g.RiskManagementwhitepaper)DetailedContent(e.g.WindowsOperationsGuides)ProfessionalServices(e.g.Premier)Training*BasedonITInfrastructureLibrary(ITIL)MOF流程模型CapacityManagement可用性ManagementFinancialManagementWorkforceManagementServiceContinuityManagementServiceLevelManagementServiceDeskIncidentManagementProblemManagementChangeManagementConfigurationManagementReleaseManagementServiceMonitor&ControlSecurityAdministrationNetworkAdministrationSystemAdministrationJobSchedulingStorageManagementPrint/OutputManagementDirectoryServicesAdministrationReleaseApprovedreviewSLAReviewOperationsReviewChangingOperatingSupportingOptimizingReleaseReadinessReviewMOF建立途径公有领域服务架构Microsoft服务提供ITIL“业界最佳实践技术细节MOF核心合作伙伴服务提供操作指南，白皮书服务方法架构化的流程顾问参与微软产品与技术主动服务反应服务计划准备设计构建实施维护掌握技术动向团队成员如何分工合作？框架设计是否合理？关键技术选择是否合理？系统设置是否正确？有何风险？如何规避？系统性能系统是否健壮？每日流程管理如何跟踪产品信息？构建和维护系统时遇到问题严重问题在现有产品中增加新功能Beta产品试用紧急情况高级培训研讨ITIL/MSF组队模型系统框架设计咨询技术审核服务安全与可靠性审核风险管理压力测试与性能调试服务备份/恢复策略流程管理企业客户网上服务台MSDNTechNet事件支持热线特定补丁Hot-fix设计改变请求DCRBeta应用和开发支持7X24紧急技术支持客户需求服务内容微软企业支持服务ITIL/MSF组队模型系统框架设计咨询技术审核服务安全与可靠性审核风险管理压力测试与性能调试服务备份/恢复策略流程管理微软运作框架MicrosoftOperationFramework可用性tra