北京微軟課堂如何在企業(yè)應(yīng)用中管理和優(yōu)化SQLServe

微軟企業(yè)級計(jì)算實(shí)現(xiàn)與企業(yè)應(yīng)用集成（EAI)概述

MicrosoftEnterpriseComputingSolutionOverview余學(xué)俊

微軟中國有限公司企業(yè)客戶支持部Agenda企業(yè)級計(jì)算：高可用性,高可擴(kuò)展性熱點(diǎn)：實(shí)現(xiàn)企業(yè)應(yīng)用集成（EAI)

企業(yè)應(yīng)用集成（EAI)的需求成功的EAI引入的階段與策略打造成功的企業(yè)應(yīng)用集成結(jié)論一、企業(yè)級計(jì)算：實(shí)現(xiàn)高可擴(kuò)展性與高可用性

兩種互為補(bǔ)充計(jì)算擴(kuò)展的方法HardwareScaleviabiggerindividualserversSoftwareScaleviaclustersofservers+++…HardwareScaleHardwareapproachExpensivehardwareCostincreasesw/scaleSinglepointoffailureServerreliabilityProgramonesystemManageonesystemSoftwareScaleSoftwareapproachHighvolumehardwareCostlinearw/scaleNosinglepointoffailureApplication可用性ProgrammultiplesystemsManagemultiplesystems基于Intel的主機(jī)(mainframe)計(jì)算WindowsDatacenterUnisysES7000withCellularMultiprocessing(CMP)Upto32ProcessorsPartitionable64GBofmainmemoryCanbeshared96PCIchannelsCrossbar(mainframe-like)technologyThirdlevelcachememoryFullyredundantsubsystemsMultipleOSsupport.NET企業(yè)服務(wù)器

FirewallandcacheWebBusinessLogicStorageInternetSecurity&AccelerationServerSQLServer2000可擴(kuò)展性的測量IndustryBenchmarksApplicationBenchmarksCustomerDeploymentsIndustryBenchmark:TPC-CSQLServer2000MicrosoftWindows2000CompaqProLiantDL760-900-256P688,220$22.58$15.5M1MicrosoftWindows2000SQLServer2000IBMe(logo)xSeries370c/s2345SunSolaris8SymfoWAREServerFujitsuPRIMEPOWER2000c/s222,772$43.42$9.7M678910CompaqTru64UNIX Oracle9i

230,533709,220$14.96$10.6M

$44.62CompaqAlphaServerGS320$10.3MRankOperatingSystemDatabaseHardware

SystemModeltpmCPrice/tpmCTotal

Price567,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/sSymfoWAREServer MicrosoftWindows2000SQLServer2000IBMe(logo)xSeries370c/s440,880$25.03$11.0M389,434$21.24$8.3MHewlett-PackardHP9000SuperdomeEnterpriseServerOracle9i IndustryBenchmark: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,138ApplicationBenchmarksProductWindows/SQLServerWinResultsRankPeopleSoft

CRM30,000concurrentusers#1PeopleSoft

eBillPayment191,694paymentsperhour#1Onyx32,000concurrentusers#1Pivotal

eRelationship20,000concurrentusers#1SAPRetail3.165millionlineitemsperhour#1GreatPlains2,400concurrentusers#1SAP-SDThreeTier24,000concurrentusers#2NASDAQhandles20Mhits/dayandperforms2Mtransactions/day可擴(kuò)擴(kuò)展展性性LargeeBusinesseshandlehugeworkloadsonIntel?serverswithWindows2000對可可用用性性討討論論P(yáng)eople&ProcessHighlySkilledpeopleOperationalexcellenceTechnologyMinimizeUnplanneddowntimeRedundantSystemsServicesHigh&Continuous可用用性性ServicesTechnologyIsNotEnoughCausesofDowntimeApplicationFailure40%OperatorError40%Other20%App/SolsnotTestedChangeManagementOverloadedCapacityProblemDetectionnotdefinedForgotSomethingLackofProceduresBackupErrors/SecurityHardware/PlatformNetworkPowerandDisasterGartnerGroupOperationsPeople&ProcessAreMOREImportantPeople&Process=OperationalExcellenceRunITRight-MOFManagementContent(e.g.RiskManagementwhitepaper)DetailedContent(e.g.WindowsOperationsGuides)ProfessionalServices(e.g.Premier)Training/mof*BasedonITInfrastructureLibrary(ITIL)MOF流程程模模型型CapacityManagement可用性ManagementFinancialManagementWorkforceManagementServiceContinuityManagementServiceLevelManagementServiceDeskIncidentManagementProblemManagementChangeManagementConfigurationManagementReleaseManagementServiceMonitor&ControlSecurityAdministrationNetworkAdministrationSystemAdministrationJobSchedulingStorageManagementPrint/OutputManagementDirectoryServicesAdministrationReleaseApprovedreviewSLAReviewOperationsReviewChangingOperatingSupportingOptimizingReleaseReadinessReviewMOF建立途徑培訓(xùn)與課程公有領(lǐng)域服務(wù)架構(gòu)Microsoft服務(wù)提供ITIL“業(yè)界最佳實(shí)踐踐"技術(shù)細(xì)節(jié)MOF核心合作伙伴服務(wù)提供操作指南，白白皮書服務(wù)方法架構(gòu)化的流程程顧問參與微軟產(chǎn)品與技技術(shù)主動(dòng)服務(wù)反應(yīng)服務(wù)計(jì)劃準(zhǔn)備設(shè)計(jì)構(gòu)建實(shí)施維護(hù)掌握技術(shù)動(dòng)向向團(tuán)隊(duì)成員如何何分工合作？？框架設(shè)計(jì)是否否合理？關(guān)鍵技術(shù)選擇擇是否合理？？系統(tǒng)設(shè)置是否否正確？有何風(fēng)險(xiǎn)？如如何規(guī)避？系統(tǒng)性能系統(tǒng)是否健壯壯？每日流程管理理如何跟蹤產(chǎn)品品信息？構(gòu)建和維護(hù)系系統(tǒng)時(shí)遇到問問題嚴(yán)重問題在現(xiàn)有產(chǎn)品中中增加新功能能Beta產(chǎn)品試用緊緊急情況高級培訓(xùn)研討討ITIL/MSF組隊(duì)模型系統(tǒng)框架設(shè)計(jì)計(jì)咨詢技術(shù)審核服務(wù)務(wù)安全與可靠性性審核風(fēng)險(xiǎn)管理壓力測試與性性能調(diào)試服務(wù)務(wù)備份/恢復(fù)策略流程管理企業(yè)客戶網(wǎng)上上服務(wù)臺(tái)MSDNTechNet事件支持熱線線特定補(bǔ)丁Hot-fix設(shè)計(jì)改變請求求DCRBeta應(yīng)用和開發(fā)支支持7X24緊急技術(shù)支持持客戶需求服務(wù)內(nèi)容微軟企業(yè)支持持服務(wù)ITIL/MSF組隊(duì)模型系統(tǒng)框架設(shè)計(jì)計(jì)咨詢技術(shù)審核服務(wù)務(wù)安全與可靠性性審核風(fēng)險(xiǎn)管理壓力測試與性性能調(diào)試服務(wù)務(wù)備份/恢復(fù)策略流程管理微軟運(yùn)作框架架MicrosoftOperationFramework可用性transacts$100M’’sadayat99.999%availabilityonWindows2000Largee-Businessesget99.9%+availability

onIntel?serverswithWindows2000achieves99.999%availability

onWindows2000performs2Mtransactionsadayat99.97%availabilityonWindows2000has99.98%availabilityonWindows2000二、熱點(diǎn)：實(shí)實(shí)現(xiàn)企業(yè)應(yīng)用用集成（EAI)企業(yè)應(yīng)用集成成的需求異構(gòu)平臺(tái)(TD/AS400/Windows)專有系統(tǒng)(交易、結(jié)算、、監(jiān)察系統(tǒng))已有應(yīng)用軟件(公司、會(huì)員管管理)投資者證監(jiān)會(huì)上市公司會(huì)員新聞媒體REQUIREMENTSConfigurableacrossapplicationsLooselycoupledSupportsanincrementalapproachInternet/VirtualPrivateNetworkB2BIntegrationA2AStandardsbasedintegrationBusinessprocessorientedScaleable,available,secure,manageableB2C點(diǎn)對點(diǎn)的資料料交換沒有BusinessIntelligent的機(jī)制制Businessrule大都都寫死(hard-code)在程序序中成功的EAI導(dǎo)入階階段與策略點(diǎn)對點(diǎn)(point-topoint)的資料整合或同步LooselycouplesystemMessagesorientedmiddlewaretools.1.點(diǎn)對點(diǎn)整合以Hub或星狀的整合架構(gòu)Middleware由Message-brokerApplicationServerMiddleware的角色：資料格式轉(zhuǎn)換流程處理交易的完整性2.架構(gòu)整合具有Level2的EAI基礎(chǔ)架構(gòu)系統(tǒng)之間的信息由分享提升成可以被管理需要Processautomationmodelingtools的middlewareMiddleware的角色：工作流程設(shè)計(jì)工具工作流程自動(dòng)化3.流程整合善用前3層之所有的EAI基礎(chǔ)架構(gòu)符合標(biāo)準(zhǔn)的網(wǎng)絡(luò)架構(gòu),即Internet采用標(biāo)準(zhǔn)的資料交換格式–XMLMiddleware的角色：安全的交易智慧型代理程序資料格式對映整合至B2B/B2C/B2E4.內(nèi)外整合Source:EAIJourney透過Middleware來達(dá)達(dá)到標(biāo)準(zhǔn)化的的交換過程。。Businessrule及核心心資料由Middleware集中中控管及交換換企業(yè)的業(yè)務(wù)流流程與外部的的客戶及交易易伙伴緊密結(jié)結(jié)合。EAI的最最佳模式。應(yīng)用程序之間間的交換完全全與工作流程程結(jié)合。自動(dòng)的工作流流程。EAI的整合架構(gòu)#1Point-to-PointMessagingComponent

BridgingDatabase

ReplicationBatchData

Export/Import業(yè)務(wù)流程及資料能見度低EAI整合為靜態(tài)整合各個(gè)應(yīng)用軟件各自為政資料及流程無法集中管理ERPSystemsClient-ServerSystemsIn-houseLOBApplicationsLegacyApplicationsE-CommerceApplicationsEAI的整合架構(gòu)#2+HubSpoke集中式的MessageRouting及ProcessingHubBusinessProcess

Orchestration以Business

Process

為導(dǎo)向的整合可動(dòng)態(tài)變更

系統(tǒng)設(shè)定維持系統(tǒng)間獨(dú)立性保留應(yīng)用程序彼此之間仍是獨(dú)立能有效提供審核及追蹤能力ERPSystemsClient-ServerSystemsIn-houseLOBApplicationsLegacyApplicationsE-CommerceApplicationsBizTalk

Messaging

BizTalk

Orchestration

XML打造成功的企企業(yè)信息整合合(EAI)建設(shè)EAI的的成功關(guān)鍵鍵業(yè)務(wù)編排建模模BusinessOrchestrationModeling動(dòng)態(tài)改變及布布署業(yè)務(wù)流程程Internalwork-flowintegration數(shù)據(jù)整合DataIntegrationEAI跨系統(tǒng)之間資資料格式轉(zhuǎn)換換及交換異構(gòu)平臺(tái)及資資料的整合與已有ERP及Legacy系統(tǒng)整合EAI資料審核及監(jiān)監(jiān)控你知道領(lǐng)導(dǎo)決決定要改變些些許的業(yè)務(wù)流流程嗎？我已經(jīng)制訂好好新的流程，，該您去修改應(yīng)應(yīng)用程序來對對映新的BusinessProcess了。別開玩笑了??！你知道改變業(yè)業(yè)務(wù)流程要修修改多少程序序嗎？我無法法在這么短的的間時(shí)內(nèi)完成成。`如果新流程被被確定時(shí)，就就能一同改變變相關(guān)應(yīng)用程程序的接軌，，那該多好啊??！ProcessIntegration的的難題當(dāng)程序開發(fā)人人員碰到業(yè)務(wù)務(wù)流程制定人人員動(dòng)態(tài)業(yè)務(wù)流程改變，需要一個(gè)可以同時(shí)讓Businessflow及

developer一同參與的

BusinessProcessModelingTools還有，領(lǐng)導(dǎo)說說他下個(gè)禮拜拜就要啟用新新流程，你有有一周的時(shí)間間可以努力。。BusinessProcessModelingBizTalkApplicationDesignerStyleMSMQPORequestScriptImplementationSend

ApprovalSend

DenialReceivePurchase

RequestDecisionGet

Purchase

Order

TotalBusinessModelActionSequenceBindingDataIn

DataOutPurchaseRequestPortApprovalRequestMessageEAI跨系統(tǒng)之間資資料格式轉(zhuǎn)換換及交換的難難題從程序觀點(diǎn)，，要如何快速速把相關(guān)資料料抓出來，並並可以對映出出所需的資料料及格式呢?EAI需要能夠跨異構(gòu)數(shù)據(jù)庫存取的Middleware，同時(shí)要提供動(dòng)態(tài)資料

對映的功能，以適應(yīng)企業(yè)未來的需求?？礃幼?，又得得要修改ERP系統(tǒng)，然后在在每一個(gè)表單單程序上寫一一段資料轉(zhuǎn)換換的程序！為了與客戶進(jìn)進(jìn)行B2B連接，我們被被要求所有與與客戶往來的的信息，都要要能提供符合合客戶所需的的資料格式。。更重要的，，要能同時(shí)支支持公司正規(guī)規(guī)劃的EAI專案!我們要如何才才能將數(shù)據(jù)倉庫中的資料轉(zhuǎn)換換成交換的格格式，同時(shí)又又可以與其他他系統(tǒng)交換?這樣土法煉鋼鋼是可以做出出來，但那聽聽起來真是一一個(gè)浩大工程程！而且以后后可能還得為為EAI專案重新來過過!快速建設(shè)EAI資料轉(zhuǎn)換及整整合BizTalkEditor&DataMapperRequirementXMLEDIStandardsW3CANSIX.12

UN/EDIFACTOthers…DocumentParsingDOM/SAXCustomTranslatorsDocumentDefinitionDTD/XMLSchemasProprietaryDataDictionariesDocumentTransformationXSLTCustomTranslatorsExtensibilityOpenContentModelClosedContentModelCommunicationsInternetVANInternalwork-flow的難題公司內(nèi)有各種種異構(gòu)的平臺(tái)臺(tái)及軟件，好好不容易已經(jīng)經(jīng)可以轉(zhuǎn)換成成XML格式，要如何何透過集中的的Middleware來進(jìn)行EAI流程整合呢?簡單，我們可可以使用COM的傳遞即可。。一但采用自動(dòng)動(dòng)化的流程整整合，我們更難掌控控每一份對內(nèi)內(nèi)及對外的交交換資料是否否完整的被處處理!別忘了，我們們的交易后臺(tái)系統(tǒng)還是是使用mainframe的系統(tǒng)！EAI在面臨異構(gòu)平臺(tái)上之應(yīng)用程序的整合時(shí)，應(yīng)能同時(shí)支持不同的通訊協(xié)定，更要能把資料及流程緊密結(jié)合。OrchestrationBizTalk

Server完整的資料接接受及交換協(xié)協(xié)定MSMQReceive

FunctionFileTransfer

FTPASPHTTPTranslationBridgingMSMQBridgeMQ

SeriesMSMQLegacyApplicationsIInterchange::

Submit()COMAware

ApplicationSMTPExchangeScriptHTTPMSMQFILESMTPDCOMHTTPMSMQFILESMTPDCOMBizTalkServerGroupApplication

DesignerShared

QDatabaseWebDAVAdminDatabaseDocumentTrackingManagement

DeskEditorMapperAdministrationTrackingProcessIntegration&OrchestrationBizTalkServer2000異構(gòu)平臺(tái)及資資料的整合難難題如何將由外部部接收到的資資料，整合至至后臺(tái)系統(tǒng)呢呢？我們可要考慮慮異構(gòu)資料及及平臺(tái)的整合合，特別是后臺(tái)的mainframe交易系統(tǒng)，而會(huì)員系統(tǒng)是SQLServer的數(shù)據(jù)庫服務(wù)器在面臨異構(gòu)平臺(tái)時(shí)，務(wù)必要支持同步及批次作業(yè)的需求，完整支持XML的數(shù)據(jù)庫可讓整合更有彈性。AnXMLdocumentcanbeinserteddirectlyintoSQLServer2000sp_XML_PrepareDocumentOpenXML()XMLApplicationIntegration

ComponentADOINSERT/

UPDATEXMLCustomstoredprocedure數(shù)據(jù)庫整合(DatabaseIntegration)SQLServer2000同步整合(SynchronousIntegration)COM+MainframeSystemsCOMTIAPPCLU6.2TCP/IPAIC非同步整合(AsynchronousIntegration)MainframeSystemsMSMQ

WorldMQSeries

WorldTranslationBridgingMSMQBridgeMSMQMQSeriesAICMainframeIntegrationHostIntegrationServer2000不過，這種勾勾稽也可確保保EAI的建設(shè)更落實(shí)實(shí)，同時(shí)對於於領(lǐng)導(dǎo)常常要求的統(tǒng)計(jì)資料，也變得得更加準(zhǔn)確!EAI資料審核及監(jiān)監(jiān)控的難題不錯(cuò)，透過緊緊密的EAI建設(shè)，能讓公公司更能掌握握客戶的動(dòng)向向。一但采用自動(dòng)動(dòng)化的流程整整合，結(jié)算公司及系統(tǒng)運(yùn)行部要求必須要確確保每一份對對內(nèi)及對外的的交換資料可可以被追蹤及及審核，真是是苦命!!從管理觀點(diǎn)，EAI的結(jié)果要讓流程自動(dòng)化，信息即時(shí)化，更重要的是能有效的審核。透過BizTalkServer進(jìn)行審核TrackingComponents直接從從數(shù)據(jù)據(jù)庫進(jìn)進(jìn)行追追蹤完整文文件記記錄針對特特定欄欄位信信息在Orchestration之間的的信息息提供Web-based的查詢詢工具具提供API讓其他他軟件件可以以對信信息審審核及及追蹤蹤IBizTalkTrackDatainterfaceBasedonhandlereturnedfromIInterchange::SubmitStandardandAdvancedQueriesQuerybyDate,Time,DocumentType,SourceandDestinationorg.AdvancedQueryBuilderCustomfieldquerySavetoDTAdatabaseEAI結(jié)論BizTalkS