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

腾讯云轻量服务器老用户续费优惠和老用户复购活动

继阿里云服务商推出轻量服务器后,腾讯云这两年对于轻量服务器的推广力度还是比较大的。实际上对于我们大部分网友用户来说,轻量服务器对于我们网站和一般的业务来说是绝对够用的。反而有些时候轻量服务器的带宽比CVM云服务器够大,配置也够好,更有是价格也便宜,所以对于初期的网站业务来说轻量服务器是够用的。这几天UCLOUD优刻得香港服务器稳定性不佳,于是有网友也在考虑搬迁到腾讯云服务器商家,对于轻量服务器官方...

Virmach款低价VPS可选可以选择多个机房,新增多款低价便宜VPS主机7.2美元起

Virmach商家我们是不是比较熟悉?速度一般,但是人家价格低,而且机房是比较多的。早年的时候有帮助一个有做外贸也许需要多个机房且便宜服务商的时候接触到这个商家,有曾经帮助够买过上百台这样的低价机器。这里需要提醒的,便宜但是速度一般,尤其是中文业务速度确实不快,如果是外贸业务,那肯定是没有问题。这几天,我们有看到Virmach推出了夏季优惠促销,VPS首年8折,最低年付仅7.2美元,多机房可选,如...

乐凝网络支持24小时无理由退款,香港HKBN/美国CERA云服务器,低至9.88元/月起

乐凝网络怎么样?乐凝网络是一家新兴的云服务器商家,目前主要提供香港CN2 GIA、美国CUVIP、美国CERA、日本东京CN2等云服务器及云挂机宝等服务。乐凝网络提供比同行更多的售后服务,让您在使用过程中更加省心,使用零云服务器,可免费享受超过50项运维服务,1分钟内极速响应,平均20分钟内解决运维问题,助您无忧上云。目前,香港HKBN/美国cera云服务器,低至9.88元/月起,支持24小时无理...

mssql2005为你推荐
复印件重庆操作httpphpwindphpwind怎么用?免费么?请详细说明http500http://bb500.com 这个电影网站安全不?为什么?有人能告诉我吗?不懂的人表乱说浪费你我的时间谢谢mediawikimediawiki的乱码问题360退出北京时间为什么我电脑上的时间跟北京时间不同步!!!"AcerMéxico.Listadeprecios-VigenteapartIrdel1deabrilde2011"重庆400年老树穿楼生长重庆的树为什么都长胡须?重庆400年老树穿楼生长生长百年的老树,仍能不断生长,是因为主要有什么组织什么是支付宝支付宝是什么意思?
vps服务器租用 双线主机租用 域名解析文件 罗马假日广场 arvixe 256m内存 免备案cdn 轻博 网站实时监控 发包服务器 ibox官网 我的世界服务器ip net空间 金主 阵亡将士纪念日 闪讯网 重庆联通服务器托管 百度新闻源申请 hosts文件修改 西部主机 更多