Checkmssql2005

mssql2005  时间:2021-05-05  阅读:()
DELLPOWERSOLUTIONSReprintedfromDellPowerSolutions,February2006.
Copyright2006DellInc.
Allrightsreserved.
February200626DATABASES:SQLSERVER2005Enterprisedatacentersthathostbusiness-criticalappli-cationsanddatabasescanbeatriskfromfailuresanddisasters.
Availabilityandrecoverabilitybecomecrucialforbusinessoperations.
Currentdatabaseavailabilitytechnolo-giesvaryintheircomplexity,cost,levelofautomation,incurreddowntime,andsupporteddistance.
Amajorchal-lengeforanenterpriseisdeterminingthemostcost-effectiveandleastcomplexsolutiontohelpensuredatabaseavail-abilityandmeetbusinessneeds.
MicrosoftSQLServer2005introducesseveralhigh-availabilityfeaturesandfeatureenhancementsfortheSQLServerdatabaseplatform.
FailoverclusteringFailoverclusteringwithMicrosoftClusterService(MSCS)isapopularwaytoachievehighavailabilityforSQLServer.
WithMSCS,multipleserversornodesarelinkedtofunctionasasinglesystemandprovideanautomaticfailoversolution.
Enterprisesareconnectedtovirtualserv-ersandnotphysicalservers;eachactivephysicalservermayhostoneormorevirtualservers.
Ifoneofthephysicalserversfailsbecauseofeitherahardwareorsoftwareproblem,MSCSdetectsthefailureandmovesresourcesthatresideonthefailingserver—includingthevirtualserver(s)—tooneormoreremainingphysicalservers.
EndusersconnectedtothefailedserverobserveonlyamomentarydelayinaccessingitsresourceswhileMSCSrestartsSQLServerservicesontheremainingserver(s)andremapsthevirtualserverconnections.
Installingafailoverclusterrequiresthefollowing:MicrosoftWindows2000Server(AdvancedServerorDatacenterServer)orMicrosoftWindowsServer2003(EnterpriseEdition,DatacenterEdition,Enterprisex64Edition,orDatacenterx64Edition)MicrosoftSQLServer2005(StandardEditionorEnterpriseEdition)SharedstoragebasedonSCSI,FibreChannel,orSerialAttachedSCSIAllcomponents(server,hostbusadapter,andstor-agesystem)andtheclustersolutionlistedintheMicrosoftWindowsServerCatalogFigure1showstwotypicaltwo-nodefailoverclusterconfigurationsforSQLServer2005,oneinactive/passiveBYANANDASANKARAN,DATNGUYEN,ANDNAMNGUYENExploringHigh-AvailabilityFeaturesinMicrosoftSQLServer2005sMicrosoftSQLServer2005offersfailoverclustering,databasemirroring,logshipping,replication,anddatabasesnapshotfeaturesthatcanhelpsafeguardanenterprise'scriticaldataandoperations.
Thisarticlediscussesthesefeaturesandtheirassociatedtrade-offs.
RelatedCategories:ClusteringDatabaseHighavailability(HA)MicrosoftSQLServer2005Visitwww.
dell.
com/powersolutionsforthecompletecategoryindex.
DATABASES:SQLSERVER2005www.
dell.
com/powersolutionsReprintedfromDellPowerSolutions,February2006.
Copyright2006DellInc.
Allrightsreserved.
DELLPOWERSOLUTIONS27modeandoneinactive/activemode.
Inafailoverclusterenvi-ronment,SQLServer2005offersseveraladditionalfeaturesandimprovementscomparedtoSQLServer2000:Supportformultinodeclustering:StandardEditionallowsuptotwo-nodeclusteringandEnterpriseEditionuptoeight-nodeclustering.
SupportforSQLservices:AnalysisServicesfeatureoffersmulti-instancesupportandfull-textindexing.
Easierinstallation:SystemConfigurationCheckautomati-callydetectsandinstallsSQLServerasvirtualserversacrossthenodesinthecluster.
DatabasemirroringDatabasemirroringisdesignedtoaugmenttheavailabilityofSQLServer2005.
Withthisfeature,transactionstoadatabasehostedonaSQLServerinstance,referredtoastheprincipal,canbecon-tinuouslyduplicatedinrealtimeontoacopyhostedonanotherinstance,referredtoasthemirror.
Theprincipalandmirrorserversareconsideredpartnersinadatabasemirroringsession.
Transac-tions(suchasinsertions,updates,anddeletions)ontheprincipaldatabaseareduplicatedbycontinuouslysendingtransactionlogrecordstothemirroroverthenetwork(seeFigure2).
Themirrorreceivesthelogrecordscontinuouslyandrestoresthem.
Iftheprincipalormirrorserverincursafailure,themirror-ingsessionisdisconnected.
Beforestartingthemirroringsession,administratorsmustinitializethemirrordatabasefromaprincipaldatabasefull-restorewiththeNORECOVERYoption.
Besidestheprimaryandmirror,amirroringsessionmayincludeanoptionalthirdserver,referredtoasthewitness.
Thewitnessserverenablesautomaticfailoverafteraprincipalserverfailurebypromotingthemirrortofunctionastheprincipal.
Usingawitnessserverhelpsachieveaquorumandpreventsaccidentalpromotionofthemirrordatabasethatresultsfromcommunicationfailuresbetweentheprincipalandmirror.
Databasemirroringrequiresthefollowingconfiguration:Theprimaryandmirrordatabasesmustbehostedonsepa-rateSQLServer2005instances.
TheprincipaldatabasemustbesettotheFullRecoverymodel,nottheBulk-LoggedRecoveryorSimpleRecoverymodel.
Databasemirroringcanbeconfiguredinanyofthefollowingthreeoperatingmodesbasedontransactionsafetylevelandthepresenceofawitnessserver:High-availabilitymode:Inthismode,logrecordsaretrans-ferredsynchronouslyfromtheprincipaldatabasetothemirror.
Theprincipalwaitsforanacknowledgmentfromthemirrorbefore"hardening"logrecordstoitsdisk.
Inadditiontoprovidingsynchronoustransfer,thismodeusesawitnessservertoenableautomaticfailover.
High-protectionmode:Thismodeissimilartothehigh-availabilitymodeexceptthatitdoesnotsupportawitnessserver,andthusautomaticfailoverisnotpossible.
However,failovercanbeperformedmanuallytopromotethemirrordatabase.
Becausethelogrecordsaretransferredsynchro-nouslyinthismode,themirrordatabaseissynchronousandconsistentwiththeprincipal.
High-performancemode:Inthismode,logrecordsaretransferredasynchronouslyfromtheprincipaltothemirrordatabase.
Theprincipaldoesnotwaitforanacknowledg-mentfromthemirrorbefore"hardening"itslogstothedisk,Figure1.
FailoverclusterconfigurationsforSQLServer2005SQLServer2005db1db2SQLServer2005HeartbeatLANActivePassiveSQLServer2005db1SQLServer2005HeartbeatLANActiveActivedb2Figure2.
Databasemirroringfordatabasedb1inhigh-availabilitymodeLANPrincipalMirrordb1db2db3SQLServer2005db5db6SQLServer2005SQLServer2005db1TransactionlogrecordsLogrecoveryWitnessDATABASES:SQLSERVER2005DELLPOWERSOLUTIONSReprintedfromDellPowerSolutions,February2006.
Copyright2006DellInc.
Allrightsreserved.
February200628andthemirrorisnotguaranteedtobesynchronouswiththeprincipalatanypoint.
Thismodedoesnotsupportawit-nessserver,andthusneitherautomaticnormanualfailoverispossible.
However,aforcedfailovercanbeperformedtorecoverthemirror,withsomedatalossoccurringbecausemirroringisasynchronous.
Akeyadvantageofdatabasemirroringisthatitprovidesquickfailoverandhighavailabilitywithminimalhardwarecostandcomplexity.
Formerly,suchSQLServermirroringsolutionswereoftenfeasibleonlywithexpensive,proprietaryhardware-basedmechanisms.
Withacceptablelatenciesandbandwidth,mirroringcanbedeployedoveralong-distancewideareanetwork(WAN)aspartofadisasterrecoverysolution.
Duringthemirroringsession,themirrordata-baseisnotavailableforclientaccessbecauseitisinarecoverystate,butadatabasesnapshotcanbecreatedonthemirrorforlimitedreporting.
Onlyonemirrordatabasecanbeestablishedforaprinci-paldatabase.
However,theparticipatingSQLServerinstancescanassumediffer-entrolesfordifferentmirror-ingsessions.
Forexample,aSQLServerinstancecanserveasaprincipalforonedatabase,asamirrorforanotherdatabase,andasawitnessforyetanothermirroringsession.
Thenotionofavirtualserver,asisusedinfailoverclustering,doesnotexist.
However,MicrosoftADO.
NETprovidesanapplicationprogramminginterface(API)forclientstoautomaticallyreconnecttothemirrorserverduringfailures.
LogshippingLogshippingissimilartodatabasemirroring.
Itallowsadatabasehostedonaprimaryservertoautomaticallysendtransactionlogstoasecondarydatabaseforduplication.
Thelogrecordsarenottransferredcontinuouslyasindatabasemirroring,butratherinintervals.
Logshippingcomprisesbackingupthetransactionlogsontheprimaryserverinstance,copyingthebacked-uplogstothesecondaryserverinstance,andrestoringthecopiedlogsonthesecondaryserverinstanceperiodically.
TheprimarydatabaseshouldbeconfiguredfortheFullRecoveryorBulk-LoggedRecoverymodel.
ThesecondarydatabaseshouldbeinitializedbyafullrecoveryoftheprimarydatabasewiththeNORECOVERYorSTANDBYoption.
Logshippingcanoptionallyincludeathirdservernamed"mon-itor"torecordthehistoryoflog-shippingoperationsandtoraisealertsduringfailures.
Log-shippingoperationsarecarriedoutbyfourMicrosoftSQLServeragentjobs:backupjob,copyjob,restorejob,andalertjob.
Duringlogshipping,thesecondarydatabaseisnotcompletelysynchronizedwiththeprimarydatabase.
Also,logshippingdoesnotprovideautomaticfailovertothesecondaryserverduringafailure.
Logshippingsupportsmultiplesecondaryserversforaprimaryserver.
Inaddition,aSQLServerinstancecanfunctionasasecondaryormonitorserverformultipleprimaryservers.
Thesecondaryservercanbeuseddirectlyforlimitedqueryprocessing.
Logshippingcanbeusedinscenarioswheremultipledestina-tionserversareneededandwheredelaysinrestoringlogsontheduplicateareacceptable.
ReplicationReplicationisasetoftechnologiesfordistributingdataanddata-baseobjectsacrossMicrosoftSQLServerdatabasesoveranet-work.
Replicationinvolvesapublisherdatabaseinstancethatmakesdataavailableforcopying,adistributorinstanceforcopyingdataandmaintainingmetadata,andsubscriberinstancesthatcanreceivereplicateddata.
SQLServer2005providesthreetypesofreplicationtech-nologiessuitablefordifferentneeds:transactional,merge,andsnapshot.
SQLServer2005addsenhancementstotheserepli-cationmethodstohelpimprovescalability,performance,andmonitoringcapabilities.
Someoftheimprovementsincludeadditionalreplicationdatatypes,supportforpartitionedtablesandfull-textindex,directDataDefinitionLanguage(DDL)replicationforschemachanges,andreplicationfromOracledatabases.
Intransactionalreplication,SQLServer2005addsanimpor-tantfeaturecalledpeer-to-peerreplication,whichenhancestheexistingbidirectionalreplicationoption.
Advantagesofreplicateddatabasesincludedataloadbalancinganddisasterrecovery.
Withthepeer-to-peerreplicationfeature,administratorscansetupmultiplepeer-to-peertransactionalreplicationpairsamongdifferentdatacenters.
Thatway,ifonedatacenterisdown,itcanbefailedovertoitspeercenter(s).
Althoughthereisnolimittothenumberofnodesinapeer-to-peertopology,man-ageabilityofthepeer-to-peerrelationshipsbetweennodescanbecomeaconstraint.
SQLServer2005providesthreetypesofreplicationtechnologiessuitablefordifferentneeds:transactional,merge,andsnapshot.
SQLServer2005addsenhancementstothesereplicationmethodstohelpimprovescalability,performance,andmonitoringcapabilities.
DATABASES:SQLSERVER2005www.
dell.
com/powersolutionsReprintedfromDellPowerSolutions,February2006.
Copyright2006DellInc.
Allrightsreserved.
DELLPOWERSOLUTIONS29DatabasesnapshotsAdministrativeandapplicationerrorscanbeamajorcauseofdatabasedowntime.
SQLServer2005introducesafeaturecalledData-baseSnapshotstohelpprotectadatabasefromerroneoususeroperationsandtoaugmentdatabasebackupandrestoreoperations.
TheDatabaseSnapshotsfeatureallowsrecoveryfromusererrorsbyallowingthedatabasestatetoreverttoapointintimebeforetheerror(s)occurred.
Itworksinstand-alone,failoverclus-tering,anddatabasemirroringenvironments.
However,itdoesnotworkwithalog-shippingsecondarydatabase.
Adatabasesnapshotisasnapshotofanentiredatabaseatagiventime.
Thesnapshotiscreatedinstantlyandcanbeusedforread-onlytaskssuchasreporting.
Asnapshotmusthavebeencre-atedbeforetheerroroccurredforanadministratortorestorethedatabasetoaconsistentstate.
Snapshotcreationdoesnotimposerestrictionsonthebasedatabaseoperations.
Administratorscancreatemultiplesnapshotsfromadatabaseaswell.
TheSQLServer2005DatabaseSnapshotfeatureemploysacopy-on-writemechanism.
Onlychangestothebasedatabase—nottheentirebasedatabase—arerecordedafterthesnapshothasbeentaken.
Thesnapshotisapointerimagetothebasedatabase.
Itsharestheunchangedpagesofthebasedatabaseandrequiresonlyextrastorageforchangedpages.
TheDatabaseSnapshotmechanismisillustratedinFigure3.
TheDatabaseSnapshotfeatureisdesignedtobeextremelyspace-efficient.
Anymodificationsuchasawrite(step1inFigure3)tothebasedatabaseafterasnapshotistakenwillberecorded(step2inFigure3)aspartofthetargetsnapshot.
IfI/Oreadrequests(step3inFigure3)aretoblocksthathavenotchangedsincethesnapshotwascreated,thentherequestwillreadfromthebasedatabase.
IfI/Orequestsaretoblocksthathavechangedsincesnapshotcreation,thentherequestwillbereadfromthesnapshot.
Figure4summarizesthehigh-availabilityfeaturesandoptionsavailableinMicrosoftSQLServer2005.
Ahigh-availabilitydatabaseplatformMicrosoftSQLServer2005offersseveralfeaturesthataredesignedtohelpaugmentavailabilityofdata.
DellPowerEdgeservers,DellPowerVaultstorage,andDell/EMCstoragearealsodesignedwithabroadarrayofredundanthardwareandsoftwarefeaturestomaximizehardwareavailability.
ThefeaturesinDellhardwareandSQLServer2005provideanintegrated,industry-standardapproachtohighdatabaseavailability.
Acombinationofthesecomponentscangreatlybenefitenterpriseswithhigh-availabilitydatabaserequirements.
AnandaSankaranisasystemsengineerintheHigh-AvailabilityClusterDevelopmentGroupatDell.
Hiscurrentinterestsrelatedtohigh-availabilityclusteringincludestoragesystems,applicationperformance,businessconti-nuity,andclustermanagement.
Anandahasamaster'sdegreeinComputerSciencefromTexasA&MUniversity.
DatNguyenisasystemsengineerintheHigh-AvailabilityClusterDevelop-mentGroupatDell.
Hisresponsibilitiesincludedevelopingstorageareanetwork(SAN)–basedhigh-availabilityclusteringproducts.
Hiscurrentinterestsareinenterprisestorageproductsandtechnologies.
DathasaB.
S.
inElectricalEngineeringfromtheUniversityofHouston.
NamNguyenisaseniorconsultantintheHigh-AvailabilityClusterDevelop-mentGroupatDell,andtheleadengineerforDellFibreChannelPowerEdgeClusterproducts.
Hiscurrentinterestsincludebusinesscontinuity,cluster-ing,andstoragetechnologies.
HehasaB.
S.
andanM.
S.
inElectricalEngineeringfromTheUniversityofTexasatAustin.
FORMOREINFORMATIONMicrosoftSQLServer2005:www.
dell.
com/sqlwww.
microsoft.
com/sqlFigure3.
DatabaseSnapshotmechanisminSQLServer2005123456789101112123456789101112123SnapshotsPageBasedatabaseFigure4.
High-availabilityoptionsandfeaturesinSQLServer2005Solution-specicAutomaticcerticationGranularityDatalossfailoverDowntimerequirementsFailoverclusteringSystemandNoYesApproximatelyClustersolutionlisteddatabase20secondsplusinMicrosoftWindowsdatabaserecoverytimeServerCatalogDatabasemirroringDatabaseDependsonYesLessthan3secondsNooperatingmodePeer-to-peerreplicationTableorviewSomeOptionalVariable(littletonone)NoLogshippingDatabaseSomeNoVariableNoDatabasesnapshotsTableorviewSomeNoVariableNo

NameCheap黑色星期五和网络礼拜一

如果我们较早关注NameCheap商家的朋友应该记得前几年商家黑色星期五和网络星期一的时候大促采用的闪购活动,每一个小时轮番变化一次促销活动而且限量的。那时候会导致拥挤官网打不开迟缓的问题。从去年开始,包括今年,NameCheap商家比较直接的告诉你黑色星期五和网络星期一为期6天的活动。没有给你限量的活动,只有限时六天,这个是到11月29日。如果我们有需要新注册、转入域名的可以参加,优惠力度还是比...

DMIT:美国cn2 gia线路vps,高性能 AMD EPYC/不限流量(Premium Unmetered),$179.99/月起

DMIT怎么样?DMIT最近动作频繁,前几天刚刚上架了日本lite版VPS,正在酝酿上线日本高级网络VPS,又差不多在同一时间推出了美国cn2 gia线路不限流量的美国云服务器,不过价格太过昂贵。丐版只有30M带宽,月付179.99美元 !!目前,美国云服务器已经有个4个套餐,分别是,Premium(cn2 gia线路)、Lite(普通直连)、Premium Secure(带高防的cn2 gia线...

腾讯云轻量应用服务器关于多个实例套餐带宽

腾讯云轻量应用服务器又要免费升级配置了,之前已经免费升级过一次了(腾讯云轻量应用服务器套餐配置升级 轻量老用户专享免费升配!),这次在上次的基础上再次升级。也许这就是良心云吧,名不虚传。腾讯云怎么样?腾讯云好不好。腾讯云轻量应用服务器 Lighthouse 是一种易于使用和管理、适合承载轻量级业务负载的云服务器,能帮助个人和企业在云端快速构建网站、博客、电商、论坛等各类应用以及开发测试环境,并提供...

mssql2005为你推荐
期刊esetpiaonimai这位主播叫什么温州商标注册温州代理注册个商标是怎么收费的?正大天地网二三线城市适合做生鲜b2b电商吗申请400电话申请400电话需要什么条件如何发帖子请问在网上发帖子怎么发?无忧登陆无忧登陆怎么用??帝国cms教程如何使用帝国CMS网站管理系统仿制网站?joomla教程php100视频教程一键备份一键还原怎么备份?
黑龙江域名注册 老域名全部失效请记好新域名 edgecast bluevm koss payoneer sub-process 美国php主机 免费网站申请 我爱水煮鱼 web服务器架设 申请个人网站 国外代理服务器地址 ftp免费空间 四核服务器 外贸空间 美国凤凰城 东莞服务器托管 空间申请 深圳主机托管 更多