| 订阅 | 在线投稿
分享
 
 
当前位置: 王朝网络 >> mssql >> SQL Server 2008 shi xian gao ke yong xing
 

SQL Server 2008 shi xian gao ke yong xing

2008-09-23 07:48:04 编辑來源:互联网 评论
 
本文为【SQL Server 2008实现高可用性】的拼音翻译版
  gao ke yong xing —Always On ji shu
  SQL Server ji shu wen zhang
  zuo zhe : Geoff Allix ( nei rong zhu guan )
  ji shu shen cha : Michael Raheem
  xiang mu bian ji :Joanne Hodgins
  fa bu ri qi :2007 nian 11 yue
  shi yong chan pin :SQL Server 2008
  zhai yao :Microsoft® SQL Server® 2008 tong guo ti gong ge zhong gao ke yong xing jie jue fang an , suo duan le ye wu guan jian xing shu ju ku de ting ji shi jian 。 zhe xie jie jue fang an shi yong hu he qi ye zhi yuan mei tian 24 xiao shi 、 mei zhou 7 tian dou ke yi fang wen shu ju , qie reng neng ti gong jing ji you xiao de gao xing neng 。SQL Server 2008 zhong de Always On gong neng zeng qiang le dui xi tong he ying jian de bao hu , jian shao le ji hua zhong huo ji hua wai ting ji de ci shu he hui fu shi jian , bing jian shao le you yu da liang yong hu tong shi fang wen tong yi shu ju ku er dao zhi de chong tu 。
  ban quan
  zhe shi yi fen yu bei wen dang , zai ben wen dang zhong suo shu ruan jian de zui zhong shang ye ban ben fa bu zhi qian , gai wen dang de nei rong ke neng hui fa sheng chong da bian hua 。
  ben wen dang zhong ti gong de xin xi dai biao le Microsoft Corporation dang qian ( ruan jian fa bu zhi qian ) dui suo tao lun wen ti chi you de guan dian 。 yin wei Microsoft bi xu xiang ying bu duan bian hua de shi chang tiao jian , suo yi qi dang qian de guan dian bu ying bei jie shi wei shi yi zhong cheng nuo , ruan jian fa bu zhi hou ,Microsoft bu neng bao zheng xian zai suo ti gong de suo you xin xi zhun que wu wu 。
  zhe fen bai pi shu jin gong shen kao 。 Microsoft dui ben wen dang zhong ti gong de xin xi bu zuo ren he dan bao 、 ming shi 、 an shi huo fa lv fang mian de cheng nuo 。
  yong hu you ze ren zun shou suo you shi yong de ban quan fa 。 zai ban quan quan li xian zhi xia , wei jing Microsoft gong si ming que de shu mian xu ke , ben wen dang de ren he nei rong bu neng bei fu zhi 、 cun chu huo fang jin jian suo xi tong , huo zhe yi ren he xing shi huo ren he shou duan ( dian zi 、 ji xie 、 fu yin 、 lu zhi huo qi ta ) huo wei da dao ren he mu de jin xing zhuan huan 。
  Microsoft dui ben wen han gai de zhu ti nei rong ke neng yong you zhuan li 、 zhuan li shen qing 、 shang biao 、 ban quan huo qi ta zhi shi chan quan 。 mei you lai zi Microsoft de ren he shu mian xu ke xie yi de ming que biao shi , ben wen bu fu yu nin dui zhe xie zhuan li 、 shang biao 、 ban quan huo qi ta zhi shi chan quan de ren he xu ke 。
  chu fei ling you shuo ming , fou ze ben wen ti ji de shi li gong si 、 zu zhi 、 chan pin 、 yu ming 、 dian zi you jian di zhi 、 hui biao 、 ren wu 、 di dian he shi jian jie shu xu gou , yu ren he zhen shi de gong si 、 zu zhi 、 chan pin 、 yu ming 、 dian zi you jian di zhi 、 hui biao 、 ge ren 、 di dian huo shi jian wu guan 。
  Ó 2007 Microsoft Corporation。 bao liu suo you quan li 。
  Microsoft、Windows、Office he SQL Server shi Microsoft Corporation zai mei guo he / huo qi ta guo jia / di qu de shang biao huo zhu ce shang biao 。
  ben wen zhong ti ji de zhen shi de gong si ming cheng he chan pin ming cheng ke neng shi qi ge zi suo you zhe de shang biao 。
  mu lu
  jian jie 1
  ke yong xing ying yong chang jing 1
  ti gao ke yong xing 2
  shu ju ku jing xiang 2
  ri zhi chuan song 2
  gu zhang zhuan yi qun ji 3
  di li fen san gu zhang zhuan yi qun ji 3
  dui deng fu zhi 3
  suo duan ting ji shi jian 4
  kuai su shu ju ku hui fu 4
  bei fen he huan yuan 4
  shu ju ye shang de xiao yan he 5
  zai xian suo yin cao zuo 5
  zai xian 、 duan luo he ye ji huan yuan 5
  bu fen shu ju ke yong xing 6
  kuai zhao ge li 6
  dong tai pei zhi 6
  zeng qiang de ke guan li xing 6
  shu ju ku kuai zhao 6
  biao he suo yin fen qu 7
  bei fen he huan yuan 7
  zhuan yong guan li yuan lian jie 7
  zi yuan tiao kong qi 7
  jie shu yu 7
  dao yan
  ren he ying yong cheng xu de ting ji shi jian dou hui gei qi ye dai lai fu mian ying xiang , dao zhi shou ru sun shi 、 ke hu man yi du xia jiang bing sun hai qi ye de xin yu 。 xu duo shu ju ku ying yong cheng xu , you qi shi qi ye ye wu ying yong cheng xu , yao qiu xi tong ting ji shi jian jin ke neng suo duan 。 xi tong ting ji shi jian de chan sheng you duo zhong yuan yin , ru ren wei shi wu 、 zi ran zai hai 、 ying jian huo ruan jian gu zhang yi ji ying yong cheng xu sheng ji 。Microsoft SQL Server 2008 Always On ji shu ti gong le ge zhong xuan xiang , ke jiang ting ji shi jian jiang zhi zui di , qie bao chi shi dang ji bie de ying yong cheng xu ke yong xing 。
  ke yong xing ying yong chang jing
  dui xu duo ye wu er yan , huo de gao ke yong xing shi yi zhong chang jian xu qiu 。 jie jue fang an shi fou shi yong yu te ding de ying yong chang jing qu jue yu hen duo yin su , zai yi zhong chang he xia biao xian zui jia de jie jue fang an zai ling yi zhong chang he xia bu yi ding shi zui shi he de 。 li ru ru xia ying yong chang jing :
  ji yu Internet de yun dong shang pin ling shou shang xiang wei qi ke hu ti gong jin si lian xu de ke yong xing 。Web fu wu qi yi jia dao Web chang zhong , dan shu ju ku gu zhang hui chan sheng cuo wu , zhe xie qing xing da duo shu shi hou hui shi gong si shi qu ke hu 。 gai gong si yi jing yong you jing gai zhun de biao zhun fu wu qi ban ben , xi wang neng gou bi mian hua fei da liang zi jin 、 geng gai ji chu jie gou huo chong xie ying yong cheng xu 。
  lie tou gong si hen guan zhu qi yong hu shi yong ke hu shu ju ku shi yu dao de cuo wu 。 sui ran mei you bi yao li ji zhi xing gu zhang hui fu , dan gai gong si huan shi xi wang yong you yi tai ke yi kuai su zai xian huo de de wen bei yong fu wu qi 。
  bao xian gong si xiang wei qi suo pei shu ju ku ti gong jin si lian xu de ke yong xing 。 gai xi tong de xing neng yi ding bu neng shou dao ying xiang , er qie dang qian cun chu zai wen jian xi tong zhong yong yi zhi chi suo pei de wen dang ye bi xu ke yong 。
  guan li pei xun gong si you san ge zhan dian , mei ge zhan dian dou you yi zhi xiao shou tuan dui 。 xiao shou tuan dui jiang ge zi zhan dian de ji lu shu ru Orders shu ju ku zhong 。 wei ti gao xing neng , yao qiu mei ge zhan dian neng gou zai ben di fu wu qi shang fang wen gong si de suo you ding dan 。 dang chu xian gu zhang shi , wei ti gong ke yong xing , mei ge zhan dian dou bi xu neng gou qie huan dao ling yi ge zhan dian de fu wu qi 。
  hui ji gong si xi wang zai chu xian gu zhang shi ( ru zi ran zai hai ) ye neng wei qi ke hu ti gong ke yong xing 。 xin xi bu yi ding yao li ji ke yong , dan ying gai zai shu xiao shi er bu shi shu tian nei ke gong shi yong 。 gai gong si huan xiang mei tian dou bao cun shu ju ku zhong de xin xi , yi man zu fa gui yao qiu 。 kao bei de shu ju bu xu yao li ji ke yong , dan bi xu zai xu duo nian nei dou ke gong shi yong 。
  wan ju zhi zao shang xiang gen ju xiao shou shu ju ku bian zhi bao gao , dan you yu gai shu ju ku yi zhi chu yu shi yong zhuang tai , yin ci bian zhi bao gao de guo cheng tong chang hui bei dang qian zheng zai zhi xing de jiao yi da duan 。 gai gong si xi wang neng gou zhen dui wei ti jiao de jiao yi bian zhi bao gao , dan zhe hui chan sheng bu zheng que de jie guo , yin wei you xie jiao yi bing bu wan zheng 。
  fang di chan gong si xiang zai yong hu cao zuo cuo wu shi bao hu xi tong , xi wang neng gou hui fu qian yi tian de ji lu zhi 。 gai gong si huan xiang neng gou gen ju qian yi tian de shu ju bian zhi bao gao , yin wei ta men bu hui shou dao dang tian jiao yi de ying xiang 。 zai li xiang qing kuang xia , gai gong si xi wang shi shi yi zhong ci pan kai xiao zui xiao de jie jue fang an 。
  gen ju ge zhong ke yong xing yao qiu , qi ye xu yao yi zhong neng wei gao ke yong xing jie jue fang an ti gong ling huo xuan xiang de shu ju ku ping tai 。 ben bai pi shu zhong , ke yi kan dao SQL Server 2008 Always On ji shu ru he wei gao ke yong xing ti gong ling huo xuan xiang , yi shi qi ye neng gou gen ju te shu xu qiu shi shi zui jia jie jue fang an 。
  ti gao ke yong xing
  xu duo shu ju ku ying yong cheng xu dou shi ren wu guan jian xing de , yin ci yao qiu ting ji shi jian jin ke neng duan , bing zai fa sheng zai nan shi neng gou xun su hui fu 。SQL Server 2008 ti gong le ge zhong Always On ji shu , ke yi shi ting ji shi jian jian zhi zui shao ji huo de shi dang ji bie de ke yong xing 。
  shu ju ku jing xiang
  “Database Mirroring( shu ju ku jing xiang )” shi yi zhong ke ti gao shu ju ku ke yong xing de ji shu 。 dang zhu ti shu ju ku fa sheng geng gai shi , zhe xie geng gai ye jiang zi dong ying yong dao jing xiang shu ju ku zhong 。 dang zhu ti fu wu qi fa sheng gu zhang shi , ke hu ji ying yong cheng xu ke zi dong chong ding xiang dao jing xiang fu wu qi , er ying yong cheng xu wu xu jin xing ren he gai dong 。
  ke yi dui Database Mirroring jin xing pei zhi , yi dui jing xiang fu wu qi shi shi ying yong geng gai , cheng wei “ tong bu ”; huo zhe jin hu shi shi ying yong geng gai , cheng wei “ yi bu ”, yin ci ke yi zai xi tong zhong zhi ding bao hu ji bie he xing neng kai xiao 。
  you le SQL Server 2008 Enterprise Edition zhi hou , jing xiang bao hu jiu ke kuo zhan dao shu ju ye 。 ru guo fa xian zhu ti fu wu qi huo jing xiang fu wu qi shang de shu ju ye sun huai , jiang cong huo ban fu wu qi shang jian suo dui ying de shu ju ye , er shu ju cao zuo ye hui ping wen di ji xu zhi xing 。SQL Server 2008 huan gai shan le shu ju ku jing xiang , ta jiang ya suo zhu ti fu wu qi yu jing xiang fu wu qi zhi jian de shu ju liu , er qie zai shou dong zhi xing gu zhang hui fu shi , wu xu chong qi shu ju ku 。
  zai ji yu Internet de yun dong shang pin gong si de an li zhong , dang chu xian fu wu qi 、 shu ju ku huo ye ji gu zhang shi ,Database Mirroring jiang ti gong fei chang xun su de gu zhang hui fu neng li 。 sui ran bi xu gou mai xin fu wu qi , dan wu xu chong xie ying yong cheng xu , bei yong fu wu qi shi biao zhun she bei , bu xu yao SQL Server xu ke zheng 。
  ri zhi chuan song
  “ ri zhi chuan song ” shi yi zhong gao ke yong xing ji shu , ta ti gong le wen bei yong fu wu qi 。 bei fen shi zai zhu fu wu qi shang zhi xing de , er huan yuan shi zai yi ge huo duo ge fu zhu fu wu qi shang zhi xing de 。 ran hou ,“ ri zhi chuan song ” jiang ding qi ri zhi bei fen ying yong yu fu zhu fu wu qi 。 sui ran shu ju ku jing xiang zhi neng you yi tai jing xiang fu wu qi , dan “ ri zhi chuan song ” ke yi you xu duo fu zhu fu wu qi , zhe ke yi ti gao bao hu ji bie 。
  “ ri zhi chuan song ” shi an zhao shi jian biao zhi xing de , yin ci zai zhu fu wu qi shang de shu ju geng gai yu zhe xie geng gai chuan shu dao fu zhu fu wu qi shang zhi jian you shi jian yan chi 。 zhe zhong yan chi hui dao zhi shu ju sun shi , dan zai xu duo ying yong chang jing xia , zhe xie yan chi ke yong zuo huan yuan yong hu cuo wu de yi zhong fang fa , yin wei ke yi yan chi ri zhi shu ju zai fu zhu fu wu qi shang de ying yong ( cong er bao liu fu zhu fu wu qi shang de yuan shi shu ju )。
  wei jiang di zhu fu wu qi de gong zuo fu he , fu zhu fu wu qi ke yong zuo zhi du bao gao fu wu qi , dan zai ying yong ri zhi bei fen shi wu fa yun xing bao gao 。
  zai lie tou gong si de an li zhong , ke li yong ri zhi bei fen yu bei yong fu wu qi zhi xing huan yuan zhi jian de yan chi ying yong “ ri zhi chuan song ”。 zhe ke yi niu zhuan you yong hu dao zhi de cuo wu qing xing , yin wei ru guo zhu fu wu qi fa sheng gu zhang , ke yi zhi jie ying yong ri zhi yi jian shao shu ju sun shi 。
  gu zhang zhuan yi qun ji
  “ gu zhang zhuan yi qun ji ” shi yi zhong Windows gong neng , ke dui zheng ge fu wu qi ti gong bao hu , er bu zhi shi bao hu shu ju ku 。 duo tai fu wu qi ( cheng wei “ jie dian ”) gong xiang ci pan zhen lie , yin ci ru guo yi ge jie dian fa sheng gu zhang , ze ke zai ji qun zhong de ling yi ge jie dian shang qi dong ta de fu wu 。 gai jie jue fang an ke yi fang zhi ren he shu ju sun shi , bing ti gong zi dong de ke hu ji chong ding xiang fu wu , dan cong zhu fu wu qi dao fu zhu fu wu qi de gu zhang hui fu cao zuo mei you shu ju ku jing xiang na yang kuai , er qie xu yao zhuan men de ying jian 。
  Windows Server 2008 kuo zhan le jiu ban Windows de qun ji gong neng , ta jiang di le dui ying jian he ji chu jie gou de yao qiu , qie zai yi ge qun ji zhong zhi chi 16 ge jie dian 。 ci wai , you yu bu yao qiu suo you jie dian dou zhu liu yu tong yi ge zi wang zhong bing zhi chi OR yi lai guan xi ( li ru , dang liang ge IP di zhi zi yuan zhong de ren he yi ge ke yong shi , ke que bao wang luo ming zi yuan ye ke yong ), yin er qiang hua le qun ji gong neng 。 cong zong ti shang jiang , zai Windows Server 2008 zhong ke yi geng rong yi di she zhi he guan li qun ji , er yin jin de qun ji yan zheng gong ju you zhu yu que bao qun ji jie jue fang an you zu gou de ying jian zi yuan 。 tong guo li yong Windows Server 2008 zhong de qun ji zeng qiang gong neng ,SQL Server 2008 wei zheng ge SQL Server shi li ti gong le jian zhuang de gao ke yong xing jie jue fang an 。SQL Server 2008 huan gai shan le jiu ban de qun ji gong neng , ta bu yao qiu mei ge SQL Server shi li dou yao you yi ge pan fu , zhe ti gao le qun ji jie jue fang an ke yi zhi chi de shi li shu liang 。
  zai bao xian gong si an li zhong ,“ gu zhang zhuan yi qun ji ” ke yong yu ti gong jin si lian xu de ke yong xing 。“ gu zhang zhuan yi qun ji ” bu hui ying xiang xi tong xing neng , yin wei ta shi yi zhong fu wu qi ji jie jue fang an , neng gou wei fu wu qi shang de qi ta zi yuan ti gong ke yong xing 。 ru guo dan xin gong xiang ci pan zhen lie bu neng ti gong zu gou de rong yu , ze ke shi yong “ di li fen san qun ji ”。
  di li fen san gu zhang zhuan yi qun ji
  “ di li fen san gu zhang zhuan yi qun ji ” an zhao ren zheng de Microsoft Geographically Dispersed Cluster Services pei zhi ti gong fu wu qi ji rong yu , gai pei zhi yao qiu mei ge zhan dian yong you yi ge huo duo ge cun chu zhen lie 。 ru guo zhan dian 、 fu wu qi jie dian huo ci pan fa sheng gu zhang , xi tong he ci pan de wan zheng rong yu jiang shi gu zhang zhuan yi qun ji neng gou chu li ling yi zhan dian shang de hou xu huo dong 。 gai pei zhi ke bi mian gong xiang ci pan zhen lie fa sheng gu zhang de feng xian , zhe jiang zu zhi biao zhun qun ji pei zhi fa hui zuo yong 。
  dui deng fu zhi
  “ dui deng fu zhi ” shi duo ge shu ju ku neng gou xiang hu fu zhi 。 ke yi dui ren he shu ju ku zhi xing geng gai , er qie neng yi jie jin shi shi de fang shi jiang zhe xie geng gai ying yong yu fu zhi tuo pu zhong de qi ta jie dian 。 ying yong cheng xu de she ji yao qiu shi , ru guo zhu ti fu wu qi bu ke yong , ying yong cheng xu bi xu neng gou lian jie tuo pu zhong de qi ta jie dian 。
  SQL Server 2008 qiang hua le dui deng fu zhi gong neng , ta ke zai fu zhi jie jue fang an zhong zeng jia jie dian , tong shi bao chi fu zhi liu cheng chu yu zai xian zhuang tai 。 zai jiu ban de SQL Server zhong , yao zeng jia xin jie dian , bi xu zai li xian zhuang tai xia zhi xing fu zhi liu cheng 。 ci wai ,SQL Server 2008 ke yi zhi jie li yong tu xing hua Topology Viewer dui dui deng fu zhi jin xing she zhi 、 jian du he guan li 。SQL Server 2008 huan yin jin le chong tu jian ce ji zhi , ke yi fang zhi duo ge fu zhi jie dian geng xin tong yi xing shi chan sheng de ou ran chong tu 。
  zai guan li pei xun gong si de an li zhong , dui deng fu zhi ke yi cong ben di fang wen zheng ge ding dan shu ju ku , ru guo ling yi zhan dian de shu ju ku bu ke yong , ze mei ge zhan dian dou ke yi yong yu gu zhang hui fu 。
  suo duan ting ji shi jian
  xi tong ting ji shi jian hui wei xie dao ren he qi ye de cheng gong 。 xi tong ting ji shi jian ke neng shi yi wai chan sheng de , ye ke neng shi wei wei hu ren wu er yu xian an pai de , li ru chong jian suo yin huo zhi xing ying yong cheng xu huo xi tong sheng ji 。
  yao shi xi tong bi mian chan sheng yi wai ting ji hen kun nan , yin wei dui yu qi ye er yan , yi wai de ying jian huo wang luo gu zhang 、 ren wei shi wu 、 zi ran zai hai huo dao qie dou ke neng hui dai lai zai nan xing hou guo 。SQL Server Always On ti gong le ke cong ji hua wai ting ji zhuang tai zhong xun su hui fu de ji shu 。 ci wai , tong guo shi dang di shi shi Always On ji shu , ren wu guan jian xing ying yong cheng xu ping wen yun xing suo xu de xi tong wei hu he cao zuo liu cheng jiang shi ting ji shi jian jiang zhi zui di 。
  kuai su shu ju ku hui fu
  SQL Server 2008 Enterprise Edition Database Engine neng gou zai beng kui hui fu he shu ju ku jing xiang gu zhang zhuan yi qi jian ti gong kuai su hui fu 。 kuai su hui fu gong neng shi shu ju ku zai hui fu liu cheng de huan yuan jie duan ji ke shi yong , ta zai huan yuan cao zuo qi jian 、 shu ju ku ye xiao yan yi ji bei fen mei ti jing xiang qi jian yun ke ti gong bu fen ke yong xing 。 tong guo zhi chi kuai su hui fu ,SQL Server 2008 jiang zai zui duan de shi jian nei shi shu ju ku chu yu zai xian zhuang tai , yin ci yong hu hen kuai jiu neng shi yong shu ju ku , zhe yao kuai yu ru xia fang fa : deng zheng ge hui fu liu cheng quan bu wan cheng hou , yong hu he ying yong cheng xu cai ke yi zhi xing lian jie 。
  bei fen he huan yuan
  zai gao ke yong xing jie jue fang an zhong , bei fen zhi guan chong yao , ta yao ding qi ti gong shu ju kuai zhao , bing zai chu xian da fan wei gu zhang huo que shao qi ta gao ke yong xing jie jue fang an shi , zuo wei shu ju yuan yong yi huan yuan shu ju 。
  SQL Server de bei fen mei ti jing xiang gong neng shi yong hu neng gou jiang shu ju ku tong guo jing xiang bei fen fu zhi dao duo ge bei fen she bei shang , dang mei ti chu xian gu zhang huo bei fen she bei diu shi shi , zhe jiang ji da ti gao bei fen de ke kao xing 。SQL Server 2008 zhi chi zai ci pan he ci dai shang zhi xing jing xiang bei fen , dan suo yong de she bei bi xu lei si , yi bi mian chan sheng she bei bu pi pei cuo wu de feng xian 。 bei fen jing xiang ji zhong de suo you she bei zai bei fen guo cheng zhong dou bi xu ke yong , dan shu ju ku ke cong jing xiang ji zhong de ren he dan du bei fen zhong huan yuan 。 yao li yong Transact-SQL zhi xing jing xiang bei fen , bi xu shi yong BACKUP ming ling de MIRROR TO zi ju , ru xia li suo shi 。
  BACKUP DATABASE AdventureWorks
  TO TAPE = '\.\tape0', TAPE = '\.\tape1'
  MIRROR TO TAPE = '\.\tape2', TAPE = '\.\tape3'
  WITH
   FORMAT,
   MEDIANAME = 'AdventureWorksSet1';
  GO
  SQL Server de ling yi ge bei fen ke kao xing te xing shi , zai bei fen cao zuo qi jian ke yi sheng cheng xiao yan he , ran hou xiao yan he ke yong yu yan zheng huan yuan hou de shu ju ku 。
  SQL Server 2008 zhi chi bei fen ya suo , zui duo ke shi bei fen da xiao jian xiao 50%。 rong liang de jian xiao shi yong hu neng gou geng pin fan di bei fen shu ju , tong shi ye hui suo duan huan yuan shi jian 。 zai BACKUP ming ling zhong , bei fen ya suo ke she wei ON huo OFF, bing qie ke yi li yong sp_configure ding yi mo ren de ya suo zhi (on huo off), yi que ding zai zhi xing BACKUP ming ling shi , shi fou xu yao zhi ding ya suo xuan xiang 。
  shu ju ye shang de xiao yan he
  “ xiao yan he ” ke bi jiao xie ru ci pan de zhi yu hou xu du qu de zhi 。 ru guo zhe xie zhi bu yi zhi , ze gai ye jiang bei biao ji wei suspect( ke yi ), ran hou yao me shou dong huan yuan , yao me li yong SQL Server 2008 zi dong cong huo ban fu wu qi zhong huan yuan 。
  zai xian suo yin cao zuo
  ke yong xing hui shou dao biao zhun wei hu cao zuo yi ji gu zhang de ying xiang 。 zai zao qi SQL Server ban ben zhong , suo yin wei hu hui shi shou ying xiang de shu ju bian wei bu ke yong , dan cong SQL Server 2005 kai shi , shu ju zai “ zai xian suo yin cao zuo ” qi jian yun ke bao chi ke yong xing , zhe xie ke yong de cao zuo bao kuo chuang jian 、 fang zhi huo chong jian suo yin 。
  zai zhi xing suo yin wei hu shi ,“ zai xian suo yin cao zuo ” ke ti gao suo you xi tong de ke yong xing , yin ci ye neng ti gao zhi yuan de gong zuo xiao lv , bing gai shan ke hu shi yong xi tong shi de ti yan 。
  zai xian 、 duan luo he ye ji huan yuan
  SQL Server 2008 Enterprise Edition zhi chi “ zai xian huan yuan ”, shi yong hu neng gou fang wen shu ju ku bei huan yuan de bu fen , ji shi shu ju ku de qi ta bu fen huan bu ke yong , yin ci zhe hui ti gao hui fu su du 、 suo duan ting ji shi jian he ti gao ke yong xing 。 ci wai , ke yi li yong “ duan luo huan yuan ” ce lue huan yuan ge jie duan de shu ju ku 。 li ru , ke yi huan yuan bao han dang qian huo dong shu ju de wen jian zu , bing qie ke xian shi shu ju ku chu yu zai xian zhuang tai , ran hou huan yuan bao han jiao jiu de gui dang shu ju de wen jian zu 。 zai zai nan hui fu ying yong chang jing xia , duan luo huan yuan ce lue ke suo duan ren wu guan jian xing ying yong cheng xu chu yu li xian zhuang tai de shi jian 。
  you yu shao liang shu ju ye fa sheng sun huai er xu yao hui fu shu ju ku shi ,SQL Server 2008 zhi chi ye ji huan yuan cao zuo 。 yong hu ke cong xu duo yuan shu ju ku de ke yi ye zhong shi bie ye ID, bao kuo msdb shu ju ku zhong de suspect_pages biao 、SQL Server cuo wu ri zhi yi ji DBCC CHECKDB ming ling 。 shi bie chu ren he you ke neng sun huai de shu ju ye zhi hou , jiu ke yi zai RESTORE yu ju de PAGE cong ju zhong zhi ding ye ID, cong er huan yuan shu ju ye 。 cong bei fen zhong huan yuan dan zhang ye de neng li ji da di suo duan you yu shu ju ku sun huai dao zhi de ting ji shi jian 。
  bu fen shu ju ke yong xing
  you le “ bu fen shu ju ke yong xing ” gong neng , ji shi shu ju ku de yi bu fen you yu ge li ying jian huo ci pan gu zhang er zao po huai , shu ju ku ye neng wei chi zai xian zhuang tai he ke yong xing 。 ru guo fu zhu de fei zhu yao shu ju wen jian sun huai , ze shu ju ku wei sun huai de bu fen reng jiang bao chi zai xian zhuang tai he ke yong xing 。 yin ci , ji shi zheng ge xi tong bu ke yong , dan you xie ke hu he zhi yuan reng ke fang wen shu ju , zhe hui jian qing you wen ti dao zhi de hou guo , tong shi ling yi ge ke yong xing jie jue fang an jiang jin ru zai xian zhuang tai 。
  kuai zhao ge li
  zai SQL Server de zao qi ban ben zhong xiu gai shu ju shi , bei xiu gai de shu ju jiang chu yu suo ding zhuang tai , yin ci qi ta ying yong cheng xu he yong hu jiu wu fa shi yong zhe xie shu ju 。 ti dai fang fa shi du qu shu ju de dang qian zhuang tai ( ji shi zhe xie zhi shang wei bei ti jiao ) huo zhe dang jiao yi wei cheng gong wan cheng shi hui gun shu ju 。
  “ kuai zhao ge li ” gong neng kuo zhan le SQL Server 2008 zhong de suo ding kuang jia , ta shi ying yong cheng xu neng gou zai fa sheng ren he shu ju xiu gai zhi qian cha kan zhi 。 zhe ke fang zhi ying yong cheng xu bei suo ding , tong shi reng jiang ti gong zhen zheng yi ti jiao de shu ju 。 li ru , zai ben wen kai tou jie shao de wan ju zhi zao shang an li zhong ,“ kuai zhao ge li ” gong neng shi bao gao neng gou yun xing , bing ti gong jing que de jiao yi jie guo 。“ kuai zhao ge li ” shi bao gao geng ji shi 、 geng jing que 。
  dong tai pei zhi
  “ dong tai pei zhi ” shi SQL Server Always On ji shu zhi yi , li yong gai ji shu ke yi geng hao di fang wen ying jian te xing , ru zhi xing re sheng ji , tong shi xi tong reng ke yun xing 。 ru guo ying jian zhi chi “ re tian jia nei cun ”, ze zai zeng jia xi tong nei cun shi jiu bu hui chan sheng zhong duan , er qie SQL Server jiang tong guo dong tai nei cun huo zhe gu zhang yi dong qun ji de dong tai
  “ di zhi chuang kou hua kuo zhan cha jian (AWE)” zi dong shi yong zhe xie nei cun 。
  SQL Server 2008 huan zhi chi “ re tian jia CPU”, yin ci ke wei shou zhi chi de ying jian tian jia chu li qi , er qie bu hui shi cao zuo zhong duan 。
  dui yu ren he xu yao zeng jia chu li qi huo nei cun zi yuan de xi tong er yan ,“ dong tai pei zhi ” gong neng ke suo duan ting ji shi jian , bing ti gao zhi yuan gong zuo xiao lv he ke hu man yi du 。
  zeng qiang de ke guan li xing
  SQL Server 2008 zhen dui jian hua hui fu cao zuo ti gong le qiang da qie gao xiao de guan li gong ju , ta ti gong le yong yu tiao cha 、 jian du yi ji hui fu qi ye zhong shou sun shu ju de ge zhong gong ju 。
  shu ju ku kuai zhao
  wu lun shi you wei hu cao zuo huan shi you zhong duan yong hu jiao hu dao zhi , ren wei shi wu shi dao zhi ting ji de zui chang jian yuan yin 。SQL Server Always On ti gong le “ shu ju ku kuai zhao ” gong neng , ke yong yu kuai su tiao cha ren wei shi wu bing cong zhi hui fu 。“ shu ju ku kuai zhao ” jiu shi chuang jian kuai zhao shi shu ju ku de zhi du 、 jing tai shi tu 。“ shu ju ku kuai zhao ” ye ke yong yu bian zhi bao gao , er qie bu ying xiang yuan shu ju ku de ke yong xing 。
  zai fang di chan gong si de ying yong chang jing zhong ,“ shu ju ku kuai zhao ” ti gong le yi zhong jiang dang qian zhi xiang qian yi tian hui gun de fang fa , huan wei qian yi tian de shu ju ti gong le zhi du de bao gao jie jue fang an 。 you yu “ shu ju ku kuai zhao ” jin cun chu jiang ying yong yu huo dong shu ju ku de geng gai shu ju , yin ci ta men hen jie sheng cun chu kong jian 。
  biao he suo yin fen qu
  “ biao he suo yin fen qu ” gong neng ke ti gao da biao de ke yong xing he ke guan li xing , ta jiang da biao hua fen wei jiao xiao de 、 geng yi guan li de dan yuan , zhe zhong dan yuan cheng wei “ fen qu ”。 ke yi du li fang wen ge ge fen qu , yin ci jian qing le I/O mi ji huo dong chan sheng de ying xiang , ru shu ju jia zai 、 bei fen he huan yuan 、 suo yin chong jian yi ji suo yin sui pian zheng li 。
  SQL Server 2008 shi xing suo shu he ye suo shu sheng ji wei fen qu suo shu , yin ci ti gao le fen qu biao de bing xing xing 。 zhe zhong sheng ji jian shao le ying yong de suo shu , yin ci jia kuai le kua yue cha xun 。 zai jiu ban ben zhong , xing suo shu he ye suo shu zhi neng sheng ji wei biao suo shu , zhe hui dao zhi ying yong bu bi yao de da suo , er qie hui fang ai qi ta yong hu 。
  dui yu bao han da biao he da liang yong hu de ren he xi tong er yan , ti gao bing xing xing bing jian shao jing zheng ke gai shan ke yong xing , er qie neng gou ti gao zhi yuan gong zuo xiao lv he ke hu man yi du 。
  bei fen he huan yuan
  chu le “ duan luo huan yuan ” he “ zai xian huan yuan ” ji shu wai , bei fen he huan yuan cao zuo huan zai hui fu fang mian ti gong le geng duo ling huo xing 。SQL Server shi yong hu neng gou huan yuan zhi du shu ju ku wen jian zu , er qie wu xu ying yong shi wu ri zhi 。 ta huan yuan xu tong shi zhi xing shu ju ku bei fen he shi wu ri zhi bei fen 。
  zhuan yong guan li yuan lian jie
  “ zhuan yong guan li yuan lian jie (DAC)” shi yi zhong yu fu wu qi zhi jian de gao you xian ji lian jie , dang fu wu qi si hu yao ting ji yi ji bu jie shou xin lian jie shi , ta you zhu yu pai chu gu zhang 。
  zi yuan tiao kong qi
  zai shi yong pin fan de shu ju ku zhong , bu tong de gong zuo fu he ke neng hui wei le ke yong de xi tong zi yuan er zhan kai jing zheng , li ru CPU xian cheng he nei cun 。 zai mou xie qing xing xia , zhe zhong zi yuan jing zheng ke neng hui shi ren wu guan jian xing gong zuo fu he shou dao shu ju ku zhong qi ta huo dong de bu liang ying xiang 。SQL Server 2008 ti gong “ zi yuan tiao kong qi ”, ta gen ju deng lu 、 ying yong cheng xu he qi ta yin su , wei bu tong de gong zuo fu he zhi ding you xian ji , cong er neng gou zhu dong guan li gong zuo fu he zi yuan li yong qing kuang 。 wei gong zuo fu he zhi ding you xian ji de neng li shi xing neng geng ju ke yu ce xing , you zhu yu que bao ren wu guan jian xing ying yong cheng xu zong you shu ju ku fu wu qi zi yuan ke yi shi yong 。
  jie shu yu
  dang ke hu huo zhi yuan wu fa shi yong qi ye zhong de ren he guan jian xi tong shi , zhe dou hui li ji ying xiang dao qi ye de li run lv 。 ke yong xing wen ti he xu qiu qian cha wan bie , yi zhong jie jue fang an wu fa jie jue suo you de wen ti 。
  SQL Server 2008 ti gong le duo zhong jie jue fang an yi gai shan ke yong xing , zhe zhong ke yong xing zhi shao zai xing neng he duo yang xing fang mian neng gou bi mei zhu liu shu ju ku chang shang ti gong de ren he lei si chan pin , er qie SQL Server 2008 ji xu zai ke guan li xing he zi jin jia zhi fang mian ju yu ling xian di wei 。
  huo qu geng duo xin xi :
http://www.microsoft.com/sql
  ben wen dui nin you bang zhu ma ? qing gao su wo men nin de gan shou 。 ru guo cong 1( cha ) dao 5( ji hao ) de fen zhi zhong jin xing xuan ze , nin ren wei ben wen ying gai da ji fen ? yuan yin shi shen me ? li ru :
  nin shi fou ren wei you yu ti gong le hen hao de li zi 、 jing mei de ping mu jie tu 、 qing xi de wen zi miao shu huo qi ta yuan yin er ying gai gei ta gao fen ?
  nin shi fou ren wei you yu yong li bu dang 、 ping mu jie tu mo hu 、 wen zi miao shu han hun bu qing er ying gai gei ta di fen ?
  nin de yi jian jiang you zhu yu wo men gai shan suo fa bu bai pi shu de zhi liang 。 ti jiao yi jian 。【原文】【汉音对照
 
 
 
 
 
 
 
 
日版宠物情人插曲《Winding Road》歌词

日版宠物情人2017的插曲,很带节奏感,日语的,女生唱的。 最后听见是在第8集的时候女主手割伤了,然后男主用嘴帮她吸了一下,插曲就出来了。 歌手:Def...

兄弟共妻,我成了他们夜里的美食

老钟家的两个儿子很特别,就是跟其他的人不太一样,魔一般的执着。兄弟俩都到了要结婚的年龄了,不管自家老爹怎么磨破嘴皮子,兄弟俩说不娶就不娶,老父母为兄弟两操碎了心...

如何磨出破洞牛仔裤?牛仔裤怎么剪破洞?

把牛仔裤磨出有线的破洞 1、具体工具就是磨脚石,下面垫一个硬物,然后用磨脚石一直磨一直磨,到把那块磨薄了,用手撕开就好了。出来的洞啊很自然的。需要猫须的话调几...

我就是扫描下图得到了敬业福和爱国福

先来看下敬业福和爱国福 今年春节,支付宝再次推出了“五福红包”活动,表示要“把欠大家的敬业福都还给大家”。 今天该活动正式启动,和去年一样,需要收集“五福”...

冰箱异味产生的原因和臭味去除的方法

有时候我们打开冰箱就会闻到一股异味,冰箱里的这种异味是因为一些物质发出的气味的混合体,闻起来让人恶心。 产生这些异味的主要原因有以下几点。 1、很多人有这种习...

 
 
gao ke yong xing —Always On ji shu SQL Server ji shu wen zhang zuo zhe : Geoff Allix ( nei rong zhu guan ) ji shu shen cha : Michael Raheem xiang mu bian ji :Joanne Hodgins fa bu ri qi :2007 nian 11 yue shi yong chan pin :SQL Server 2008 zhai yao :Microsoft® SQL Server® 2008 tong guo ti gong ge zhong gao ke yong xing jie jue fang an , suo duan le ye wu guan jian xing shu ju ku de ting ji shi jian 。 zhe xie jie jue fang an shi yong hu he qi ye zhi yuan mei tian 24 xiao shi 、 mei zhou 7 tian dou ke yi fang wen shu ju , qie reng neng ti gong jing ji you xiao de gao xing neng 。SQL Server 2008 zhong de Always On gong neng zeng qiang le dui xi tong he ying jian de bao hu , jian shao le ji hua zhong huo ji hua wai ting ji de ci shu he hui fu shi jian , bing jian shao le you yu da liang yong hu tong shi fang wen tong yi shu ju ku er dao zhi de chong tu 。 ban quan zhe shi yi fen yu bei wen dang , zai ben wen dang zhong suo shu ruan jian de zui zhong shang ye ban ben fa bu zhi qian , gai wen dang de nei rong ke neng hui fa sheng chong da bian hua 。 ben wen dang zhong ti gong de xin xi dai biao le Microsoft Corporation dang qian ( ruan jian fa bu zhi qian ) dui suo tao lun wen ti chi you de guan dian 。 yin wei Microsoft bi xu xiang ying bu duan bian hua de shi chang tiao jian , suo yi qi dang qian de guan dian bu ying bei jie shi wei shi yi zhong cheng nuo , ruan jian fa bu zhi hou ,Microsoft bu neng bao zheng xian zai suo ti gong de suo you xin xi zhun que wu wu 。 zhe fen bai pi shu jin gong shen kao 。 Microsoft dui ben wen dang zhong ti gong de xin xi bu zuo ren he dan bao 、 ming shi 、 an shi huo fa lv fang mian de cheng nuo 。 yong hu you ze ren zun shou suo you shi yong de ban quan fa 。 zai ban quan quan li xian zhi xia , wei jing Microsoft gong si ming que de shu mian xu ke , ben wen dang de ren he nei rong bu neng bei fu zhi 、 cun chu huo fang jin jian suo xi tong , huo zhe yi ren he xing shi huo ren he shou duan ( dian zi 、 ji xie 、 fu yin 、 lu zhi huo qi ta ) huo wei da dao ren he mu de jin xing zhuan huan 。 Microsoft dui ben wen han gai de zhu ti nei rong ke neng yong you zhuan li 、 zhuan li shen qing 、 shang biao 、 ban quan huo qi ta zhi shi chan quan 。 mei you lai zi Microsoft de ren he shu mian xu ke xie yi de ming que biao shi , ben wen bu fu yu nin dui zhe xie zhuan li 、 shang biao 、 ban quan huo qi ta zhi shi chan quan de ren he xu ke 。 chu fei ling you shuo ming , fou ze ben wen ti ji de shi li gong si 、 zu zhi 、 chan pin 、 yu ming 、 dian zi you jian di zhi 、 hui biao 、 ren wu 、 di dian he shi jian jie shu xu gou , yu ren he zhen shi de gong si 、 zu zhi 、 chan pin 、 yu ming 、 dian zi you jian di zhi 、 hui biao 、 ge ren 、 di dian huo shi jian wu guan 。 Ó 2007 Microsoft Corporation。 bao liu suo you quan li 。 Microsoft、Windows、Office he SQL Server shi Microsoft Corporation zai mei guo he / huo qi ta guo jia / di qu de shang biao huo zhu ce shang biao 。 ben wen zhong ti ji de zhen shi de gong si ming cheng he chan pin ming cheng ke neng shi qi ge zi suo you zhe de shang biao 。 mu lu jian jie 1 ke yong xing ying yong chang jing 1 ti gao ke yong xing 2 shu ju ku jing xiang 2 ri zhi chuan song 2 gu zhang zhuan yi qun ji 3 di li fen san gu zhang zhuan yi qun ji 3 dui deng fu zhi 3 suo duan ting ji shi jian 4 kuai su shu ju ku hui fu 4 bei fen he huan yuan 4 shu ju ye shang de xiao yan he 5 zai xian suo yin cao zuo 5 zai xian 、 duan luo he ye ji huan yuan 5 bu fen shu ju ke yong xing 6 kuai zhao ge li 6 dong tai pei zhi 6 zeng qiang de ke guan li xing 6 shu ju ku kuai zhao 6 biao he suo yin fen qu 7 bei fen he huan yuan 7 zhuan yong guan li yuan lian jie 7 zi yuan tiao kong qi 7 jie shu yu 7 dao yan ren he ying yong cheng xu de ting ji shi jian dou hui gei qi ye dai lai fu mian ying xiang , dao zhi shou ru sun shi 、 ke hu man yi du xia jiang bing sun hai qi ye de xin yu 。 xu duo shu ju ku ying yong cheng xu , you qi shi qi ye ye wu ying yong cheng xu , yao qiu xi tong ting ji shi jian jin ke neng suo duan 。 xi tong ting ji shi jian de chan sheng you duo zhong yuan yin , ru ren wei shi wu 、 zi ran zai hai 、 ying jian huo ruan jian gu zhang yi ji ying yong cheng xu sheng ji 。Microsoft SQL Server 2008 Always On ji shu ti gong le ge zhong xuan xiang , ke jiang ting ji shi jian jiang zhi zui di , qie bao chi shi dang ji bie de ying yong cheng xu ke yong xing 。 ke yong xing ying yong chang jing dui xu duo ye wu er yan , huo de gao ke yong xing shi yi zhong chang jian xu qiu 。 jie jue fang an shi fou shi yong yu te ding de ying yong chang jing qu jue yu hen duo yin su , zai yi zhong chang he xia biao xian zui jia de jie jue fang an zai ling yi zhong chang he xia bu yi ding shi zui shi he de 。 li ru ru xia ying yong chang jing : ji yu Internet de yun dong shang pin ling shou shang xiang wei qi ke hu ti gong jin si lian xu de ke yong xing 。Web fu wu qi yi jia dao Web chang zhong , dan shu ju ku gu zhang hui chan sheng cuo wu , zhe xie qing xing da duo shu shi hou hui shi gong si shi qu ke hu 。 gai gong si yi jing yong you jing gai zhun de biao zhun fu wu qi ban ben , xi wang neng gou bi mian hua fei da liang zi jin 、 geng gai ji chu jie gou huo chong xie ying yong cheng xu 。 lie tou gong si hen guan zhu qi yong hu shi yong ke hu shu ju ku shi yu dao de cuo wu 。 sui ran mei you bi yao li ji zhi xing gu zhang hui fu , dan gai gong si huan shi xi wang yong you yi tai ke yi kuai su zai xian huo de de wen bei yong fu wu qi 。 bao xian gong si xiang wei qi suo pei shu ju ku ti gong jin si lian xu de ke yong xing 。 gai xi tong de xing neng yi ding bu neng shou dao ying xiang , er qie dang qian cun chu zai wen jian xi tong zhong yong yi zhi chi suo pei de wen dang ye bi xu ke yong 。 guan li pei xun gong si you san ge zhan dian , mei ge zhan dian dou you yi zhi xiao shou tuan dui 。 xiao shou tuan dui jiang ge zi zhan dian de ji lu shu ru Orders shu ju ku zhong 。 wei ti gao xing neng , yao qiu mei ge zhan dian neng gou zai ben di fu wu qi shang fang wen gong si de suo you ding dan 。 dang chu xian gu zhang shi , wei ti gong ke yong xing , mei ge zhan dian dou bi xu neng gou qie huan dao ling yi ge zhan dian de fu wu qi 。 hui ji gong si xi wang zai chu xian gu zhang shi ( ru zi ran zai hai ) ye neng wei qi ke hu ti gong ke yong xing 。 xin xi bu yi ding yao li ji ke yong , dan ying gai zai shu xiao shi er bu shi shu tian nei ke gong shi yong 。 gai gong si huan xiang mei tian dou bao cun shu ju ku zhong de xin xi , yi man zu fa gui yao qiu 。 kao bei de shu ju bu xu yao li ji ke yong , dan bi xu zai xu duo nian nei dou ke gong shi yong 。 wan ju zhi zao shang xiang gen ju xiao shou shu ju ku bian zhi bao gao , dan you yu gai shu ju ku yi zhi chu yu shi yong zhuang tai , yin ci bian zhi bao gao de guo cheng tong chang hui bei dang qian zheng zai zhi xing de jiao yi da duan 。 gai gong si xi wang neng gou zhen dui wei ti jiao de jiao yi bian zhi bao gao , dan zhe hui chan sheng bu zheng que de jie guo , yin wei you xie jiao yi bing bu wan zheng 。 fang di chan gong si xiang zai yong hu cao zuo cuo wu shi bao hu xi tong , xi wang neng gou hui fu qian yi tian de ji lu zhi 。 gai gong si huan xiang neng gou gen ju qian yi tian de shu ju bian zhi bao gao , yin wei ta men bu hui shou dao dang tian jiao yi de ying xiang 。 zai li xiang qing kuang xia , gai gong si xi wang shi shi yi zhong ci pan kai xiao zui xiao de jie jue fang an 。 gen ju ge zhong ke yong xing yao qiu , qi ye xu yao yi zhong neng wei gao ke yong xing jie jue fang an ti gong ling huo xuan xiang de shu ju ku ping tai 。 ben bai pi shu zhong , ke yi kan dao SQL Server 2008 Always On ji shu ru he wei gao ke yong xing ti gong ling huo xuan xiang , yi shi qi ye neng gou gen ju te shu xu qiu shi shi zui jia jie jue fang an 。 ti gao ke yong xing xu duo shu ju ku ying yong cheng xu dou shi ren wu guan jian xing de , yin ci yao qiu ting ji shi jian jin ke neng duan , bing zai fa sheng zai nan shi neng gou xun su hui fu 。SQL Server 2008 ti gong le ge zhong Always On ji shu , ke yi shi ting ji shi jian jian zhi zui shao ji huo de shi dang ji bie de ke yong xing 。 shu ju ku jing xiang “Database Mirroring( shu ju ku jing xiang )” shi yi zhong ke ti gao shu ju ku ke yong xing de ji shu 。 dang zhu ti shu ju ku fa sheng geng gai shi , zhe xie geng gai ye jiang zi dong ying yong dao jing xiang shu ju ku zhong 。 dang zhu ti fu wu qi fa sheng gu zhang shi , ke hu ji ying yong cheng xu ke zi dong chong ding xiang dao jing xiang fu wu qi , er ying yong cheng xu wu xu jin xing ren he gai dong 。 ke yi dui Database Mirroring jin xing pei zhi , yi dui jing xiang fu wu qi shi shi ying yong geng gai , cheng wei “ tong bu ”; huo zhe jin hu shi shi ying yong geng gai , cheng wei “ yi bu ”, yin ci ke yi zai xi tong zhong zhi ding bao hu ji bie he xing neng kai xiao 。 you le SQL Server 2008 Enterprise Edition zhi hou , jing xiang bao hu jiu ke kuo zhan dao shu ju ye 。 ru guo fa xian zhu ti fu wu qi huo jing xiang fu wu qi shang de shu ju ye sun huai , jiang cong huo ban fu wu qi shang jian suo dui ying de shu ju ye , er shu ju cao zuo ye hui ping wen di ji xu zhi xing 。SQL Server 2008 huan gai shan le shu ju ku jing xiang , ta jiang ya suo zhu ti fu wu qi yu jing xiang fu wu qi zhi jian de shu ju liu , er qie zai shou dong zhi xing gu zhang hui fu shi , wu xu chong qi shu ju ku 。 zai ji yu Internet de yun dong shang pin gong si de an li zhong , dang chu xian fu wu qi 、 shu ju ku huo ye ji gu zhang shi ,Database Mirroring jiang ti gong fei chang xun su de gu zhang hui fu neng li 。 sui ran bi xu gou mai xin fu wu qi , dan wu xu chong xie ying yong cheng xu , bei yong fu wu qi shi biao zhun she bei , bu xu yao SQL Server xu ke zheng 。 ri zhi chuan song “ ri zhi chuan song ” shi yi zhong gao ke yong xing ji shu , ta ti gong le wen bei yong fu wu qi 。 bei fen shi zai zhu fu wu qi shang zhi xing de , er huan yuan shi zai yi ge huo duo ge fu zhu fu wu qi shang zhi xing de 。 ran hou ,“ ri zhi chuan song ” jiang ding qi ri zhi bei fen ying yong yu fu zhu fu wu qi 。 sui ran shu ju ku jing xiang zhi neng you yi tai jing xiang fu wu qi , dan “ ri zhi chuan song ” ke yi you xu duo fu zhu fu wu qi , zhe ke yi ti gao bao hu ji bie 。 “ ri zhi chuan song ” shi an zhao shi jian biao zhi xing de , yin ci zai zhu fu wu qi shang de shu ju geng gai yu zhe xie geng gai chuan shu dao fu zhu fu wu qi shang zhi jian you shi jian yan chi 。 zhe zhong yan chi hui dao zhi shu ju sun shi , dan zai xu duo ying yong chang jing xia , zhe xie yan chi ke yong zuo huan yuan yong hu cuo wu de yi zhong fang fa , yin wei ke yi yan chi ri zhi shu ju zai fu zhu fu wu qi shang de ying yong ( cong er bao liu fu zhu fu wu qi shang de yuan shi shu ju )。 wei jiang di zhu fu wu qi de gong zuo fu he , fu zhu fu wu qi ke yong zuo zhi du bao gao fu wu qi , dan zai ying yong ri zhi bei fen shi wu fa yun xing bao gao 。 zai lie tou gong si de an li zhong , ke li yong ri zhi bei fen yu bei yong fu wu qi zhi xing huan yuan zhi jian de yan chi ying yong “ ri zhi chuan song ”。 zhe ke yi niu zhuan you yong hu dao zhi de cuo wu qing xing , yin wei ru guo zhu fu wu qi fa sheng gu zhang , ke yi zhi jie ying yong ri zhi yi jian shao shu ju sun shi 。 gu zhang zhuan yi qun ji “ gu zhang zhuan yi qun ji ” shi yi zhong Windows gong neng , ke dui zheng ge fu wu qi ti gong bao hu , er bu zhi shi bao hu shu ju ku 。 duo tai fu wu qi ( cheng wei “ jie dian ”) gong xiang ci pan zhen lie , yin ci ru guo yi ge jie dian fa sheng gu zhang , ze ke zai ji qun zhong de ling yi ge jie dian shang qi dong ta de fu wu 。 gai jie jue fang an ke yi fang zhi ren he shu ju sun shi , bing ti gong zi dong de ke hu ji chong ding xiang fu wu , dan cong zhu fu wu qi dao fu zhu fu wu qi de gu zhang hui fu cao zuo mei you shu ju ku jing xiang na yang kuai , er qie xu yao zhuan men de ying jian 。 Windows Server 2008 kuo zhan le jiu ban Windows de qun ji gong neng , ta jiang di le dui ying jian he ji chu jie gou de yao qiu , qie zai yi ge qun ji zhong zhi chi 16 ge jie dian 。 ci wai , you yu bu yao qiu suo you jie dian dou zhu liu yu tong yi ge zi wang zhong bing zhi chi OR yi lai guan xi ( li ru , dang liang ge IP di zhi zi yuan zhong de ren he yi ge ke yong shi , ke que bao wang luo ming zi yuan ye ke yong ), yin er qiang hua le qun ji gong neng 。 cong zong ti shang jiang , zai Windows Server 2008 zhong ke yi geng rong yi di she zhi he guan li qun ji , er yin jin de qun ji yan zheng gong ju you zhu yu que bao qun ji jie jue fang an you zu gou de ying jian zi yuan 。 tong guo li yong Windows Server 2008 zhong de qun ji zeng qiang gong neng ,SQL Server 2008 wei zheng ge SQL Server shi li ti gong le jian zhuang de gao ke yong xing jie jue fang an 。SQL Server 2008 huan gai shan le jiu ban de qun ji gong neng , ta bu yao qiu mei ge SQL Server shi li dou yao you yi ge pan fu , zhe ti gao le qun ji jie jue fang an ke yi zhi chi de shi li shu liang 。 zai bao xian gong si an li zhong ,“ gu zhang zhuan yi qun ji ” ke yong yu ti gong jin si lian xu de ke yong xing 。“ gu zhang zhuan yi qun ji ” bu hui ying xiang xi tong xing neng , yin wei ta shi yi zhong fu wu qi ji jie jue fang an , neng gou wei fu wu qi shang de qi ta zi yuan ti gong ke yong xing 。 ru guo dan xin gong xiang ci pan zhen lie bu neng ti gong zu gou de rong yu , ze ke shi yong “ di li fen san qun ji ”。 di li fen san gu zhang zhuan yi qun ji “ di li fen san gu zhang zhuan yi qun ji ” an zhao ren zheng de Microsoft Geographically Dispersed Cluster Services pei zhi ti gong fu wu qi ji rong yu , gai pei zhi yao qiu mei ge zhan dian yong you yi ge huo duo ge cun chu zhen lie 。 ru guo zhan dian 、 fu wu qi jie dian huo ci pan fa sheng gu zhang , xi tong he ci pan de wan zheng rong yu jiang shi gu zhang zhuan yi qun ji neng gou chu li ling yi zhan dian shang de hou xu huo dong 。 gai pei zhi ke bi mian gong xiang ci pan zhen lie fa sheng gu zhang de feng xian , zhe jiang zu zhi biao zhun qun ji pei zhi fa hui zuo yong 。 dui deng fu zhi “ dui deng fu zhi ” shi duo ge shu ju ku neng gou xiang hu fu zhi 。 ke yi dui ren he shu ju ku zhi xing geng gai , er qie neng yi jie jin shi shi de fang shi jiang zhe xie geng gai ying yong yu fu zhi tuo pu zhong de qi ta jie dian 。 ying yong cheng xu de she ji yao qiu shi , ru guo zhu ti fu wu qi bu ke yong , ying yong cheng xu bi xu neng gou lian jie tuo pu zhong de qi ta jie dian 。 SQL Server 2008 qiang hua le dui deng fu zhi gong neng , ta ke zai fu zhi jie jue fang an zhong zeng jia jie dian , tong shi bao chi fu zhi liu cheng chu yu zai xian zhuang tai 。 zai jiu ban de SQL Server zhong , yao zeng jia xin jie dian , bi xu zai li xian zhuang tai xia zhi xing fu zhi liu cheng 。 ci wai ,SQL Server 2008 ke yi zhi jie li yong tu xing hua Topology Viewer dui dui deng fu zhi jin xing she zhi 、 jian du he guan li 。SQL Server 2008 huan yin jin le chong tu jian ce ji zhi , ke yi fang zhi duo ge fu zhi jie dian geng xin tong yi xing shi chan sheng de ou ran chong tu 。 zai guan li pei xun gong si de an li zhong , dui deng fu zhi ke yi cong ben di fang wen zheng ge ding dan shu ju ku , ru guo ling yi zhan dian de shu ju ku bu ke yong , ze mei ge zhan dian dou ke yi yong yu gu zhang hui fu 。 suo duan ting ji shi jian xi tong ting ji shi jian hui wei xie dao ren he qi ye de cheng gong 。 xi tong ting ji shi jian ke neng shi yi wai chan sheng de , ye ke neng shi wei wei hu ren wu er yu xian an pai de , li ru chong jian suo yin huo zhi xing ying yong cheng xu huo xi tong sheng ji 。 yao shi xi tong bi mian chan sheng yi wai ting ji hen kun nan , yin wei dui yu qi ye er yan , yi wai de ying jian huo wang luo gu zhang 、 ren wei shi wu 、 zi ran zai hai huo dao qie dou ke neng hui dai lai zai nan xing hou guo 。SQL Server Always On ti gong le ke cong ji hua wai ting ji zhuang tai zhong xun su hui fu de ji shu 。 ci wai , tong guo shi dang di shi shi Always On ji shu , ren wu guan jian xing ying yong cheng xu ping wen yun xing suo xu de xi tong wei hu he cao zuo liu cheng jiang shi ting ji shi jian jiang zhi zui di 。 kuai su shu ju ku hui fu SQL Server 2008 Enterprise Edition Database Engine neng gou zai beng kui hui fu he shu ju ku jing xiang gu zhang zhuan yi qi jian ti gong kuai su hui fu 。 kuai su hui fu gong neng shi shu ju ku zai hui fu liu cheng de huan yuan jie duan ji ke shi yong , ta zai huan yuan cao zuo qi jian 、 shu ju ku ye xiao yan yi ji bei fen mei ti jing xiang qi jian yun ke ti gong bu fen ke yong xing 。 tong guo zhi chi kuai su hui fu ,SQL Server 2008 jiang zai zui duan de shi jian nei shi shu ju ku chu yu zai xian zhuang tai , yin ci yong hu hen kuai jiu neng shi yong shu ju ku , zhe yao kuai yu ru xia fang fa : deng zheng ge hui fu liu cheng quan bu wan cheng hou , yong hu he ying yong cheng xu cai ke yi zhi xing lian jie 。 bei fen he huan yuan zai gao ke yong xing jie jue fang an zhong , bei fen zhi guan chong yao , ta yao ding qi ti gong shu ju kuai zhao , bing zai chu xian da fan wei gu zhang huo que shao qi ta gao ke yong xing jie jue fang an shi , zuo wei shu ju yuan yong yi huan yuan shu ju 。 SQL Server de bei fen mei ti jing xiang gong neng shi yong hu neng gou jiang shu ju ku tong guo jing xiang bei fen fu zhi dao duo ge bei fen she bei shang , dang mei ti chu xian gu zhang huo bei fen she bei diu shi shi , zhe jiang ji da ti gao bei fen de ke kao xing 。SQL Server 2008 zhi chi zai ci pan he ci dai shang zhi xing jing xiang bei fen , dan suo yong de she bei bi xu lei si , yi bi mian chan sheng she bei bu pi pei cuo wu de feng xian 。 bei fen jing xiang ji zhong de suo you she bei zai bei fen guo cheng zhong dou bi xu ke yong , dan shu ju ku ke cong jing xiang ji zhong de ren he dan du bei fen zhong huan yuan 。 yao li yong Transact-SQL zhi xing jing xiang bei fen , bi xu shi yong BACKUP ming ling de MIRROR TO zi ju , ru xia li suo shi 。 BACKUP DATABASE AdventureWorks TO TAPE = '\.\tape0', TAPE = '\.\tape1' MIRROR TO TAPE = '\.\tape2', TAPE = '\.\tape3' WITH FORMAT, MEDIANAME = 'AdventureWorksSet1'; GO SQL Server de ling yi ge bei fen ke kao xing te xing shi , zai bei fen cao zuo qi jian ke yi sheng cheng xiao yan he , ran hou xiao yan he ke yong yu yan zheng huan yuan hou de shu ju ku 。 SQL Server 2008 zhi chi bei fen ya suo , zui duo ke shi bei fen da xiao jian xiao 50%。 rong liang de jian xiao shi yong hu neng gou geng pin fan di bei fen shu ju , tong shi ye hui suo duan huan yuan shi jian 。 zai BACKUP ming ling zhong , bei fen ya suo ke she wei ON huo OFF, bing qie ke yi li yong sp_configure ding yi mo ren de ya suo zhi (on huo off), yi que ding zai zhi xing BACKUP ming ling shi , shi fou xu yao zhi ding ya suo xuan xiang 。 shu ju ye shang de xiao yan he “ xiao yan he ” ke bi jiao xie ru ci pan de zhi yu hou xu du qu de zhi 。 ru guo zhe xie zhi bu yi zhi , ze gai ye jiang bei biao ji wei suspect( ke yi ), ran hou yao me shou dong huan yuan , yao me li yong SQL Server 2008 zi dong cong huo ban fu wu qi zhong huan yuan 。 zai xian suo yin cao zuo ke yong xing hui shou dao biao zhun wei hu cao zuo yi ji gu zhang de ying xiang 。 zai zao qi SQL Server ban ben zhong , suo yin wei hu hui shi shou ying xiang de shu ju bian wei bu ke yong , dan cong SQL Server 2005 kai shi , shu ju zai “ zai xian suo yin cao zuo ” qi jian yun ke bao chi ke yong xing , zhe xie ke yong de cao zuo bao kuo chuang jian 、 fang zhi huo chong jian suo yin 。 zai zhi xing suo yin wei hu shi ,“ zai xian suo yin cao zuo ” ke ti gao suo you xi tong de ke yong xing , yin ci ye neng ti gao zhi yuan de gong zuo xiao lv , bing gai shan ke hu shi yong xi tong shi de ti yan 。 zai xian 、 duan luo he ye ji huan yuan SQL Server 2008 Enterprise Edition zhi chi “ zai xian huan yuan ”, shi yong hu neng gou fang wen shu ju ku bei huan yuan de bu fen , ji shi shu ju ku de qi ta bu fen huan bu ke yong , yin ci zhe hui ti gao hui fu su du 、 suo duan ting ji shi jian he ti gao ke yong xing 。 ci wai , ke yi li yong “ duan luo huan yuan ” ce lue huan yuan ge jie duan de shu ju ku 。 li ru , ke yi huan yuan bao han dang qian huo dong shu ju de wen jian zu , bing qie ke xian shi shu ju ku chu yu zai xian zhuang tai , ran hou huan yuan bao han jiao jiu de gui dang shu ju de wen jian zu 。 zai zai nan hui fu ying yong chang jing xia , duan luo huan yuan ce lue ke suo duan ren wu guan jian xing ying yong cheng xu chu yu li xian zhuang tai de shi jian 。 you yu shao liang shu ju ye fa sheng sun huai er xu yao hui fu shu ju ku shi ,SQL Server 2008 zhi chi ye ji huan yuan cao zuo 。 yong hu ke cong xu duo yuan shu ju ku de ke yi ye zhong shi bie ye ID, bao kuo msdb shu ju ku zhong de suspect_pages biao 、SQL Server cuo wu ri zhi yi ji DBCC CHECKDB ming ling 。 shi bie chu ren he you ke neng sun huai de shu ju ye zhi hou , jiu ke yi zai RESTORE yu ju de PAGE cong ju zhong zhi ding ye ID, cong er huan yuan shu ju ye 。 cong bei fen zhong huan yuan dan zhang ye de neng li ji da di suo duan you yu shu ju ku sun huai dao zhi de ting ji shi jian 。 bu fen shu ju ke yong xing you le “ bu fen shu ju ke yong xing ” gong neng , ji shi shu ju ku de yi bu fen you yu ge li ying jian huo ci pan gu zhang er zao po huai , shu ju ku ye neng wei chi zai xian zhuang tai he ke yong xing 。 ru guo fu zhu de fei zhu yao shu ju wen jian sun huai , ze shu ju ku wei sun huai de bu fen reng jiang bao chi zai xian zhuang tai he ke yong xing 。 yin ci , ji shi zheng ge xi tong bu ke yong , dan you xie ke hu he zhi yuan reng ke fang wen shu ju , zhe hui jian qing you wen ti dao zhi de hou guo , tong shi ling yi ge ke yong xing jie jue fang an jiang jin ru zai xian zhuang tai 。 kuai zhao ge li zai SQL Server de zao qi ban ben zhong xiu gai shu ju shi , bei xiu gai de shu ju jiang chu yu suo ding zhuang tai , yin ci qi ta ying yong cheng xu he yong hu jiu wu fa shi yong zhe xie shu ju 。 ti dai fang fa shi du qu shu ju de dang qian zhuang tai ( ji shi zhe xie zhi shang wei bei ti jiao ) huo zhe dang jiao yi wei cheng gong wan cheng shi hui gun shu ju 。 “ kuai zhao ge li ” gong neng kuo zhan le SQL Server 2008 zhong de suo ding kuang jia , ta shi ying yong cheng xu neng gou zai fa sheng ren he shu ju xiu gai zhi qian cha kan zhi 。 zhe ke fang zhi ying yong cheng xu bei suo ding , tong shi reng jiang ti gong zhen zheng yi ti jiao de shu ju 。 li ru , zai ben wen kai tou jie shao de wan ju zhi zao shang an li zhong ,“ kuai zhao ge li ” gong neng shi bao gao neng gou yun xing , bing ti gong jing que de jiao yi jie guo 。“ kuai zhao ge li ” shi bao gao geng ji shi 、 geng jing que 。 dong tai pei zhi “ dong tai pei zhi ” shi SQL Server Always On ji shu zhi yi , li yong gai ji shu ke yi geng hao di fang wen ying jian te xing , ru zhi xing re sheng ji , tong shi xi tong reng ke yun xing 。 ru guo ying jian zhi chi “ re tian jia nei cun ”, ze zai zeng jia xi tong nei cun shi jiu bu hui chan sheng zhong duan , er qie SQL Server jiang tong guo dong tai nei cun huo zhe gu zhang yi dong qun ji de dong tai “ di zhi chuang kou hua kuo zhan cha jian (AWE)” zi dong shi yong zhe xie nei cun 。 SQL Server 2008 huan zhi chi “ re tian jia CPU”, yin ci ke wei shou zhi chi de ying jian tian jia chu li qi , er qie bu hui shi cao zuo zhong duan 。 dui yu ren he xu yao zeng jia chu li qi huo nei cun zi yuan de xi tong er yan ,“ dong tai pei zhi ” gong neng ke suo duan ting ji shi jian , bing ti gao zhi yuan gong zuo xiao lv he ke hu man yi du 。 zeng qiang de ke guan li xing SQL Server 2008 zhen dui jian hua hui fu cao zuo ti gong le qiang da qie gao xiao de guan li gong ju , ta ti gong le yong yu tiao cha 、 jian du yi ji hui fu qi ye zhong shou sun shu ju de ge zhong gong ju 。 shu ju ku kuai zhao wu lun shi you wei hu cao zuo huan shi you zhong duan yong hu jiao hu dao zhi , ren wei shi wu shi dao zhi ting ji de zui chang jian yuan yin 。SQL Server Always On ti gong le “ shu ju ku kuai zhao ” gong neng , ke yong yu kuai su tiao cha ren wei shi wu bing cong zhi hui fu 。“ shu ju ku kuai zhao ” jiu shi chuang jian kuai zhao shi shu ju ku de zhi du 、 jing tai shi tu 。“ shu ju ku kuai zhao ” ye ke yong yu bian zhi bao gao , er qie bu ying xiang yuan shu ju ku de ke yong xing 。 zai fang di chan gong si de ying yong chang jing zhong ,“ shu ju ku kuai zhao ” ti gong le yi zhong jiang dang qian zhi xiang qian yi tian hui gun de fang fa , huan wei qian yi tian de shu ju ti gong le zhi du de bao gao jie jue fang an 。 you yu “ shu ju ku kuai zhao ” jin cun chu jiang ying yong yu huo dong shu ju ku de geng gai shu ju , yin ci ta men hen jie sheng cun chu kong jian 。 biao he suo yin fen qu “ biao he suo yin fen qu ” gong neng ke ti gao da biao de ke yong xing he ke guan li xing , ta jiang da biao hua fen wei jiao xiao de 、 geng yi guan li de dan yuan , zhe zhong dan yuan cheng wei “ fen qu ”。 ke yi du li fang wen ge ge fen qu , yin ci jian qing le I/O mi ji huo dong chan sheng de ying xiang , ru shu ju jia zai 、 bei fen he huan yuan 、 suo yin chong jian yi ji suo yin sui pian zheng li 。 SQL Server 2008 shi xing suo shu he ye suo shu sheng ji wei fen qu suo shu , yin ci ti gao le fen qu biao de bing xing xing 。 zhe zhong sheng ji jian shao le ying yong de suo shu , yin ci jia kuai le kua yue cha xun 。 zai jiu ban ben zhong , xing suo shu he ye suo shu zhi neng sheng ji wei biao suo shu , zhe hui dao zhi ying yong bu bi yao de da suo , er qie hui fang ai qi ta yong hu 。 dui yu bao han da biao he da liang yong hu de ren he xi tong er yan , ti gao bing xing xing bing jian shao jing zheng ke gai shan ke yong xing , er qie neng gou ti gao zhi yuan gong zuo xiao lv he ke hu man yi du 。 bei fen he huan yuan chu le “ duan luo huan yuan ” he “ zai xian huan yuan ” ji shu wai , bei fen he huan yuan cao zuo huan zai hui fu fang mian ti gong le geng duo ling huo xing 。SQL Server shi yong hu neng gou huan yuan zhi du shu ju ku wen jian zu , er qie wu xu ying yong shi wu ri zhi 。 ta huan yuan xu tong shi zhi xing shu ju ku bei fen he shi wu ri zhi bei fen 。 zhuan yong guan li yuan lian jie “ zhuan yong guan li yuan lian jie (DAC)” shi yi zhong yu fu wu qi zhi jian de gao you xian ji lian jie , dang fu wu qi si hu yao ting ji yi ji bu jie shou xin lian jie shi , ta you zhu yu pai chu gu zhang 。 zi yuan tiao kong qi zai shi yong pin fan de shu ju ku zhong , bu tong de gong zuo fu he ke neng hui wei le ke yong de xi tong zi yuan er zhan kai jing zheng , li ru CPU xian cheng he nei cun 。 zai mou xie qing xing xia , zhe zhong zi yuan jing zheng ke neng hui shi ren wu guan jian xing gong zuo fu he shou dao shu ju ku zhong qi ta huo dong de bu liang ying xiang 。SQL Server 2008 ti gong “ zi yuan tiao kong qi ”, ta gen ju deng lu 、 ying yong cheng xu he qi ta yin su , wei bu tong de gong zuo fu he zhi ding you xian ji , cong er neng gou zhu dong guan li gong zuo fu he zi yuan li yong qing kuang 。 wei gong zuo fu he zhi ding you xian ji de neng li shi xing neng geng ju ke yu ce xing , you zhu yu que bao ren wu guan jian xing ying yong cheng xu zong you shu ju ku fu wu qi zi yuan ke yi shi yong 。 jie shu yu dang ke hu huo zhi yuan wu fa shi yong qi ye zhong de ren he guan jian xi tong shi , zhe dou hui li ji ying xiang dao qi ye de li run lv 。 ke yong xing wen ti he xu qiu qian cha wan bie , yi zhong jie jue fang an wu fa jie jue suo you de wen ti 。 SQL Server 2008 ti gong le duo zhong jie jue fang an yi gai shan ke yong xing , zhe zhong ke yong xing zhi shao zai xing neng he duo yang xing fang mian neng gou bi mei zhu liu shu ju ku chang shang ti gong de ren he lei si chan pin , er qie SQL Server 2008 ji xu zai ke guan li xing he zi jin jia zhi fang mian ju yu ling xian di wei 。 huo qu geng duo xin xi : [url=http://www.microsoft.com/sql]http://www.microsoft.com/sql[/url] ben wen dui nin you bang zhu ma ? qing gao su wo men nin de gan shou 。 ru guo cong 1( cha ) dao 5( ji hao ) de fen zhi zhong jin xing xuan ze , nin ren wei ben wen ying gai da ji fen ? yuan yin shi shen me ? li ru : nin shi fou ren wei you yu ti gong le hen hao de li zi 、 jing mei de ping mu jie tu 、 qing xi de wen zi miao shu huo qi ta yuan yin er ying gai gei ta gao fen ? nin shi fou ren wei you yu yong li bu dang 、 ping mu jie tu mo hu 、 wen zi miao shu han hun bu qing er ying gai gei ta di fen ? nin de yi jian jiang you zhu yu wo men gai shan suo fa bu bai pi shu de zhi liang 。 ti jiao yi jian 。
󰈣󰈤
  免责声明:本文仅代表作者个人观点,与王朝网络无关。王朝网络登载此文出于传递更多信息之目的,并不意味着赞同其观点或证实其描述,其原创性以及文中陈述文字和内容未经本站证实,对本文以及其中全部或者部分内容、文字的真实性、完整性、及时性本站不作任何保证或承诺,请读者仅作参考,并请自行核实相关内容。
 
 
上海柏雅居酒店模拍
清晨美丽的风景
梦清园的靓丽女生
妖艳的食人花(7)
且行且攝------"色"影大連
【做股票的朋友看过来-华尔街的铜牛】
端午节后闲逛
捐款赈灾吴川行 花絮
 
>>返回首页<<
 为你推荐
 
 
 转载本文
 UBB代码 HTML代码
复制到剪贴板...
 
 热帖排行
 
 
 
 
©2005- 王朝网络 版权所有