Nhasi tichakuzivisai maficha ekushandisa SQL Server 2019 neiyo Unity XT yekuchengetedza system, uye nekupawo kurudziro pakuona SQL Server uchishandisa VMware tekinoroji, kumisikidza uye kugadzirisa zvakakosha zvikamu zveDell EMC zvivakwa.
Muna 2017, Dell EMC neVMware vakaburitsa mhedzisiro yeongororo pamusoro pemaitiro uye shanduko yeSQL Server - "SQL Server Shanduko: Towards Agility uye Resilience" (), iyo yakashandisa ruzivo rwenharaunda yenhengo dze Professional Association yeSQL Server (PASS). Mhedzisiro yacho inoratidza kuti SQL Server dhatabhesi nharaunda dziri kukura muhukuru uye kuomarara, inotungamirwa nekuwedzera mavhoriyamu edata uye zvitsva zvebhizinesi zvinodiwa. SQL Server dhatabhesi ikozvino yaiswa mumakambani mazhinji, ichisimbisa mishoni-yakakosha maapplication, uye kazhinji ndiyo hwaro hwekushandurwa kwedhijitari.
Sezvo iyi tsvakurudzo yakaitwa, Microsoft yakabudisa chizvarwa chinotevera cheDBMS - SQL Server 2019. Mukuwedzera pakuvandudza mabasa ekutanga ejini yehukama uye kuchengetedza data, mabasa matsva nemabasa akaonekwa. Semuyenzaniso, SQL Server 2019 inosanganisira tsigiro yekuremerwa kwedata hombe uchishandisa Apache Spark uye Hadoop Distributed File System (HDFS).
Alliance Dell EMC uye Microsoft
Dell EMC neMicrosoft vane kudyidzana kwenguva refu mukugadzira mhinduro dzeSQL Server. Kubudirira kuita yakazara dhatabhesi chikuva seMicrosoft SQL Server kunoda kurongeka kwekushanda kwesoftware neiyo iri pasi peIT masisitimu. Izvi zvinosanganisira processor yekugadzirisa simba, ndangariro zviwanikwa, kuchengetedza uye network masevhisi. Dell EMC inopa SQL Server papuratifomu zvivakwa zverudzi rwese rwebasa uye kushandisa.
Iyo Dell EMC PowerEdge server mutsara inopa akasiyana processor uye ndangariro masisitimu. Aya magadzirirwo anokodzera kuwanda kwehuwandu hwemabasa: kubva kumabhizinesi madiki maapplication kusvika kune makuru-akakosha masisitimu, senge enterprise resource kuronga (ERP), matura data, advanced analytics, e-commerce, nezvimwe. kuchengetedza data isina kurongeka uye yakarongeka.
Vatengi vanoendesa SQL Server 2019 neDell EMC zvivakwa vanogona kushanda neyakarongwa uye isina kurongeka data vachishandisa SQL Server uye Apache Spark. SQL Server inotsigirawo musanganiswa wekuwana mutengi, server-to-server, uye server-to-storage communications technologies. Chiono chaDell EMC chakavakirwa pane yakakamurwa modhi inopa yakavhurika ecosystem. Masangano anogona kusarudza kubva kwakasiyana siyana indasitiri yakajairika networking application, anoshanda masisitimu uye hardware mapuratifomu. Iyi nzira inokupa iwe hukuru hwekutonga pamusoro petekinoroji uye zvivakwa, zvichikonzera kukosha kwakakosha kuchengetedza uye kuchinjika.
VMware inokwenenzvera zvese zvakakosha zvivakwa izvo SQL Server inoda kuti iwane yakakwirira kuita uye kushanda kunoenderana. Pamusoro pegore rakazvimiririra, VMware zvakare parizvino inopa mhando dzakasanganiswa dzekuremerwa kwemabasa, kutenderera akavanzika uye eruzhinji makore ekuvaka.
Masangano mazhinji ari kutendeukira kune virtualization kudzikisa mitengo yezvivakwa, kupa kuwanikwa kwakanyanya, uye kurerutsa kudzoreredza njodzi. 94% yeSQL Server nyanzvi dzakaongororwa dzinoshuma imwe nhanho ye virtualization munzvimbo yavo. 70% yeavo vanoshandisa virtualization vakasarudza VMware. 60% vane SQL Server virtualization mazinga e75% kana kupfuura. Pamusoro pezvo, mhedzisiro yeongororo inoratidza kuti kuwanikwa kwepamusoro uye kudzoreredza njodzi kunoitwa padanho rekuonana kwave zvinhu zvakakosha musarudzo yekuona SQL Server dhatabhesi.
Zvinyowani muSQL Server 2019
Iyo SQL Server 2019 dhatabhesi papuratifomu inosanganisira yakafara siyana matekinoroji, maficha, uye masevhisi anotsigira mishoni-akakosha maapplication akadai analytics, bhizinesi dhatabhesi, bhizinesi kungwara (BI), uye scalable transaction process (OLTP). Iyo SQL Server papuratifomu yakawana hunyanzvi hwekutarisira kubatanidzwa kwedata, kuchengetedza data, kushuma uye analytics yepamberi, kugona kudzokorora, uye manejimendi ehafu-yakarongeka data mhando. Ehe, havasi vese vatengi kana maapplication anoda ese aya maficha. Pamusoro pezvo, muzviitiko zvakawanda zviri nani kuparadzanisa SQL Server masevhisi uchishandisa virtualization.
Nhasi, mabhizinesi anowanzoda kuvimba nemavhoriyamu makuru e data kubva kune yakakura-inoramba ichiwedzera data seti. NeSQL Server 2019, unogona kuwana pedyo-chaiyo-nguva ruzivo kubva kune yako data. SQL Server 2019 zvikwata zvinopa nharaunda yakazara-chiyero chekushanda nemaseti makuru edata, kusanganisira kushandiswa kwemichina yekudzidza uye hungwaru hwekugadzira. Iwo makuru matsva maficha uye zvigadziriso muSQL Server 2019 zvakanyorwa mukati .
Dell EMC Kubatana XT Mid-Range Storage System
Iyo Dell EMC Unity yekuchengetedza yakateedzana yakatangwa angangoita makore matatu apfuura, uye kubva ipapo anopfuura zviuru makumi mana masisitimu akatengeswa. Vatengi vanokoshesa iyi yepakati-renji array nekureruka kwayo, kuita uye mutengo-kushanda. Dell EMC Unity XT midrange mapuratifomu akagovaniswa zvigadziriso zvinounza yakaderera latency, yakakwirira throughput, uye yakaderera manejimendi pamusoro peSQL Server mitoro yebasa. Yese Unity XT masisitimu anoshandisa maviri ekuchengetedza processor (SP) architecture kubata I/O uye inoshanda / inoshanda data mashandiro. Unity XT mbiri mbiri SP inoshandisa yakazara yemukati 40Gbps SAS yekubatanidza uye inomiririra yakawanda-yakakosha dhizaini yekushanda kwepamusoro uye kugona. Madhisiki arrays anotendera iwe kuti uwedzere dura rekuchengetedza uchishandisa mamwe masherufu.
Dell EMC Unity XT, chizvarwa chinotevera chearrays (hybrid uye ese-flash), zvakanyanya kuwedzera mashandiro, inovandudza mashandiro, uye inowedzera hutsva hutsva nemasevhisi enzvimbo dzakawanda-makore.
Iyo Unity XT dhizaini inobvumidza iwe kuti ugadzire data panguva imwe chete, kuderedza mavhoriyamu edatha, uye masevhisi ekutsigira akadai sekudzokorora pasina kupira kuita kwekushandisa. Kuenzaniswa neyakapfuura chizvarwa mhinduro, kushanda kweDell EMC Unity XT yekuchengetedza system yakapetwa kaviri uye nguva yekupindura ndeye 75% nekukurumidza. Uye zvechokwadi, Dell EMC Unity inotsigira iyo NVMe standard.
Masisitimu ekuchengetedza ane NVMe madhiraivha anoratidza kuita kwavo kwakanyanya mulatency-sensitive application. Semuenzaniso, mumashandisirwo akadai semahombe dhatabhesi, NVMe inopa yakaderera latency uye yakakwirira yepamusoro data data. Yakaderedzwa latency uye yakawedzera concurrency inovandudza kuverenga / kunyora kuita. Hazvisi masanga kuti, maererano nekufanotaura kweIDC, panosvika 2021, maflash arrays ane NVMe uye NVMe-oF (NVMe pamusoro peFabric) yekubatanidza ichaverengera inenge hafu yemari yese kubva mukutengesa kwekunze masisitimu ekuchengetedza pasirese.
Data compression algorithms inovandudza kuchengetedza kushanda zvakanaka. Dell EMC Unity XT inogona kuderedza vhoriyamu yedata kusvika kashanu. Chimwe chiratidzo chakakosha ndechekushanda kwese kwehurongwa. Dell EMC Unity XT inoshandisa 85% system kugona. Compression uye deduplication inoitwa inline modhi - padanho rekutonga. Iyo data inochengetwa mune yakamanikidzwa fomu. Iyo sisitimu zvakare inogadzirisa kushanda nedata snapshots.
Zviri nyore kushandisa Unity flash arrays ane yakabatana (block uye faira) yekuwana inopa yakagadzika mhinduro nguva, inosanganisa neyekuchengetera masevhisi, uye kutsigira kukwidziridzwa pasina kutama data. Mukugadzirisa kwayo kwekutanga, iyi inoshandiswa zvakasiyana-siyana yekuchengetedza system inoisa mumaminitsi makumi matatu.
Tekinoroji yekuchengetedza data inonzi "madhamu ane simba" inokutendera iwe kuti ufambe kubva kune static kuenda kune ine simba ndangariro yekuwedzera, inopa yakakwirira kushanda kuchinjika uye nyore kwekuwedzera sisitimu simba. Dynamic madziva anochengetedza huwandu uye bhajeti, uye inoda nguva shoma yekuvakazve. Kuwedzera kugona uye kuita kweDell EMC Kubatana hakudi kutama kwedata.
Makambani mazhinji nhasi anoshandisa akati wandei eruzhinji makore masevhisi akabatana neavo-panzvimbo zvivakwa. Dell EMC Unity XT inogona kushanda sechikamu cheDell Technologies Cloud nharaunda. Iyi yekuchengetedza sisitimu inogona kushandiswa mune yeruzhinji gore uye data inogona kuendeswa kune yakavanzika gore. Pamusoro pezvo, Dell EMC Unity XT chengetedzo inowanikwa sevhisi. Iyi ndeimwe yemasevhisi ekuchengetedza makore eDell EMC Cloud Storage Services.
Cloud kuchengetedza iri kuramba ichizivikanwa nekuti inogona kuvandudza ROI nekudzikisa mitengo yezvivakwa. Cloud Storage Services inowedzera vatengi' data nzvimbo kune gore nekuendesa Dell EMC chengetedzo (yakanangana neruzhinji Cloud zviwanikwa) sevhisi. Vechitatu-bato vanopa vanogona kupa yakakwira-kumhanya (yakaderera latency) yeruzhinji gore yekubatanidza yakananga kuDell EMC Unity, PowerMax uye Isilon masisitimu munzvimbo yemutengi data.
Mhuri yeUnity XT inosanganisira Unity XT All-Flash, Unity XT Hybrid, UnityVSA uye Unity Cloud Edition masisitimu.
Yakabatana Hybrid uye Flash Arrays
Intel-based Unity XT Hybrid uye Unity XT Yese-Flash yekuchengetedza masisitimu inopa yakasanganiswa dhizaini yekuvhara, kuwana faira, uye VMware VVols nerutsigiro rwetiweki yakasungirirwa kuchengetedza (NAS), iSCSI, uye Fiber Channel (FC) protocol. Iyo Unity XT Hybrid uye Unity XT All-Flash mapuratifomu ari NVMe-akagadzirira.
Unity XT hybrid masisitimu anotsigira akawanda-makore nharaunda. Multi-cloud zvinoreva kuwedzera chengetedzo kune gore kana kuendesa kune iyo gore ine inochinjika mashandisirwo ekushandisa sarudzo. Multicloud chengetedzo yakagadzirirwa kuve nechokwadi chekufamba uye data kutakurika pakati akati wandei makore mapuratifomu - akavanzika uye eruzhinji. Izvi zvinokanganisa kwete chete maitiro ekufambisa data, asiwo kurongeka kwekushandisa kuwana data mune akati wandei makore eruzhinji.
Aya mahybrid arrays anopa zvinotevera kugona:
- Scalable kusvika 16 PB mbishi simba.
- Yakavakwa-mukati data kuderedza masimba kune ese maflash madziva.
- Kukurumidza kuisa uye kugadzirisa (paavhareji inotora maminitsi makumi maviri nemashanu).
SSD tekinoroji iri kukurumidza kuvandudza, uye zvitsva zvekuchinja zvigadzirwa zvicharova pamusika mumakore anotevera. Zvichakadaro, masangano acharamba achitsiva echinyakare HDD nemaSDD kuitira kuvandudza mashandiro, kureruka kwekutonga uye kuchengetedza simba. Zvizvarwa zvitsva zveese-flash arrays zvichave neakawanda epamberi ekuchengetedza otomatiki, yeruzhinji gore kubatanidzwa, uye yakabatanidzwa kuchengetedza data.
Kubatana XT Yese-Flash masisitimu anoburitsa kumhanya, kunyatsoita, uye akawanda-makore rutsigiro. Zvimiro zvavo:
- Kubereka kaviri.
- Kuderedza data kusvika pa7:1.
- Kurumidza kuisirwa uye kugadzirisa (maitiro anotora asingasviki maminetsi makumi matatu).
UnityVSA
UnityVSA isoftware-yakatsanangurwa chengetedzo yeVMware ESXi chaiyo nharaunda uchishandisa sevha, yakagovaniswa, kana gore kuchengetedza huwandu. UnityVSA HA, mbiri-yekuchengetedza UnityVSA kumisikidzwa, inopa kumwe kushivirira kukanganisa. UnityVSA yekuchengetedza inopa:
- Kusvika ku50 TB yeakazara-akabatanidzwa akabatana kuchengetedza.
- Inoenderana neUnity XT masisitimu uye maficha.
- Tsigiro yemhando yepamusoro yekuwanikwa masisitimu (UnityVSA HA).
- Kubatanidza seNAS uye iSCSI.
- Kudzokorora kwedata kubva kune mamwe mapuratifomu eUnity XT.
Unity Cloud Edition
Zvekuwiriranisa faira uye mabasa ekudzoreredza njodzi negore, iyo Unity XT mhuri inosanganisira Unity Cloud Edition, iyo inopa:
- Inonyatso ratidza masimba ekuchengetedza uchishandisa software-inotsanangurwa chengetedzo (SDS) yakaiswa mugore.
- Nyoresa dhizaini uye faira chengetedzo neVMware Cloud paAWS.
- Tsigiro yekudzoreredza njodzi, kusanganisira kuongororwa uye kuongororwa kwedata.
Kubatana XT Yese Flash yeSQL Server
Unisphere Research's 2017 chirevo, "SQL Server Shanduko: Towards Agility uye Resilience" () 22% yevakapindura vakataura kuti vanoshandisa tekinoroji yekuchengetedza mukugadzira (16%) kana kuronga kuzviita (6%). 30% inoshandisa mahybrid arrays anosanganisira flash memory. 13% inoshandisa yakananga-inonamatira flash arrays. 13% tsigira SQL Server dhatabhesi kune flash kuchengetedza.
Uku kukurumidza kugashira kwekuchengetera flash kuti ishandiswe neSQL Server zvinoreva kuti Unity XT All-Flash arrays anonyanya kukodzera SQL Server vanogadzira uye maneja. Kubatana XT Yese-Flash masisitimu inopa SQL Server vanogadzira uye manejimendi kugona uye kuita kunodarika izvo zvakajairwa kuchengetedza nzvimbo network (SANs) inopa.
Kubatana XT Yese-Flash masisitimu, ayo ari NVMe-akagadzirira (yepamusoro pekuita kwepamusoro uye yakaderera latency), ine 2U fomu chinhu, inotsigira maviri-core processors, maviri controller mune inoshanda / inoshanda mode.
Kubatana XT Yese-Flash Models
Kubatana XT
Processors
Memory (per processor)
Max. nhamba yemadhiraivha
Max. "Mbishi" simba (PB)
380F
1 Intel E5-2603 v4
6c/1.7 GHz
64
500
2.4
480F
2 Intel Xeon Silver
4108 8c/1.8 GHz
96
750
4.0
680F
2 Intel Xeon Silver
4116 12c/2.1 GHz
192
1,000
8.0
880F
2 Intel Xeon Goridhe 6130
16c/2.1 GHz
384
1,500
16.0
Ruzivo runogona kuwanikwa mune array specifications ().
Madziva ekuchengetera
Vazhinji veSQL Server nyanzvi dzinoziva kuti ese emazuvano ekuchengetedza arrays anopa kugona kuunganidza madhisiki muhombe yekuchengetera zvikamu zvine nhanho yakatarwa yeRAID dziviriro. Mapoka ega ega edhisiki ane RAID dziviriro ndiwo echinyakare ekuchengetedza madziva. Nepo Unity XT hybrid masisitimu anongotsigira echinyakare madziva, Unity XT Yese-Flash arrays inopawo masimba ekuchengetedza madziva. Iine madziva ekuchengetedza ane simba, RAID dziviriro inoiswa kune dhisiki zviyero-zvikamu zvekuchengetedza zvidiki pane yakazara dhisiki. Dynamic madziva anopa kushanduka kukuru mukugadzirisa nekuwedzera madhisiki madziva.
Dell EMC inopa akanakisa maitiro ekutarisira dziva rekuchengetedza kuti uwane yakanyanya kuita nekuoma kudiki. Semuenzaniso, zvinokurudzirwa kudzikisa huwandu hweUnity XT yekuchengetedza madziva kuderedza kuomarara uye kuwedzera kuchinjika. Nekudaro, kumisikidza mamwe madziva ekuchengetera anogona kubatsira zvakanyanya mune dzimwe nguva, kusanganisira kana iwe uchida:
- Tsigira mabasa akasiyana ane akasiyana maI / O profiles.
- Govera zviwanikwa kuti uwane mamwe maitiro ekuita.
- Tsaura zviwanikwa zvakasiyana kune akawanda-tenancy.
- Gadzira madiki madomasi kudzivirira kubva mukukundikana
Mavhoriyamu ekuchengetera (LUNs)
Iwe unoenzanisa sei kutonga uye kushanduka kana uchisarudza huwandu hwemavhoriyamu muhurongwa? Kuti uwedzere kuchinjika muKubatana neSQL Server, zvinokurudzirwa kugadzira mavhoriyamu ega yega dhatabhesi faira. Mukuita, masangano mazhinji anotora nzira yakasarudzika, uko dhatabhesi dzakakosha dzinopihwa kuchinjika uye kushomeka kwemafaira edatabase akaiswa mumavhoriyamu mashoma, akakura. Isu tinokurudzira kuongorora zvese zvinodiwa zvedhatabhesi uye chero zvakabatana maapplication nekuti kuchengetedza data uye yekutarisa matekinoroji zvinoenderana nekusarudzika kwemafaira uye kuiswa.
Mavhoriyamu akawanda anogona kazhinji kunetsa kubata, kunyanya munzvimbo chaidzo. Virtualized SQL Server nharaunda muenzaniso wakanaka wekuti kuitisa akawanda mafaira emhando pavhoriyamu imwe chete kunogona kuita zvine musoro. Mutariri wedhatabhesi kana maneja wekuchengetedza (kana ese ari maviri) anofanirwa kusarudza chiyero chakakodzera pakati pekuchinjika uye kuchengetedza kana uchitarisa huwandu hwemavhoriyamu ekugadzira.
Kuchengetedza mafaira
Masevha eNAS anotambira masisitimu efaira paUnity XT kuchengetedza. Mafaira masisitimu anogona kuwanikwa uchishandisa iyo SMB kana NFS protocol, uye neakawanda-protocol faira system, unogona kushandisa ese maprotocol panguva imwe chete. Masevha eNAS anoshandisa madhiraivha ekubatanidza mugadziri kuSMB, NFS, uye multiprotocol faira masisitimu, pamwe neVMware NFS yekuchengetedza uye VMware mavhoriyamu chaiwo. Mafaira masisitimu uye madhiraivha anosarudzika mukati mesevha imwechete yeNAS, achibvumira akawanda maseva eNAS kuti ashandiswe kune akawanda-tenancy. maseva eNAS anongotadza kana processor yatadza. Yavo yakabatana faira masisitimu zvakare inokundikana.
SQL Server 2012 (11.x) neshanduro dzepashure dzinotsigira Server Message Block (SMB) 3.0, iyo inobvumira network faira kugoverana kuchengetedza. Kune ese ari maviri akamira uye failover cluster kumisikidzwa, unogona kuisa system database (tenzi, modhi, msdb, uye tempdb) uye Database Engine mushandisi dhatabhesi ine SMB yekuchengetedza sarudzo. Kushandisa SMB kuchengetedza isarudzo yakanaka kana uchishandisa Nguva Dzose PaAvailability Mapoka nekuti iyo faira yekugova inoda kuwana kune inowanikwa zvakanyanya network sosi.
Kugadzira SMB faira migove yeSQL Server kutumirwa neUnity XT chengetedzo iri nyore-nhanho-nhanho maitiro: iwe unogadzira sevha yeNAS, faira system, uye SMB share. Dell EMC Unisphere Storage Management software inosanganisira yekumisikidza wizard kuti ikubatsire kupedzisa maitiro aya. Nekudaro, kana uchitambira SQL Server basa rakawanda paSMB faira migove, pane zvimwe zvakakosha zvekuchengeta mupfungwa izvo hazvishande pakushandiswa kweSMB faira migove. Microsoft yakanyora rondedzero yekuisa uye kuchengetedza nyaya pamwe chete nenyaya dzinozivikanwa parizvino; Kuti uwane ruzivo, ona "Kuisa SQL Server ine SMB Faira Kuchengeta" mukati .
Data Snapshots
Dhata rave sosi yakakosha yekambani, uye nharaunda dzemazuva ano dzakakosha-misheni dzinoda zvinopfuura kungoita basa. Izvo zvinodikanwa kuti zvikumbiro zvinogara zviri online, zvinopihwa nekusakanganiswa mashandiro uye zvigadziriso. Izvo zvinodawo kuita kwepamusoro uye kuwanikwa kwedata kuburikidza nesarudzo senge yemuno snapshot kudzokorora uye kure kure kudzokorora.
Iyo Unity XT yekuchengetedza array inopa block uye faira snapshot masimba ayo anogovera zvakajairika workflows, mashandiro, uye zvivakwa. Unity's snapshot methodology inopa iri nyore uye inoshanda nzira yekudzivirira data. Snapshots inoita kuti zvive nyore kudzoreredza data - dzokera kumashure kune yakapfuura snapshot, kana iwe unogona kukopa yakasarudzwa data kubva pane yapfuura snapshot. Tafura inotevera inoratidza snapshot yekuchengetedza nguva yeUnity XT masisitimu.
Kuchengetera kwenzvimbo uye kure kwe data snapshots
Mufananidzo mhando
CLI
UI
REST
Manually
Yakarongwa
Manually
Yakarongwa
Manually
Yakarongwa
Local
1 gore
1 gore
5 makore
Mavhiki e4
100 makore
Hapana miganhu
Kure
5 makore
Mavhiki e255
5 makore
Mavhiki e255
5 makore
Mavhiki e255
Snapshots haisi kutsiva yakananga kune dzimwe nzira dzekudzivirira data, senge mabhapu. Ivo vanogona chete kuzadzisa zvechinyakare backup semutsara wekutanga wekudzivirira kune yakaderera RTO mamiriro.
Iyo Dell EMC Unity snapshot chimiro chinosanganisira kudzikisa data uye kudhirowa kwepamberi. Snapshots zvakare inobatsira kubva munzvimbo yekuchengetedza iyo inowanikwa pane yekutanga yekuchengetedza sosi. Paunotora snapshot yechichengetedzo chinotsigira maficha ekudzikisa data, iyo data iri pasosi inogona kudzvanywa kana kudhindwa.
Heano mamwe manyoro ane chekuita nekudzoreredza dhatabhesi kana uchishandisa snapshots neSQL Server dhatabhesi:
- Zvese zvikamu zveSQL Server dhatabhesi zvinofanirwa kuchengetedzwa seseti yedata. Kana data uye mafaira egita ari pamaLUN akasiyana, iwo maLUN anofanirwa kunge ari chikamu cheboka rinoenderana. Boka rinoenderana rinoona kuti mufananidzo unotorwa panguva imwe chete pamaLUN ese ari muboka. Kana data uye faira regi zviri pane akawanda SMB faira magove, migove inofanirwa kunge iri pane imwecheteyo faira system.
- Paunenge uchidzoreredza SQL Server dhatabhesi kubva ku block-based snapshot, kana iyo SQL Server muenzaniso ichifanira kuramba yakabatana, shandisa Unisphere host inojoinha. Kuti faira-yakavakirwa kudzoreredza, imwe yekuwedzera SMB mugove inogadzirwa uchishandisa snapshot sesosi. Kana mavhoriyamu aiswa, dhatabhesi inogona kusungirirwa pasi pezita rakasiyana kana dhatabhesi iripo inogona kutsiviwa neyakadzoserwa.
- Paunenge uchiita kudzoreredza uchishandisa Snapshot Kudzoreredza nzira muUnisphere, tora iyo SQL Server muenzaniso pasina. SQL Server haizive nezve kudzoreredza mashandiro. Kutora chiitiko kunze kwenyika kunovimbisa kuti mavhoriyamu haana kukuvadzwa nedhatabhesi inonyora isati yapora. Kana chiitiko changotangwazve, SQL Server kudzoreredza njodzi ichaunza iyo dhatabhesi munzvimbo inowirirana.
- Gonesa snapshots ezvakawanda zvekuchengetera zvinhu panguva imwe chete, uye wobva waona kuti sisitimu iri mumamodhi anokurudzirwa ekushandisa usati wagonesa mamwe mapikicha.
Automation uye kuronga kwepfuti
Snapshots muUnity XT inogona kuve otomatiki. Aya anotevera default snapshot sarudzo anowanikwa muUnisphere kuchengetedza manejimendi: default kuchengetedzwa, kupfupi kuchengetedza kuchengetedza, uye kuchengetedzwa kwekuchengetedza kwenguva refu. Imwe neimwe sarudzo inotora snapshots yemazuva ese uye inoachengetedza kwenguva dzakasiyana dzenguva.
Iwe unogona kusarudza imwe (kana ese) yesarudzo yekuronga - yega x maawa (kubva pa1 kusvika 24) uye zuva nezuva / vhiki. Zuva nezuva/vhiki nevhiki snapshot kuronga inobvumidza iwe kuti utaure yakatarwa nguva nemazuva ekuti zvidhori zvitorwe. Pasarudzo yega yega yakasarudzwa, unofanirwa kuseta mutemo wekuchengeta, unogona kugadzirwa kuti udzime dziva otomatiki kana kurichengeta kwenguva pfupi.
Ruzivo rwakawanda nezve Unity snapshots - pa .
Makirini matete
Clone yakatetepa ikopi yekuverenga / yekunyora yeyakatetepa block yekuchengetedza sosi, senge vhoriyamu, inowirirana boka, kana VMware VMFS datastore, iyo inogovera mabhuraki neayo mubereki sosi. Makoni matete inzira huru yekukurumidza uye nekubatanidza makopi eSQL Server dhatabhesi, chimwe chinhu icho chinyakare SQL Server maturusi hachikwanise kuwana. Kana iyo clone yakatetepa yaunzwa kumuridzi, mavhoriyamu anogona kuunzwa online uye dhatabhesi ichanamirwa uchishandisa iyo DB Attach nzira muSQL Server.
Paunenge uchishandisa iyo yekusimudzira ficha ine matete clones, tora ese dhatabhesi pane yakatetepa clone offline. Izvi zvinofanirwa kuitwa pamberi pekuvandudza kushanda. Kutadza kutora dhatabhesi kunze kwepamhepo usati waita kusimudzira kunogona kukonzera kukanganisa kusawirirana kwedata kana mhedzisiro yedata isiriyo paSQL Server.
Data replication
Kudzokorora chinhu chesoftware chinowiriranisa data neremote system panzvimbo imwe chete kana imwe nzvimbo. Kubatana kwekudzokorora uye sarudzo dzekugadzirisa zvinokutendera iwe kuti usarudze nzira inoshanda yekusangana neRTO/RPO zvinodiwa zveSQL Server dhatabhesi uchienzanisa mashandiro uye mabudiro.
Paunenge uchishandisa Dell EMC Unity Replication kuchengetedza SQL Server dhatabhesi paakawanda mavhoriyamu, iwe unofanirwa kudzikamisa ese data uye mavhoriyamu egi mudhatabhesi kune rimwe chete kuwirirana boka kana faira system. Replication inozomisikidzwa paboka kana faira system uye inogona kusanganisira mavhoriyamu kana migove yemadatabase akawanda. Madhatabhesi anoda akasiyana ekudzokorora sarudzo anofanirwa kunge ari pamaLUN akasiyana, mapoka anowirirana, kana mafaera masisitimu.
Matete clones anowirirana nezvose zviri zviviri synchronous uye asynchronous replication. Kana clone yakatetepa ikadzokororwa kune kwainoenda, inova kopi izere yevhoriyamu, kuwirirana boka, kana VMFS chengetedzo. Mushure mekudzokorora, clone yakatetepa ivhoriyamu yakazvimirira yakazara ine marongero ayo.
Maitiro ekuonda clone kudzokorodza pakati pekwakabva uye chinangwa masisitimu.
Kudzokorora kweiyo tempdb dhatabhesi hakudiwe nekuti iyo faira inovakwa patsva kana SQL Server yatangwazve, uye saka metadata haienderane nemaitiro emamwe maSQL Server zviitiko. Kunyatsosarudzwa kwemavhoriyamu kuti adzokorore uye zviri mukati meaya mavhoriyamu zvinobvisa zvisina kufanira kudzokorora traffic.
Yakabatanidzwa Microsoft SQL Server Data Copy Management
Zvizhinji zvemazuva ano zvigadzirwa zvekuchengetera (kusanganisira zvese zvigadzirwa zveDell EMC) zvinogona kugadzira "operating system inowirirana" makopi emhando yefaira ne:
- Inopindirana yekunyora kurongeka neiyo inoshanda sisitimu pamatanho ese - kubva kumuenzi kuenda kudhiraivha.
- Kubatanidza mavhoriyamu kuitira kuti mafaera akawanda pamavhoriyamu akasiyana achengetedze kurongeka kwekunyora.
Nekutorwa kwakapararira kwemidziyo yekuchengetedza inokuvadza, Microsoft yakagadzira API yevanopa kuchengetedza. Iyi API inobvumira vanochengeta kuchengetedza kurongeka neSQL Server dhatabhesi software kugadzira "application-inopindirana makopi" vachishandisa Volume Shadow Copy Service (VSS). Aya makopi anotevedzera kudyidzana pakati peSQL Server uye sisitimu yekushandisa panguva yakarongwa uye kuvharika kweSQL Server. Ese mabhafa ekunyora anonyungudutswa uye kutengeserana kunomiswa kudzamara madhisiki ese agadziridzwa uye anoenderana pane imwe nguva nenguva, iyo yakanyorwa muSQL log.
Dell EMC AppSync software yakabatanidzwa neUnity XT snapshots inorerutsa uye inogadzirisa maitiro ekugadzira, kushandisa, uye kugadzirisa makopi-anoenderana makopi edata rebasa. Iyi software yakagadzirirwa kushandiswa mumakopi ekudzora mamiriro ekudzoreredza dhatabhesi uye kushandiswazve.
AppSync software inowana otomatiki dhatabhesi, inodzidza dhatabhesi chimiro, uye inomepu chimiro chefaira kuburikidza nehardware kana virtualization layer kune iri pasi peUnity XT chengetedzo. Inoronga nhanho dzese dzinodiwa, kubva pakugadzira nekusimbisa kopi kusvika pakumisikidza snapshots pane yainotarirwa host uye kutanga kana kudzoreredza dhatabhesi. AppSync inotsigira uye inorerutsa SQL Server workflows inosanganisira kuvandudza uye kudzoreredza dhatabhesi rekugadzira.
Kuderedzwa kwedata uye kudhirowa kwepamberi
Iyo Dell EMC Unity mhuri yemasisitimu ekuchengetedza inopa chimiro-chakapfuma, chiri nyore-kushandisa-kudzikisa data masevhisi. Kuchengetedza kunowanikwa kwete chete pane zvakagadziriswa zvekutanga zvekuchengetedza zviwanikwa, asiwo pane zvipfupi uye matete clones ezviwanikwa izvi. Snapshots uye matete clones vanogara nhaka yekudzikisa data kuseta kweiyo sosi yekuchengetedza, iyo inowedzera kuchengetedza kwesimba.
Iyo yekudzora data ficha inosanganisira kudhirowa, kudzvanya, uye zero block yekuona zviitiko, zvichigona kuwedzera huwandu hwehunogona kushandiswa nzvimbo yekuchengetedza yezvinhu zvemushandisi uye kushandiswa kwemukati. Iyo Unity XT yekudzikisa dhata inotsiva iyo yekumanikidza chimiro muUnity OE 4.3 uye gare gare. Compression ndeyekudzikisa data algorithm iyo inogona kuderedza kugoverwa kwemuviri kwesimba rinodiwa kuchengetedza data set.
Unity XT masisitimu anopawo yepamberi deduplication chimiro chinogona kugoneswa kana kuderedzwa kwedata kuchigoneswa. Yepamberi deduplication inoderedza huwandu hunodiwa kune data remushandisi nekuchengetedza chete nhamba diki yemakopi (kazhinji kopi imwe chete) yeUnity data block. Nzvimbo yekubvisa ndeye LUN imwe. Tora izvi mupfungwa pakusarudza chirongwa chekuchengetedza. MaLUN mashoma anokonzeresa kuderedzwa kuri nani, asi mamwe maLUN anopa kuita kurinani.
Kuchengetedzwa kwesimba kubva kumberi kwekubvisa kunogona kupa bhenefiti huru munzvimbo zhinji, asi zvinodawo kushandiswa kweUnity array processors. MuOE 5.0, deduplication yepamberi, kana yagoneswa, inobvisa chero block (yakadzvanywa kana isina kudzvanywa). Kuti uwane rumwe ruzivo, ona .
Tafura inotevera inoratidza zvigadziriso zvinotsigirwa zvekudzikisa data uye kudhirowa kwepamberi:
Kudzikiswa kwedata muKubatana (ese mamodheru) uye yakawedzera tsigiro yekubvisa
Unity OE vhezheni
Technology
Inotsigirwa dziva rudzi
Inotsigirwa Mienzaniso
4.3 / 4.4
Data kuderedza
Flash memory dziva - yechinyakare kana ine simba
300, 400, 500, 600, 300F, 400F, 500F, 600F, 350F, 450F, 550F, 650F
4.5
Data kuderedza
300, 400, 500, 600, 300F, 400F, 500F, 600F, 350F, 450F, 550F, 650F
Kuderedzwa kwedata uye kudhirowa kwepamusoro *
450F, 550F, 650F
5
Data kuderedza
300, 400, 500, 600, 300F, 400F, 500F, 600F, 350F, 450F, 550F, 650F, 380, 480, 680, 880, 380F, 480F, 680F, 880F, XNUMXF
Kuderedzwa kwedata uye kudhirowa kwepamberi
450F, 550F, 650F, 380, 480, 680, 880, 380F, 480F, 680F, 880F
* Kudzikiswa kwedata kunovharwa nekusarudzika uye kunofanirwa kugoneswa kusati kwaitwa kudhirowa kwepamberi kwave sarudzo iripo. Mushure mekugonesa kuderedzwa kwedata, kudhirowa kwepamberi kunowanikwa, asi kunovharwa nekusarudzika.
Kuderedzwa kwedata muKubatana uye kudzvanywa kwedata muSQL Server
SQL Server 2008 Enterprise Edition yaive yekutanga kuburitswa kupa ekuzvarwa data compression kugona. SQL Server 2008 row-level uye peji-level compression inoshandisa ruzivo rweSQL Server yemukati dhatabhesi tafura fomati kuderedza nzvimbo inodyiwa nedatabase zvinhu. Kuderedza nzvimbo kunokubvumira kuchengetedza mamwe mitsara peji uye mamwe mapeji mudziva rebuffer. Nekuti data isina kuchengetwa mu8k data peji fomati, senge-ye-mutsetse data seNVARCHAR(MAX), haizoshandise mitsara kana mapeji nzira dzekumanikidza, Microsoft yakaunza Transact-SQL COMPRESS uye DECOMPRESS mabasa.
Aya mabasa anoshandisa nzira yechinyakare yekudzvanya data (iyo GZIP algorithm) iyo inofanirwa kudaidzwa kuti chikamu chega chega chedata chitsikidzwe kana kudzikiswa.
Unity XT compression, iyo isiri yega kuSQL Server, inoshandisa algorithm yesoftware kuongorora nekumanikidza kuchengetedza data. Kubva pakaburitswa Unity OE 4.1, Unity data compression yave kuwanikwa yeblock storage volumes uye VMFS data store mune flash pool. Kutanga neUnity OE 4.2, compression inowanikwawo kune mafaera masisitimu uye NFS data zvitoro mumadhamu ekuchengetera madziva.
Sarudzo yedata yekumanikidza nzira yeSQL Server inotsamira pane akati wandei. Izvi zvinhu zvinosanganisira mhando yezvinyorwa zvedatabase, zviripo zveCPU zviwanikwa - zvese pakuchengetedza uye pamaseva edatabase, uye I/O zviwanikwa zvinodiwa kuchengetedza SLA. Kazhinji, unogona kutarisira imwe nzvimbo yekuchengetedza data iyo yakamanikidzwa uchishandisa SQL Server, asi data yakadzvanywa uchishandisa TSQL's GZIP compression chimiro hachikwanisike kuona yakakosha nzvimbo yekuchengetedza kubva kuUnity XT's compression maficha sezvo mazhinji emabhenefiti anobva kune yekare. algorithm.
Kubatana kwekumanikidza kunopa nzvimbo yekuchengetedza kana iyo data pane chinhu chekuchengetedza yakamanikidzwa neinosvika 25%. Usati wagonesa kudzvanya pane chinhu chekuchengetedza, tarisa kana ine data inogona kudzvanywa. Usagone kudzvanya kwechinhu chekuchengetedza kunze kwekunge kuita izvi kuchizochengetedza huwandu.
Paunosarudza kushandisa Unity data kuderedza, SQL Server database-level compression, kana zvese zviri zviviri, funga zvinotevera:
- Dhata inonyorerwa kuUnity system inosimbiswa neanotambira mushure mekunge yachengetwa mu cache system. Nekudaro, iyo yekumanikidza maitiro haitangi kusvika cache yabviswa.
- Kuchengetedza kwekumanikidza kunowanikwa kwete chete kune Unity XT yekuchengetedza zviwanikwa, asi zvakare kune snapshots uye matete clones eiyo sosi.
- Munguva yekumanikidza, mabhuroki akawanda anounganidzwa uchishandisa sampling algorithm kuona kana iyo data inogona kudzvanywa. Kana iyo sampling algorithm ikaona kuti chete mari shoma inogona kuwanikwa, ipapo compression inosvetuka uye data inonyorerwa dziva.
- Kana data yakamanikidzwa isati yanyorwa kune yekuchengetedza midhiya, huwandu hwekubata data hwakaderedzwa zvakanyanya. Naizvozvo, kudzvanya kunobatsira kuderedza kusakara uye kubvaruka pane flash memory nekudzikisa huwandu hwenyama hwe data rakanyorwa kudhiraivha.
Kuti uwane rumwe ruzivo nezve mutsara uye peji compression muSQL Server yematafura uye indexes, ona .
Usakanganwa kuti chero compression inoda CPU zviwanikwa. Kana bandwidth inodiwa yakakwira, kudzvanya kunogona kuve nekukanganisa kwakakosha pakuita. Yakakwirira kunyora reshiyo yeOLAP mitoro yebasa inogona zvakare kuderedza mabhenefiti ekumanikidza kune SQL Server dhatabhesi.
Dell EMC yakatsvaga mari inogona kuchengetedza ichishandisa chaiyo-yepasirese yekudzikisa data mareti pane yeUnity array. Chikwata chakaunganidza data paVMware chaiwo muchina, kugovera faira, SQL Server dhatabhesi, Microsoft Hyper-V chaiyo muchina, nezvimwe.
Mhedzisiro yekudzidza yakaratidza kuti kudzikiswa kweSQL Server log faira saizi ingangoita ka10 idiki pane iyo data faira:
- Database size = 1,49:1 (32,96%)
- Log volume = 12,9:1 (92,25%)
Iyo SQL Server database yakapihwa mavhoriyamu maviri. Database mafaera anochengetwa pane rimwe vhoriyamu uye transaction matanda anochengetwa pane imwe. Kushandisa tekinoroji yekudzikisa data ine dhatabhesi mavhoriyamu anogona kupa kuchengetedza kuchengetedza; zvisinei, iwe unofanirwa kufunga nezve maitiro ekuita kana uchifunga kuti ungagonesa kudhiraivha pamavhoriyamu edatabase. Nepo chaiyo dhatabhesi saizi yekudzikisira inogona kusiyana zvichienderana nedata rakachengetwa, mhinduro dzechidzidzo dzakaratidza kuti SQL Server transaction log yekuchengetedza nzvimbo inogona. .
Kuderedza data maitiro akanaka
Usati wagonesa kudzikisa data pane chinhu chekuchengetedza, funga zvinotevera nhungamiro:
- Shandisa kuchengetedza system yekutarisa kuona kuti ine zviwanikwa zvekutsigira kuderedzwa kwedata.
- Ita kuti kuderedzwa kwedata kune akawanda ekuchengetedza zvinhu kamwechete. Tarisa sisitimu kuti uone kuti iri mumamiriro ekushanda anokurudzirwa usati waigonesa pane dzimwe nzvimbo dzekuchengetera.
- PaUnity XT x80F modhi, kuderedzwa kwedata kunopa kuchengetedza kwehuwandu kana data iri muchikamu chekuchengetera rikamanikidzwa neinosvika 1%.
Kudzikiswa kwedhata pane yapfuura Unity x80F modhi inomhanya OE 5.0 yakapa chengetedzo chero bedzi iyo data yaive ingangoita makumi maviri neshanu muzana.
- Usati wagonesa kuderedzwa kwedata pane chinhu chekuchengetedza, tarisa kana chinhu chacho chine data inobatika. Mamwe marudzi edata, akadai sevhidhiyo, odhiyo, mifananidzo, uye bhinari data, kazhinji inopa bhenefiti shoma kubva mukumanikidza. Usagone kugonesa kuderedza data pane chinhu chekuchengetedza kana pasina nzvimbo yekuchengetedza.
- Funga nekusarudza kudzvanya vhoriyamu yefaira data rinowanzo kumanikidza zvakanaka.
VMware Virtualization
VMware vSphere ipuratifomu inoshanda uye yakachengeteka yekuona uye makore nharaunda. Izvo zvakakosha zvevSphere iVMware vCenter Server uye VMware ESXi hypervisor.
vCenter Server inzvimbo yakabatana manejimendi yevSphere nharaunda. Zviri nyore kuendesa uye proactively optimize zviwanikwa. ESXi ndeye yakavhurika sosi hypervisor iyo inoisa zvakananga pamaseva emuviri. ESXi ine mukana wakananga kune zvakakosha zviwanikwa uye idiki muhukuru pa150MB, ichideredza ndangariro zvinodiwa. Inopa mashandiro akavimbika kune akasiyana-siyana ekushandisa basa uye inotsigira ane simba chaiwo muchina masisitimu-kusvika ku128 vCPUs, 6 TB ye RAM, uye zana nemakumi maviri emidziyo.
Kuti SQL Server ishande zvinobudirira pane zvemazuva ano Hardware, iyo SQL Server inoshanda sisitimu (SQLOS) inofanirwa kunzwisisa dhizaini yehardware. Nekuuya kweakawanda-musimboti uye akawanda-node asiri-uniform memory access (NUMA) masisitimu, kunzwisisa hukama pakati pemacores, anonzwisisika processors, uye emuviri processors kwave kwakakosha zvakanyanya.
Processors
Virtual Processing Unit (vCPU) ndeyechokwadi yepakati yekugadzirisa unit inopihwa kune chaiwo muchina. Huwandu hwese hwemavCPU akapihwa akaverengerwa se:
Total vCPU = (ΠΊΠΎΠ»ΠΈΡΠ΅ΡΡΠ²ΠΎ Π²ΠΈΡΡΡΠ°Π»ΡΠ½ΡΡ
ΡΠΎΠΊΠ΅ΡΠΎΠ²) * (ΠΊΠΎΠ»ΠΈΡΠ΅ΡΡΠ²ΠΎ Π²ΠΈΡΡΡΠ°Π»ΡΠ½ΡΡ
ΡΠ΄Π΅Ρ Π½Π° ΡΠΎΠΊΠ΅Ρ)Kana kuita kunoenderana kwakakosha, VMware inokurudzira kuti huwandu hwese hwevCPU hwakapihwa kune ese chaiwo muchina haufanire kudarika huwandu hwese hwemuviri macores anowanikwa pane ESXi host, asi iwe unogona kuwedzera huwandu hwevCPUs hwakagoverwa kana kuongorora kunoratidza kuti isina kushandiswa CPU zviwanikwa. zviripo.
Pane masisitimu ane Intel Hyper-Threading Technology inogoneswa, iyo nhamba yeane musoro cores (vCPUs) inopetwa kaviri nhamba yemuviri cores. Muchiitiko ichi, usagovera nhamba yose yevCPUs.
Yakaderera-tier SQL Server mitoro yebasa haina kukanganiswa nekusiyana kwe latency. Nekudaro, aya mabasa anogona kumhanyisa kune mauto ane chiyero chepamusoro chevCPU kune emuviri CPUs. Inonzwisisika CPU mashandisirwo mazinga anogona kuwedzera yakazara sisitimu kuburikidza, kuwedzera marezinesi ekuchengetedza, uye kuchengetedza kuita kwakaringana.
Intel Hyper-Threading kazhinji inovandudza huwandu hwevaenzi negumi muzana kusvika makumi matatu muzana, zvichikurudzira vCPU kune yemuviri CPU chiyero che10 kusvika 30. VMware inokurudzira kugonesa Hyper-Threading muUEFI BIOS pese pazvinogoneka kuitira kuti ESXi itore mukana wehunyanzvi uhu. VMware inokurudzirawo kunyatsoyedzwa uye kutarisa kana uchishandisa Hyper-Threading yeSQL Server mitoro yebasa.
ndangariro
Anenge ese maseva emazuva ano anoshandisa isina-uniform memory yekuwana (NUMA) architecture yekutaurirana pakati pekuyeuka kukuru uye processors. NUMA chivakwa chehardware chendangariro chakagovaniswa chinoisa kupatsanurwa kwemabhuraki endangariro yemuviri pakati pevagadziri vemuviri. NUMA node imwe kana anopfuura eCPU sockets pamwe neblock yeakagoverwa memory.
NUMA yave ichikurukurwa nevakawanda mumakore gumi apfuura. Iko kuoma kwakaoma kweNUMA kunokonzerwa muchikamu chekushandiswa kubva kune vakasiyana vatengesi. Munzvimbo dzakasarudzika, NUMA kuomarara kunotemerwawo nehuwandu hwemagadzirirwo esarudzo uye akaturikidzana-kubva kune Hardware kuburikidza ne hypervisor kuenda kune yevaenzi inoshanda sisitimu uye pakupedzisira kune SQL Server application. Kunzwisisa kwakanaka kweNUMA hardware architecture inofanirwa kune chero SQL Server DBA inoshandisa virtualized SQL Server muenzaniso.
Kuti uwane kubudirira kukuru pamaseva ane nhamba huru ye cores, Microsoft yakaunza SoftNUMA. SoftNUMA software inokubvumira kugovera inowanikwa CPU zviwanikwa mukati meNUMA imwe chete mumanode akawanda eSoftNUMA. Sekureva kweVMware, SoftNUMA inoenderana neVMware's virtual NUMA (vNUMA) topology uye inogona kuwedzera kukwidziridza dhatabhesi injini scalability uye kuita kweakawanda mabasa ...
Kana uchiona VMware neSQL Server shandisa:
- Monitor virtual machines kuti uone yakaderera memory zviwanikwa zveSQL Server Database Injini. Iyi nyaya inokonzeresa kuwedzera kweI / O mashandiro uye kuderedzwa kwekuita.
- Kuti uvandudze mashandiro, dzivirira kukakavara kwendangariro pakati pemichina chaiyo nekudzivisa kuwandisa kwendangariro paESXi host level.
- Funga kutarisa iyo hardware NUMA yemuviri ndangariro kugoverwa kuti uone huwandu hwakanyanya hweyeuko hunogona kupihwa kune chaiwo muchina mukati memuviri NUMA miganhu.
- Kana kuwana kuita kwakakwana ndicho chinangwa chikuru, funga kuchengetedza ndangariro yakaenzana neyakagoverwa ndangariro. Iyi parameter yekumisikidza inovimbisa kuti iyo chaiyo muchina inogamuchira chete ndangariro yemuviri.
Virtualized kuchengetedza
Kumisikidza chengetedzo munzvimbo ine virtualized kunoda ruzivo rwezvivakwa zvekuchengetedza. Sezvakaita NUMA, iwe unofanirwa kunzwisisa kuti akasiyana mazinga eI/O anoshanda sei - mune iyi nyaya, kubva pakushandisa muVM, kusvika pakuverenga kwenyama uye kunyora kweruzivo pane inoenderera yekuchengetera svikiro.
vSphere inopa akati wandei masarudzo ekugadzirisa chengetedzo, ane maapplication anobatsira muSQL Server kuita neiyo Unity XT array. FS VMFS ndiyo inonyanya kushandiswa nzira yekuchengetedza data mumabhuroka ekuchengetera masisitimu akadai Unity XT. Iyo Unity XT array ndiyo yepasi tier ine madhiraivha emuviri akafumurwa nevSphere seane logic disks (mavhoriyamu). Unity XT mavhoriyamu akaumbwa seVMFS mavhoriyamu neESXi hypervisor. Vatariri veVMware vanogadzira imwe kana akawanda madhisiki (VMDKs) anounzwa kune yevaenzi sisitimu yekushandisa. RDM inobvumira muchina chaiwo kuti uwane zvakananga Unity XT block chengetedzo (kuburikidza neFC kana iSCSI) pasina fomati VMFS. VMFS uye RDM mavhoriyamu anogona kupa zvakafanana transaction throughput.
Kune NFS-yakavakirwa kuchengetedza kweESXi, Dell EMC inokurudzira kushandisa VMware NFS pachinzvimbo chese chinangwa cheNFS faira masisitimu. Muchina chaiwo unoshanda paSQL Server uye uchishandisa VMDK pane NFS data chitoro hauzive nezve iri pasi peNFS layer. Iyo yevaenzi inoshanda sisitimu inobata chaiwo muchina sevhavha yemuviri inomhanya Windows Server uye SQL Server. Madhisiki akagovaniswa efailover cluster muenzaniso masisitimu paNFS datastores haatsigirwe.
VMware vSphere Virtual Mavhoriyamu (VVols) inopa yakawedzera granular kudzora padanho remuchina, yakazvimirira pane inomiririra yemuviri ndangariro inomiririra (senge mavhoriyamu kana mafaira masisitimu). Array-based replication neVVols inotsigirwa kutanga neVVol 2.0 (vSphere 6.5). VVol dhisiki inogona kushandiswa pachinzvimbo cheiyo RDM dhisiki yekupa disk resource kune SQL Failover Cluster muenzaniso kutanga nevSphere 6.7 nerutsigiro rwekuenderera mberi SCSI backup.
Virtualized network
Networking munyika chaiyo inoteedzera pfungwa dzakafanana sedzepasirese, asi inoshandisa software kwete tambo dzemuviri uye switch. Mhedzisiro yetiweki latency paSQL Server mitoro yebasa inogona kusiyana zvakanyanya. Kutarisisa network performance metrics pane iripo basa rekuita kana yakanyatso itwa yekuyedza sisitimu pamusoro pemumiriri nguva inobatsira mukugadzira chaiyo network.
Paunenge uchishandisa VMware virtualization neSQL Server, funga zvinotevera:
- Ose ari maviri akajairwa uye akagovaniswa madhijiti anopa mashandiro anodiwa neSQL Server.
- Kuti uparadzanise manejimendi zvine musoro, vSphere vMotion, uye network yekuchengetedza traffic, shandisa VLAN tagging uye virtual switch port mapoka.
- VMware inokurudzira zvakasimba kugonesa mafuremu mahombe pane chaiwo switch uko vSphere vMotion traffic kana iSCSI traffic inogoneswa.
- Kazhinji, tevera mirairo yetiweki yevaenzi masisitimu anoshanda uye hardware.
mhedziso
SQL Server dhatabhesi nharaunda dziri kuramba dzichikura uye dzakaoma kunzwisisa. MuSQL Server 2019, Microsoft yakavandudza maficha eSQL Server uye yakawedzera zvitsva, serutsigiro rwekuremerwa kwedata hombe neApache Spark uye HDFS. Dell EMC, yakabatana neMicrosoft, inoenderera mberi nekupa izvo zvinodikanwa zvemukati zveiyo SQL Server nharaunda - maseva, kuchengetedza uye network.
Isu tinoona kuwedzera kwakakosha muuptime uye kudzikiswa kwemutengo wakazara wevaridzi (TCO) apo vashandi vekuchengetedza uye dhatabhesi vanoshanda pamwechete kugadzira zvigadziriso zveSQL Server pamapuratifomu ekuchengetera akagovaniswa. Iyo Dell EMC Unity XT yese-flash array ndeye yepakati-renji mhinduro yakakodzera SQL Server vanogadzira uye maneja vanoda kuita kwepamusoro uye kuderera latency. Yakagadzirwa kuti imhanye pane ese madhiraivha, Unity XT Yese-Flash inotsigira maviri CPUs, maviri maviri controller masisitimu, uye akawanda-musimboti optimization.
Kuwedzera, masangano ari kuvandudza magariro avo eSQL Server. Kunyangwe virtualization inowedzera imwe dhizaini dhizaini kune yekuvaka stack, inopa zvakakosha mabhenefiti. Isu tinovimba iwe unowana mamwe anonyanya kushandiswa VMware maficha uye maturusi anoratidzwa pamusoro anobatsira muSQL Server nharaunda. Isu tinokurudzirawo zvinongedzo kune zviwanikwa kuti uwane rumwe ruzivo rwakadzama.
Useful links
Dell EMC
- (peji yechigadzirwa)
- (Youtube)
VMWare
Microsoft
Source: www.habr.com