Niaj hnub no peb yuav qhia koj txog cov yam ntxwv ntawm kev siv SQL Server 2019 nrog Unity XT qhov system cia, thiab tseem muab cov lus pom zoo ntawm virtualizing SQL Server siv VMware thev naus laus zis, teeb tsa thiab tswj cov khoom siv tseem ceeb ntawm Dell EMC infrastructure.
Hauv xyoo 2017, Dell EMC thiab VMware tau tshaj tawm cov txiaj ntsig ntawm kev tshawb fawb ntawm cov ncauj lus thiab kev hloov pauv ntawm SQL Server - "SQL Server Transformation: Towards Agility and Resilience" (), uas tau siv cov kev paub dhau los ntawm lub zej zog ntawm cov tswv cuab ntawm Cov Kws Tshaj Lij Tshaj Lij ntawm SQL Server (PASS). Cov txiaj ntsig tau pom tias SQL Server database ib puag ncig tau loj hlob nyob rau hauv ob qho tib si loj thiab nyuaj, uas tau tsav los ntawm kev nce cov ntaub ntawv ntim thiab cov kev lag luam tshiab. SQL Server databases tam sim no tau muab tso rau hauv ntau lub tuam txhab, siv lub hom phiaj tseem ceeb, thiab feem ntau yog lub hauv paus ntawm kev hloov pauv digital.
Txij li qhov kev tshawb fawb no tau ua tiav, Microsoft tau tshaj tawm cov tiam tom ntej ntawm DBMS - SQL Server 2019. Ntxiv rau kev txhim kho cov haujlwm yooj yim ntawm cov cav sib txuas thiab cov ntaub ntawv khaws cia, cov kev pabcuam tshiab thiab cov haujlwm tau tshwm sim. Piv txwv li, SQL Server 2019 suav nrog kev txhawb nqa rau cov ntaub ntawv loj ua haujlwm siv Apache Spark thiab Hadoop Distributed File System (HDFS).
Alliance Dell EMC thiab Microsoft
Dell EMC thiab Microsoft muaj kev sib koom tes ntev hauv kev tsim cov kev daws teeb meem rau SQL Server. Ua tiav kev siv cov txheej txheem kev qhia dav dav xws li Microsoft SQL Server yuav tsum muaj kev sib koom tes ntawm cov software ua haujlwm nrog cov hauv paus IT infrastructure. Cov txheej txheem no suav nrog cov txheej txheem ua lub zog, cov peev txheej nco, khaws cia thiab kev pabcuam network. Dell EMC muab SQL Server platform infrastructure rau txhua hom haujlwm thiab daim ntawv thov.
Dell EMC PowerEdge server kab muaj ntau yam processor thiab nco configurations. Cov kev teeb tsa no tsim nyog rau ntau yam kev ua haujlwm: los ntawm cov ntawv thov kev lag luam me mus rau lub luag haujlwm tseem ceeb tshaj plaws, xws li kev npaj peev txheej lag luam (ERP), cov ntaub ntawv warehouses, kev soj ntsuam siab heev, e-lag luam, thiab lwm yam. Cov kab cia yog tsim rau khaws cov ntaub ntawv tsis tsim nyog thiab cov txheej txheem.
Cov neeg siv khoom siv SQL Server 2019 nrog Dell EMC cov txheej txheem tuaj yeem ua haujlwm nrog cov ntaub ntawv tsim thiab tsis muaj qauv siv SQL Server thiab Apache Spark. SQL Server kuj txhawb kev sib txuas ntawm cov neeg siv khoom, server-to-server, thiab server-to-storage kev sib txuas lus thev naus laus zis. Dell EMC lub zeem muag yog ua raws li tus qauv sib cais uas muab qhov qhib ecosystem. Cov koom haum tuaj yeem xaiv los ntawm ntau yam kev lag luam tus qauv kev sib txuas lus, kev khiav hauj lwm systems thiab hardware platforms. Txoj hauv kev no muab rau koj tswj siab tshaj plaws ntawm cov thev naus laus zis thiab kev tsim vaj tsev, ua rau muaj txiaj ntsig tseem ceeb ntawm kev txuag nyiaj thiab hloov tau yooj yim.
VMware virtualizes tag nrho cov txheej txheem tseem ceeb uas SQL Server xav tau kom ua tiav kev ua haujlwm siab thiab ua haujlwm zoo sib xws. Ntxiv rau cov huab ntiag tug, VMware tseem tam sim no muaj cov qauv hybrid rau kev ua haujlwm, nthuav dav cov huab ntiag tug thiab pej xeem huab.
Ntau lub koom haum tab tom tig mus rau virtualization los txo cov nqi vaj tse, muab cov khoom muaj txiaj ntsig zoo, thiab ua kom yooj yim rau kev puas tsuaj rov qab. 94% ntawm SQL Server cov kws tshaj lij tau tshawb fawb qhia qee theem ntawm virtualization hauv lawv ib puag ncig. 70% ntawm cov neeg siv virtualization xaiv VMware. 60% muaj SQL Server virtualization qib ntawm 75% lossis ntau dua. Tsis tas li ntawd, cov txiaj ntsig kev tshawb fawb tau pom zoo tias muaj kev txaus siab thiab kev puas tsuaj rov qab los ntawm txheej txheej virtualization tau dhau los ua qhov tseem ceeb hauv kev txiav txim siab rau virtualize SQL Server databases.
Cov yam ntxwv tshiab hauv SQL Server 2019
SQL Server 2019 database platform suav nrog ntau yam thev naus laus zis, cov yam ntxwv, thiab cov kev pabcuam uas txhawb nqa lub hom phiaj tseem ceeb xws li kev tshuaj xyuas, kev lag luam databases, kev txawj ntse kev lag luam (BI), thiab kev ua lag luam scalable (OLTP). SQL Server platform tau txais kev muaj peev xwm los tswj cov ntaub ntawv kev sib koom ua ke, cov ntaub ntawv khaws cia, kev tshaj tawm thiab kev txheeb xyuas qib siab, muaj peev xwm rov ua dua, thiab kev tswj hwm cov ntaub ntawv ib nrab. Tau kawg, tsis yog txhua tus neeg siv lossis cov ntawv thov xav tau tag nrho cov yam ntxwv no. Tsis tas li ntawd, ntau zaus nws yog qhov zoo dua los cais SQL Server cov kev pabcuam siv virtualization.
Niaj hnub no, cov lag luam feem ntau yuav tsum tau tso siab rau ntau cov ntaub ntawv los ntawm ntau cov ntaub ntawv uas tau nce zuj zus. Nrog SQL Server 2019, koj tuaj yeem tau txais kev pom nyob ze ntawm lub sijhawm los ntawm tag nrho koj cov ntaub ntawv. SQL neeg rau zaub mov 2019 pawg muab ib puag ncig tag nrho rau kev ua haujlwm nrog cov ntaub ntawv loj, suav nrog kev siv tshuab kev kawm thiab kev txawj ntse txawj ntse. Cov yam ntxwv tshiab loj thiab hloov tshiab hauv SQL Server 2019 tau teev nyob rau hauv .
Dell EMC Unity XT Mid-Range Storage System
Dell EMC Unity cia series pib yuav luag peb xyoos dhau los, thiab txij li thaum ntawd ntau tshaj 40 lub tshuab tau raug muag. Cov neeg siv khoom txaus siab rau qhov mid-range array no rau nws txoj kev yooj yim, kev ua tau zoo thiab tus nqi-zoo. Dell EMC Unity XT midrange platforms yog cov kev daws teeb meem sib koom ua ke uas xa cov latency qis, siab dhau, thiab kev tswj hwm qis rau SQL Server workloads. Tag nrho Unity XT systems siv dual storage processor (SP) architecture los lis I / O thiab cov ntaub ntawv nquag / nquag ua haujlwm. Unity XT dual SP siv tag nrho sab hauv 000Gbps SAS kev sib txuas thiab cov txheej txheem ntau cov tub ntxhais kawm rau kev ua haujlwm siab thiab ua haujlwm zoo. Disk arrays tso cai rau koj los nthuav lub peev xwm cia siv cov txee ntxiv.
Dell EMC Unity XT, tiam tom ntej ntawm arrays (hybrid thiab all-flash), ua kom muaj kev ua tau zoo, txhim kho kev ua tau zoo, thiab ntxiv cov peev txheej tshiab thiab kev pabcuam rau ntau qhov chaw huab.
Lub Unity XT architecture tso cai rau koj los ua cov ntaub ntawv ib txhij, txo cov ntaub ntawv ntim, thiab txhawb cov kev pabcuam xws li rov ua dua yam tsis muaj kev cuam tshuam rau daim ntawv thov kev ua haujlwm. Piv nrog rau cov kev daws teeb meem yav dhau los, kev ua haujlwm ntawm Dell EMC Unity XT qhov system cia yog ob npaug thiab lub sijhawm teb yog 75% sai dua. Thiab tau kawg, Dell EMC Unity txhawb nqa NVMe tus qauv.
Lub kaw lus cia nrog NVMe drives qhia lawv qhov kev ua tau zoo tshaj plaws hauv latency-sensitive applications. Piv txwv li, hauv cov ntawv thov xws li cov ntaub ntawv loj heev, NVMe muab cov latency qis thiab cov ntaub ntawv siab tshaj plaws. Txo latency thiab nce concurrency ho txhim kho kev nyeem ntawv / sau ntawv. Nws tsis yog qhov xwm txheej uas, raws li IDC kev kwv yees, los ntawm 2021, flash arrays nrog NVMe thiab NVMe-oF (NVMe dhau Fabric) kev sib txuas yuav suav txog kwv yees li ib nrab ntawm tag nrho cov nyiaj tau los ntawm kev muag khoom ntawm cov khoom siv sab nraud hauv ntiaj teb.
Cov ntaub ntawv compression algorithms txhim kho kev khaws cia. Dell EMC Unity XT tuaj yeem txo cov ntaub ntawv ntim txog li tsib zaug. Lwm qhov taw qhia tseem ceeb yog kev ua haujlwm tag nrho ntawm qhov system. Dell EMC Unity XT siv 85% kev muaj peev xwm. Compression thiab deduplication yog ua nyob rau hauv hom inline - ntawm tus maub los theem. Cov ntaub ntawv tau txais kev cawmdim hauv daim ntawv compressed. Lub kaw lus kuj automates ua haujlwm nrog cov ntaub ntawv snapshots.
Ib qho yooj yim-rau-siv Unity flash arrays nrog kev koom ua ke (thaiv thiab cov ntaub ntawv) nkag tau muab lub sijhawm teb ruaj khov, koom ua ke nrog huab cia cov kev pabcuam, thiab txhawb kev hloov kho yam tsis muaj ntaub ntawv tsiv teb tsaws. Hauv nws qhov kev teeb tsa yooj yim, qhov kev khaws cia muaj ntau yam teeb tsa hauv 30 feeb.
Cov ntaub ntawv khaws cia thev naus laus zis hu ua "dynamic pas dej ua ke" tso cai rau koj txav los ntawm qhov zoo li qub mus rau lub cim xeeb nthuav dav, muab kev ua haujlwm siab thiab yooj yim ntawm kev ua kom muaj peev xwm. Dynamic pas dej ua ke txuag lub peev xwm thiab nyiaj txiag, thiab xav tau sijhawm tsawg dua los tsim kho. Kev nthuav dav thiab kev ua tau zoo ntawm Dell EMC Unity tsis xav tau cov ntaub ntawv tsiv teb tsaws.
Ntau lub tuam txhab niaj hnub no siv ntau qhov kev pabcuam huab huab rau pej xeem ua ke nrog lawv cov txheej txheem hauv tsev. Dell EMC Unity XT tuaj yeem ua haujlwm ua ib feem ntawm Dell Technologies Cloud ib puag ncig. Qhov kev khaws cia no tuaj yeem siv rau hauv huab huab thiab cov ntaub ntawv tuaj yeem xa mus rau huab ntiag tug. Tsis tas li ntawd, Dell EMC Unity XT cia yog muaj raws li kev pabcuam. Nov yog ib qho ntawm cov kev pabcuam huab cia ntawm Dell EMC Cloud Storage Services.
Huab cia tau dhau los ua neeg nyiam vim nws tuaj yeem txhim kho ROI los ntawm kev txo cov nqi vaj tsev. Cloud Storage Services txuas ntxiv cov neeg siv khoom 'cov ntaub ntawv chaw rau huab los ntawm kev xa Dell EMC cia (txuas ncaj qha mus rau pej xeem huab huab) ua kev pabcuam. Cov neeg muab kev pabcuam thib peb tuaj yeem muab kev kub ceev (tsawg latency) pej xeem huab sib txuas ncaj qha rau Dell EMC Unity, PowerMax thiab Isilon systems hauv cov neeg siv khoom cov ntaub ntawv.
Tsev neeg Unity XT suav nrog Unity XT All-Flash, Unity XT Hybrid, UnityVSA thiab Unity Cloud Edition systems.
Unified Hybrid thiab Flash Arrays
Intel-based Unity XT Hybrid thiab Unity XT All-Flash storage systems muab kev sib koom ua ke rau kev thaiv kev nkag, nkag mus rau cov ntaub ntawv, thiab VMware VVols nrog kev txhawb nqa rau kev sib txuas hauv network (NAS), iSCSI, thiab Fiber Channel (FC) raws tu qauv. Unity XT Hybrid thiab Unity XT All-Flash platforms yog NVMe-npaj.
Unity XT hybrid systems txhawb ntau qhov chaw huab. Multi-cloud txhais tau hais tias ncua kev cia rau huab lossis xa mus rau huab nrog cov kev xaiv siv tau yooj yim. Multicloud cia yog tsim los xyuas kom muaj kev txav mus los thiab cov ntaub ntawv nqa tau yooj yim ntawm ntau lub platform huab - ntiag tug thiab pej xeem. Qhov no cuam tshuam tsis tsuas yog cov txheej txheem ntawm cov ntaub ntawv txav, tab sis kuj yog lub koom haum ntawm kev thov nkag mus rau cov ntaub ntawv hauv ntau huab huab.
Cov hybrid arrays no muab cov peev txheej hauv qab no:
- Scalable rau 16 PB raw muaj peev xwm.
- Built-in cov ntaub ntawv txo cov peev xwm rau txhua lub pas dej flash.
- Kev teeb tsa sai thiab teeb tsa (qhov nruab nrab nws siv sijhawm 25 feeb).
SSD thev naus laus zis tau txhim kho sai, thiab cov khoom lag luam hloov pauv tshiab yuav ntaus lub lag luam hauv xyoo tom ntej. Nyob rau lub sijhawm no, cov koom haum yuav txuas ntxiv hloov cov HDDs nrog SSDs rau kev txhim kho kev ua haujlwm, yooj yim ntawm kev tswj hwm thiab txuag hluav taws xob. Cov tiam tshiab ntawm tag nrho-flash arrays yuav ua kom muaj kev cia siab ntau dua automation, kev sib koom ua ke huab huab pej xeem, thiab kev tiv thaiv cov ntaub ntawv sib xyaw.
Unity XT All-Flash systems xa ceev, kev ua haujlwm, thiab kev txhawb nqa huab ntau. Lawv nta:
- Ob chav tsim khoom.
- Cov ntaub ntawv txo mus txog 7: 1.
- Kev teeb tsa sai thiab teeb tsa (tus txheej txheem yuav siv sijhawm tsawg dua 30 feeb).
UnityVSA
UnityVSA yog software-txhais cia rau VMware ESXi virtual ib puag ncig siv server, sib koom, lossis huab cia muaj peev xwm. UnityVSA HA, ib tug dual-storage UnityVSA configuration, muab kev zam txim ntxiv. UnityVSA cia muab:
- Txog li 50 TB ntawm tag nrho-featured unified cia muaj peev xwm.
- Tau tshaj Unity XT tshuab thiab nta.
- Kev them nyiaj yug rau cov tshuab muaj siab (UnityVSA HA).
- Kev sib txuas ua NAS thiab iSCSI.
- Kev rov ua dua ntawm cov ntaub ntawv los ntawm lwm lub platform Unity XT.
Unity Cloud Edition
Rau cov ntaub ntawv synchronization thiab kev puas tsuaj rov ua haujlwm nrog huab, Unity XT tsev neeg suav nrog Unity Cloud Edition, uas muab:
- Lub peev xwm tshwj xeeb khaws cia uas siv software-txhais cia (SDS) tau xa mus rau hauv huab.
- Yooj yim xa cov thaiv thiab cov ntaub ntawv cia nrog VMware Cloud ntawm AWS.
- Kev them nyiaj yug kev puas tsuaj, suav nrog kev sim thiab tshuaj xyuas cov ntaub ntawv.
Unity XT Txhua Flash rau SQL Server
Unisphere Research's 2017 report, "SQL Server Transformation: Towards Agility and Resilience" () 22% ntawm cov neeg teb tau tshaj tawm tias lawv siv flash cia technology hauv kev tsim khoom (16%) lossis npaj ua li ntawd (6%). 30% siv hybrid arrays uas suav nrog flash nco. 13% siv ncaj qha txuas flash arrays. 13% thaub qab SQL Server databases rau flash cia.
Qhov kev txais yuav sai sai ntawm flash cia siv nrog SQL Server txhais tau hais tias Unity XT All-Flash arrays yog qhov tshwj xeeb zoo rau SQL Server developers thiab cov thawj coj. Unity XT All-Flash systems muab SQL Server cov neeg tsim khoom thiab cov thawj coj muaj peev xwm thiab kev ua tau zoo uas dhau mus dhau qhov chaw cia khoom sib txuas (SANs) muaj.
Unity XT All-Flash systems, uas yog NVMe-npaj (rau kev ua haujlwm siab dua thiab qis latency), muaj 2U daim ntawv zoo, txhawb nqa dual-core processors, ob tus tswj hauv kev ua haujlwm / nquag.
Unity XT All-Flash Models
Unity XT
Cov ua
Memory (rau processor)
Max. tus naj npawb ntawm cov tsav tsheb
Max. "raw" peev (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 Kub 6130
16c / 2.1 GHz
384
1,500
16.0
Cov ntsiab lus tuaj yeem pom nyob rau hauv array specifications ().
Cov pas dej cia
Ntau tus kws tshaj lij SQL Server paub tias txhua qhov chaw khaws cia niaj hnub no muab lub peev xwm los pab pawg disks rau hauv cov chaw khaws cia loj dua nrog qib RAID ruaj khov. Ib pawg disk nrog kev tiv thaiv RAID yog cov chaw khaws cia ib txwm muaj. Thaum Unity XT hybrid systems tsuas yog txhawb nqa cov pas dej ib txwm muaj, Unity XT All-Flash arrays kuj muaj cov pas dej dynamic. Nrog dynamic cia pas dej ua ke, RAID kev tiv thaiv yog siv rau disk extents - units ntawm cia me dua ib tug tag nrho disk. Dynamic pas dej ua ke muab kev yooj yim dua hauv kev tswj thiab nthuav cov pas dej disk.
Dell EMC muab cov kev coj ua zoo tshaj plaws rau kev tswj cov chaw cia khoom kom ua tiav qhov kev ua tau zoo tshaj plaws nrog qhov nyuaj tsawg. Piv txwv li, nws raug pom zoo kom txo tus naj npawb ntawm Unity XT cia cov pas dej kom txo tau qhov nyuaj thiab ua kom yooj yim dua. Txawm li cas los xij, teeb tsa lub pas dej ntxiv tuaj yeem muaj txiaj ntsig zoo hauv qee kis, suav nrog thaum koj xav tau:
- Txhawb kev ua haujlwm sib cais nrog I / O profile sib txawv.
- Faib cov peev txheej kom ua tiav qee qhov kev ua tau zoo.
- Dedicate nyias cov peev txheej rau multi-tenancy.
- Tsim cov ntawv me me los tiv thaiv kev ua tsis tiav
Cia ntim (LUNs)
Koj ua li cas sib npaug tswj thiab yoog raws thaum xaiv tus naj npawb ntawm cov ntim hauv ib qho array? Rau qhov siab tshaj plaws hauv kev sib sau nrog SQL Server, nws raug nquahu kom tsim cov ntim rau txhua cov ntaub ntawv database. Hauv kev xyaum, feem ntau cov koom haum siv txoj hauv kev sib tw, qhov twg cov ntaub ntawv tseem ceeb tau muab qhov yooj yim tshaj plaws thiab cov ntaub ntawv tseem ceeb tsawg tau muab faib ua ntau dua, ntau dua. Peb pom zoo kom tshuaj xyuas txhua qhov yuav tsum tau ua rau cov ntaub ntawv khaws cia thiab txhua daim ntawv thov cuam tshuam vim tias cov ntaub ntawv tiv thaiv thiab saib xyuas cov thev naus laus zis vam khom cov ntaub ntawv cais thiab tso chaw.
Ntau qhov ntim feem ntau yuav nyuaj rau tswj, tshwj xeeb tshaj yog nyob rau hauv ib puag ncig virtual. Virtualized SQL Server ib puag ncig yog ib qho piv txwv zoo ntawm qhov chaw hosting ntau hom ntaub ntawv ntawm ib lub ntim tuaj yeem ua rau kev nkag siab. Tus thawj tswj hwm cov ntaub ntawv lossis tus thawj tswj hwm khaws cia (lossis ob qho tib si) yuav tsum xaiv qhov sib npaug ntawm qhov yooj yim thiab kev tuav pov hwm thaum txiav txim siab cov ntim ntim los tsim.
Cov ntaub ntawv cia
NAS servers host file systems ntawm Unity XT cia. Cov txheej txheem ntaub ntawv tuaj yeem nkag tau siv SMB lossis NFS raws tu qauv, thiab nrog ntau cov txheej txheem cov ntaub ntawv, koj tuaj yeem siv ob qho tib si raws tu qauv. NAS servers siv virtual interfaces los txuas tus tswv tsev rau SMB, NFS, thiab ntau cov ntaub ntawv kab ke, nrog rau VMware NFS cia thiab VMware virtual ntim. Cov ntaub ntawv systems thiab virtual interfaces raug cais nyob rau hauv ib lub NAS servers, tso cai rau ntau lub NAS servers siv rau ntau tus neeg xauj tsev. NAS servers cia li ua tsis tiav yog tias lub chaw khaws cia ua tsis tiav. Lawv cov ntaub ntawv cuam tshuam kuj ua tsis tiav.
SQL Server 2012 (11.x) thiab tom qab versions txhawb Server Message Block (SMB) 3.0, uas tso cai rau cov ntaub ntawv sib koom ua ke rau kev khaws cia. Rau ob qho tib si standalone thiab kev teeb tsa tsis ua haujlwm, koj tuaj yeem nruab qhov system databases (tus tswv, qauv, msdb, thiab tempdb) thiab Database Engine cov neeg siv cov ntaub ntawv nrog SMB cia xaiv. Siv SMB cia yog qhov kev xaiv zoo thaum siv Cov Pab Pawg Nyob Ib Txhis vim tias cov ntaub ntawv sib qhia yuav tsum tau nkag mus rau cov peev txheej muaj nyob hauv network.
Tsim SMB cov ntaub ntawv sib koom rau SQL Server xa tawm nrog Unity XT cia yog txheej txheem peb kauj ruam yooj yim: koj tsim NAS server, cov ntaub ntawv kaw lus, thiab SMB sib koom. Dell EMC Unisphere Storage Management software suav nrog cov txheej txheem kev teeb tsa los pab koj ua tiav cov txheej txheem no. Txawm li cas los xij, thaum hosting SQL Server workloads ntawm SMB cov ntaub ntawv sib koom, muaj qee qhov kev txiav txim siab tseem ceeb uas yuav tsum nco ntsoov tias tsis tas siv rau kev siv SMB cov ntaub ntawv sib koom. Microsoft tau sau cov npe ntawm cov teeb meem kev teeb tsa thiab kev nyab xeeb nrog rau cov teeb meem paub tam sim no; Yog xav paub ntxiv, saib "Installing SQL Server with SMB File Storage" hauv .
Cov ntaub ntawv Snapshots
Cov ntaub ntawv tau dhau los ua lub tuam txhab cov peev txheej tseem ceeb tshaj plaws, thiab niaj hnub no lub hom phiaj tseem ceeb ib puag ncig xav tau ntau dua li kev rov ua dua tshiab. Nws yog ib qho tsim nyog kom cov ntawv thov nyob online ib txwm muaj, muab cov haujlwm tsis cuam tshuam thiab hloov kho tshiab. Lawv kuj xav tau kev ua haujlwm siab thiab muaj cov ntaub ntawv los ntawm kev xaiv xws li cov duab thaij duab hauv zos thiab cov chaw taws teeb replication.
Unity XT cia array muaj kev thaiv thiab cov ntaub ntawv snapshot muaj peev xwm sib koom ua haujlwm, kev ua haujlwm, thiab kev tsim vaj tsev. Unity's snapshot methodology muab txoj hauv kev yooj yim thiab siv tau los tiv thaiv cov ntaub ntawv. Snapshots ua kom yooj yim rau cov ntaub ntawv rov qab - yob rov qab mus rau ib qho snapshot ua ntej, lossis koj tuaj yeem luam cov ntaub ntawv xaiv los ntawm ib qho snapshot yav dhau los. Cov lus hauv qab no qhia txog lub sijhawm khaws cia rau Unity XT systems.
Local thiab tej thaj chaw deb cia cov ntaub ntawv snapshots
Hom duab
CLI
UI
SO
Manually
Teem Teev
Manually
Teem Teev
Manually
Teem Teev
Hauv zos
1 xyoo
1 xyoo
5 xyoo
4 lub lis piam
100 xyoo
Tsis txwv
Tej thaj chaw deb
5 xyoo
255 lub lis piam
5 xyoo
255 lub lis piam
5 xyoo
255 lub lis piam
Snapshots tsis yog hloov ncaj qha rau lwm txoj hauv kev tiv thaiv cov ntaub ntawv, xws li thaub qab. Lawv tsuas tuaj yeem ntxiv cov ntaub ntawv thaub qab ib txwm ua thawj kab ntawm kev tiv thaiv rau RTO qhov xwm txheej qis.
Dell EMC Unity snapshot feature suav nrog txo cov ntaub ntawv thiab kev txiav tawm siab heev. Snapshots kuj tau txais txiaj ntsig los ntawm qhov chaw txuag uas tau ua tiav ntawm qhov chaw cia khoom qub. Thaum koj nqa ib qho snapshot ntawm qhov chaw khaws cia uas txhawb nqa cov ntaub ntawv txo qis, cov ntaub ntawv ntawm qhov chaw tuaj yeem raug compressed lossis deduplicated.
Nov yog qee cov ntawv hais txog kev rov qab los ntawm cov ntaub ntawv thaum siv snapshots nrog SQL Server databases:
- Tag nrho cov khoom ntawm SQL Server database yuav tsum raug tiv thaiv raws li cov ntaub ntawv teev tseg. Thaum cov ntaub ntawv thiab cov ntaub ntawv teev cia nyob rau ntawm LUNs sib txawv, cov LUNs yuav tsum yog ib feem ntawm pab pawg sib xws. Ib pab pawg sib xws ua kom ntseeg tau tias cov duab thaij duab ib txhij ntawm txhua LUNs hauv pab pawg. Thaum cov ntaub ntawv thiab cov ntaub ntawv teev npe nyob ntawm ntau qhov sib koom SMB cov ntaub ntawv, cov kev sib koom yuav tsum nyob rau tib lub kaw lus.
- Thaum rov kho dua SQL Server database los ntawm qhov thaiv-raws li snapshot, yog tias SQL Server piv txwv yuav tsum txuas nrog, siv Unisphere host koom. Rau cov ntaub ntawv-raws li rov qab, ib qho ntxiv SMB qhia yog tsim siv lub snapshot ua qhov chaw. Thaum cov ntim tau teeb tsa, cov ntaub ntawv tuaj yeem txuas nrog lub npe sib txawv lossis cov ntaub ntawv uas twb muaj lawm tuaj yeem hloov nrog ib qho rov qab.
- Thaum ua qhov rov qab siv Snapshot Restore txoj hauv Unisphere, coj SQL Server piv txwv offline. SQL Server tsis paub txog kev ua haujlwm rov qab. Ua ib qho piv txwv offline xyuas kom meej tias cov ntim tsis puas los ntawm cov ntaub ntawv sau ua ntej rov qab. Thaum qhov piv txwv rov pib dua, SQL Server kev puas tsuaj rov qab yuav coj cov ntaub ntawv mus rau hauv lub xeev zoo ib yam.
- Pab kom snapshots rau ntau yam khoom khaws cia tib lub sijhawm, thiab tom qab ntawd xyuas kom meej tias lub kaw lus nyob rau hauv cov kev pom zoo ua haujlwm ua ntej ua kom cov snapshots ntxiv.
Automation thiab teem caij ntawm kev txhaj tshuaj
Snapshots hauv Unity XT tuaj yeem ua haujlwm. Cov kev xaiv snapshot hauv qab no muaj nyob rau hauv Unisphere kev tswj hwm cia: kev tiv thaiv ua ntej, kev tiv thaiv luv dua, thiab kev tiv thaiv ntev dua. Txhua qhov kev xaiv yuav siv cov snapshots txhua hnub thiab txuag lawv rau lub sijhawm sib txawv.
Koj tuaj yeem xaiv ib qho (lossis ob qho tib si) ntawm cov kev xaiv teem sijhawm - txhua x teev (ntawm 1 txog 24) thiab txhua hnub / txhua lub lim tiam. Txhua hnub / txhua lub limtiam snapshot teem sijhawm tso cai rau koj qhia lub sijhawm tshwj xeeb thiab hnub rau kev thaij duab. Rau txhua qhov kev xaiv xaiv, koj yuav tsum teeb tsa txoj cai tswj hwm, uas tuaj yeem teeb tsa kom rho tawm lub pas dej lossis khaws cia ib ntus.
Xav paub ntau ntxiv txog Unity snapshots - at .
Nyias clones
Ib tug nyias clone yog ib tug nyeem/sau daim ntawv luam ntawm ib tug nyias block chaw muab kev pab, xws li ib tug ntim, pab pawg neeg sib xws, los yog VMware VMFS datastore, uas qhia blocks nrog nws niam nws txiv cov kev pab. Nyias clones yog ib txoj hauv kev zoo kom sai thiab compactly nthuav tawm cov ntawv luam ntawm SQL Server database, ib yam dab tsi uas cov cuab yeej SQL Server ib txwm ua tsis tau. Thaum cov clone nyias tau nthuav tawm rau tus tswv tsev, cov ntim tuaj yeem coj mus rau hauv online thiab cov ntaub ntawv yuav raug txuas nrog siv DB Attach method hauv SQL Server.
Thaum siv cov kev hloov kho tshiab nrog nyias clones, nqa tag nrho cov databases ntawm nyias clone offline. Qhov no yuav tsum tau ua ua ntej kev ua haujlwm hloov tshiab. Kev ua tsis tiav ntawm cov ntaub ntawv offline ua ntej ua qhov kev hloov kho yuav ua rau cov ntaub ntawv tsis sib xws lossis cov ntaub ntawv tsis raug ntawm SQL Server.
Cov ntaub ntawv rov ua dua
Replication yog ib qho software feature uas synchronizes cov ntaub ntawv nrog ib tug tej thaj chaw deb system nyob rau tib lub site los yog lwm qhov chaw. Kev sib sau ua ke thiab kev teeb tsa kev xaiv tso cai rau koj xaiv txoj hauv kev kom ua tau raws li RTO / RPO cov cai rau SQL Server databases thaum ntsuas kev ua tau zoo thiab kev xa tawm.
Thaum siv Dell EMC Unity Replication los tiv thaiv SQL Server databases ntawm ntau qhov ntim, koj yuav tsum txwv tag nrho cov ntaub ntawv thiab sau cov ntim hauv cov ntaub ntawv mus rau ib pawg sib xws lossis cov ntaub ntawv. Replication yog tom qab ntawd teeb tsa rau ntawm pawg lossis cov ntaub ntawv kaw lus thiab tuaj yeem suav nrog ntim lossis sib koom ntawm ntau lub databases. Cov ntaub ntawv uas xav tau cov kev xaiv sib txawv yuav tsum yog ntawm LUNs cais, pab pawg sib xws, lossis cov ntaub ntawv.
Nyias clones yog sib xws nrog synchronous thiab asynchronous replication. Thaum ib tug nyias clone replicated mus rau ib qho chaw, nws yuav dhau los ua ib daim ntawv luam tag nrho ntawm cov ntim, pab pawg neeg sib xws, lossis VMFS cia. Tom qab replication, nyias clone yog ib tug kiag li ywj siab ntim nrog nws tus kheej chaw.
Cov txheej txheem ntawm nyias clone replication ntawm lub hauv paus thiab lub hom phiaj.
Replication ntawm tempdb database tsis tas yuav tsum tau vim hais tias cov ntaub ntawv yog rebuilt thaum SQL Server yog restarted, thiab yog li ntawd cov metadata tsis zoo ib yam nrog rau cov qauv ntawm lwm yam SQL neeg rau zaub mov. Ua tib zoo xaiv cov ntim kom rov ua dua thiab cov ntsiab lus ntawm cov ntim no tshem tawm cov tsheb tsis tsim nyog.
Integrated Microsoft SQL Server Data Copy Management
Cov khoom siv niaj hnub no feem ntau (suav nrog txhua yam khoom Dell EMC) tuaj yeem tsim "kev ua haujlwm zoo ib yam" cov ntawv luam ntawm txhua hom ntaub ntawv los ntawm:
- Kev sau ntawv zoo ib yam los ntawm kev ua haujlwm ntawm txhua qib - los ntawm tus tswv tsev mus rau tus tsav.
- Grouping ntim kom ntau cov ntaub ntawv ntawm cov ntim sib txawv tswj kev sau ntawv.
Nrog rau kev siv dav dav ntawm cov cuab yeej khaws cia, Microsoft tau tsim ib qho API rau cov chaw muab khoom cia. Qhov API no tso cai rau cov chaw muab kev pabcuam los koom tes nrog SQL Server database software los tsim "daim ntawv thov-raws li daim ntawv theej" siv Volume Shadow Copy Service (VSS). Cov ntawv theej no simulate kev sib cuam tshuam ntawm SQL Server thiab lub operating system thaum teem sijhawm thiab kaw ntawm SQL Server. Tag nrho cov ntawv sau buffers yog flushed thiab kev lag luam raug tshem tawm kom txog thaum tag nrho cov disks tau hloov kho thiab zoo ib yam ntawm qee lub sijhawm, uas tau sau tseg hauv SQL log.
Dell EMC AppSync software ua ke nrog Unity XT snapshots ua kom yooj yim thiab ua kom cov txheej txheem tsim, siv, thiab tswj cov ntawv thov sib xws ntawm cov ntaub ntawv ua haujlwm. Cov software no yog tsim los siv rau hauv kev tswj hwm cov xwm txheej rau cov ntaub ntawv rov qab thiab rov siv dua.
AppSync software cia li tshawb pom daim ntawv thov databases, kawm cov qauv database, thiab maps cov qauv ntaub ntawv los ntawm hardware lossis virtualization txheej rau hauv qab Unity XT cia. Nws orchestrates tag nrho cov kauj ruam tsim nyog, los ntawm kev tsim thiab txheeb xyuas ib daim ntawv theej mus rau mounting snapshots ntawm lub hom phiaj host thiab pib lossis rov kho cov ntaub ntawv. AppSync txhawb nqa thiab ua kom yooj yim rau SQL Server workflows uas suav nrog kev hloov kho thiab kho cov ntaub ntawv ntau lawm.
Kev txo cov ntaub ntawv thiab kev txiav tawm siab heev
Dell EMC Unity tsev neeg ntawm cov txheej txheem khaws cia muaj cov khoom muaj txiaj ntsig zoo, siv tau yooj yim-rau-siv cov kev pabcuam txo cov ntaub ntawv. Kev txuag tau ua tiav tsis yog ntawm kev teeb tsa thawj cov peev txheej khaws cia, tab sis kuj tseem nyob ntawm snapshots thiab nyias clones ntawm cov peev txheej no. Snapshots thiab nyias clones tau txais cov ntaub ntawv txo qhov chaw ntawm qhov chaw cia, uas ua rau kom muaj peev xwm txuag tau.
Cov ntaub ntawv txo cov khoom muaj xws li deduplication, compression, thiab xoom thaiv kev ua ub no, muaj peev xwm nce qhov chaw siv tau rau cov neeg siv khoom thiab kev siv sab hauv. Lub Unity XT cov ntaub ntawv txo qis hloov pauv qhov compression feature hauv Unity OE 4.3 thiab tom qab ntawd. Compression yog cov ntaub ntawv txo cov algorithm uas tuaj yeem txo qhov kev faib lub cev ntawm lub peev xwm xav tau los khaws cov ntaub ntawv.
Unity XT systems kuj muab qhov kev txiav tawm siab tshaj plaws uas tuaj yeem qhib tau yog tias txo cov ntaub ntawv raug qhib. Advanced deduplication txo lub peev xwm xav tau rau cov neeg siv cov ntaub ntawv los ntawm kev khaws cia me me ntawm cov ntawv luam (feem ntau tsuas yog ib daim ntawv luam) ntawm Unity cov ntaub ntawv thaiv. Lub cheeb tsam deduplication yog ib qho LUN. Ua qhov no rau hauv tus account thaum xaiv lub tswv yim cia. Tsawg dua LUNs ua rau kev txiav tawm zoo dua, tab sis ntau LUNs muab kev ua tau zoo dua.
Kev txuag hluav taws xob los ntawm kev txiav tawm siab dhau tuaj yeem muab cov txiaj ntsig zoo tshaj plaws hauv feem ntau ib puag ncig, tab sis kuj xav tau kev siv Unity array processors. Hauv OE 5.0, kev txiav tawm siab dhau los, thaum ua haujlwm, deduplicates ib qho thaiv (compressed lossis uncompressed). Yog xav paub ntxiv, saib .
Cov lus hauv qab no qhia txog kev txhawb nqa rau kev txo cov ntaub ntawv thiab kev txiav tawm siab tshaj:
Kev txo cov ntaub ntawv hauv Unity (tag nrho cov qauv) thiab txhim kho kev txhawb nqa deduplication
Unity OE version
Tshuab
Txhawb hom pas dej ua ke
Txhawb Cov Qauv
4.3 / 4.4
Cov ntaub ntawv txo
Flash nco pas dej - ib txwm los yog dynamic
300, 400, 500, 600, 300F, 400F, 500F, 600F, 350F, 450F, 550F, 650F
4.5
Cov ntaub ntawv txo
300, 400, 500, 600, 300F, 400F, 500F, 600F, 350F, 450F, 550F, 650F
Kev txo cov ntaub ntawv thiab kev txiav tawm siab heev *
450F, 550F, 650F
5
Cov ntaub ntawv txo
300, 400, 500, 600, 300F, 400F, 500F, 600F, 350F, 450F, 550F, 650F, 380, 480, 680, 880, 380F, 480F
Kev txo cov ntaub ntawv thiab kev txiav tawm siab heev
450F, 550F, 650F, 380, 480, 680, 880, 380F, 480F, 680F, 880F
* Kev txo cov ntaub ntawv yog neeg xiam oob qhab los ntawm lub neej ntawd thiab yuav tsum tau qhib ua ntej kev txiav tawm siab dhau los ua qhov kev xaiv muaj. Tom qab ua kom cov ntaub ntawv txo qis, qhov kev txiav tawm siab dhau los muaj, tab sis raug kaw los ntawm lub neej ntawd.
Kev txo cov ntaub ntawv hauv Unity thiab cov ntaub ntawv compression hauv SQL Server
SQL Server 2008 Enterprise Edition yog thawj qhov kev tso tawm los muab cov ntaub ntawv ib txwm muaj peev xwm compression. SQL neeg rau zaub mov 2008 kab-theem thiab nplooj-theem compression siv kev paub txog SQL Server sab hauv cov ntaub ntawv rooj hom kom txo tau qhov chaw siv los ntawm cov khoom siv database. Txo qhov chaw tso cai rau koj khaws ntau kab ib nplooj ntawv thiab ntau nplooj ntawv hauv lub pas dej tsis sib xws. Vim tias cov ntaub ntawv tsis khaws cia rau hauv 8k cov ntaub ntawv nplooj ntawv hom, xws li cov ntaub ntawv tawm sab nraud xws li NVARCHAR(MAX), yuav tsis siv kab lossis nplooj ntawv compression, Microsoft tau qhia txog Transact-SQL COMPRESS thiab DECOMPRESS zog.
Cov haujlwm no siv ib txwm siv cov ntaub ntawv compression mus kom ze (GZIP algorithm) uas yuav tsum tau hu rau txhua ntu ntawm cov ntaub ntawv kom compressed lossis decompressed.
Unity XT compression, uas tsis yog tshwj xeeb rau SQL Server, siv software algorithm los txheeb xyuas thiab nthuav cov ntaub ntawv khaws cia. Txij li thaum kev tso tawm ntawm Unity OE 4.1, Unity cov ntaub ntawv compression tau muaj rau thaiv cov ntim ntim thiab VMFS cov ntaub ntawv khaws cia hauv lub pas dej flash. Pib nrog Unity OE 4.2, compression kuj muaj rau cov ntaub ntawv kaw lus thiab NFS cov ntaub ntawv khaws cia hauv cov pas dej flash.
Kev xaiv cov ntaub ntawv compression txoj kev rau SQL Server nyob ntawm ntau yam. Cov yam tseem ceeb no suav nrog hom ntaub ntawv cov ntsiab lus, cov peev txheej CPU muaj - ob qho tib si ntawm kev khaws cia thiab ntawm cov chaw khaws ntaub ntawv, thiab I / O cov peev txheej yuav tsum tau tswj hwm SLA. Feem ntau, koj tuaj yeem cia siab tias qhov chaw txuag ntxiv rau cov ntaub ntawv uas yog compressed siv SQL Server, tab sis cov ntaub ntawv compressed siv TSQL's GZIP compression feature tsis zoo li yuav pom qhov tseem ceeb ntxiv qhov chaw txuag los ntawm Unity XT's compression nta txij li feem ntau ntawm cov txiaj ntsig tau los ntawm yav dhau los. algorithm.
Unity compression muab qhov chaw txuag yog tias cov ntaub ntawv ntawm cov khoom khaws cia yog compressed tsawg kawg yog 25%. Ua ntej koj ua kom compression ntawm cov khoom khaws cia, txiav txim siab seb nws puas muaj cov ntaub ntawv uas tuaj yeem compressed. Tsis txhob qhib compression rau ib qho khoom cia tshwj tsis yog ua li ntawd yuav txuag tau.
Thaum txiav txim siab seb yuav siv Unity cov ntaub ntawv txo, SQL Server database-theem compression, lossis ob qho tib si, xav txog cov hauv qab no:
- Cov ntaub ntawv uas sau rau hauv Unity system yog validated los ntawm tus tswv tsev tom qab nws tau muab cia rau hauv lub system cache. Txawm li cas los xij, cov txheej txheem compression tsis pib kom txog thaum lub cache raug tshem tawm.
- Kev txuag txuag tau ua tiav tsis yog rau Unity XT cov peev txheej khaws cia, tab sis kuj yog rau snapshots thiab nyias clones ntawm cov peev txheej.
- Thaum lub sij hawm compression txheej txheem, ntau cov blocks yog sib sau ua ke siv cov qauv algorithm los txiav txim seb cov ntaub ntawv puas tuaj yeem compressed. Yog tias qhov kev ua piv txwv txiav txim siab tias tsuas yog kev txuag nyiaj tsawg tuaj yeem ua tiav, ces compression raug hla thiab cov ntaub ntawv sau rau hauv pas dej ua ke.
- Thaum cov ntaub ntawv raug compressed ua ntej sau rau hauv cov ntaub ntawv khaws cia, cov ntaub ntawv tuav tau txo qis heev. Yog li ntawd, compression pab txo qhov hnav thiab tsim kua muag ntawm flash nco los ntawm kev txo lub cev ntawm cov ntaub ntawv sau rau tus tsav.
Yog xav paub ntxiv txog kab thiab nplooj ntawv compression hauv SQL Server rau cov ntxhuav thiab indexes, saib .
Tsis txhob hnov qab tias txhua qhov compression yuav tsum muaj peev txheej CPU. Thaum cov kev xav tau bandwidth siab, compression tuaj yeem muaj kev cuam tshuam loj rau kev ua haujlwm. Kev sau ntawv siab ntawm OLAP cov haujlwm tseem tuaj yeem txo cov txiaj ntsig ntawm compression rau SQL Server database.
Dell EMC tau tshawb fawb txog kev txuag nyiaj siv cov ntaub ntawv hauv ntiaj teb no txo tus nqi ntawm Unity array. Pab neeg no tau sau cov ntaub ntawv ntawm VMware virtual tshuab, sib qhia cov ntaub ntawv, SQL Server databases, Microsoft Hyper-V virtual machines, thiab lwm yam.
Cov txiaj ntsig ntawm txoj kev tshawb fawb tau pom tias qhov txo qis hauv SQL Server log cov ntaub ntawv loj yog yuav luag 10 npaug me dua cov ntaub ntawv cov ntaub ntawv:
- Database loj = 1,49:1 (32,96%)
- Cov ntaub ntawv ntim = 12,9: 1 (92,25%)
Lub SQL Server database tau muab nrog ob ntim. Database cov ntaub ntawv khaws cia rau ntawm ib lub ntim thiab cov ntaub ntawv sib pauv tau muab khaws cia rau lwm qhov. Siv cov cuab yeej txo cov ntaub ntawv nrog cov ntaub ntawv ntim tuaj yeem muab kev khaws cia; Txawm li cas los xij, koj yuav tsum xav txog qhov cuam tshuam kev ua haujlwm thaum txiav txim siab seb puas yuav pab kom deduplication ntawm cov ntaub ntawv ntim. Txawm hais tias qhov tseeb cov ntaub ntawv txo qhov loj me tuaj yeem sib txawv raws li cov ntaub ntawv khaws cia, qhov kev tshawb fawb tau pom tias SQL Server kev lag luam log cia qhov chaw tuaj yeem .
Kev txo cov ntaub ntawv zoo tshaj plaws
Ua ntej koj pab txo cov ntaub ntawv ntawm cov khoom khaws cia, xav txog cov lus qhia hauv qab no:
- Siv lub kaw lus cia saib xyuas kom ntseeg tau tias nws muaj peev xwm los txhawb cov ntaub ntawv txo.
- Pab kom txo cov ntaub ntawv rau ntau yam khoom khaws cia ib zaug. Saib xyuas lub kaw lus kom paub tseeb tias nws nyob rau hauv kev pom zoo ua haujlwm ua ntej ua kom nws nyob rau ntawm qhov chaw cia ntxiv.
- Ntawm Unity XT x80F cov qauv, cov ntaub ntawv txo qis yuav muab kev txuag nyiaj yog tias cov ntaub ntawv hauv chav tsev khaws cia yog compressed tsawg kawg yog 1%.
Kev txo cov ntaub ntawv ntawm yav dhau los Unity x80F qauv khiav OE 5.0 muab kev txuag nyiaj ntev npaum li cov ntaub ntawv tsawg kawg yog 25% compressible.
- Ua ntej koj pab kom txo cov ntaub ntawv ntawm cov khoom khaws cia, txiav txim siab seb cov khoom puas muaj cov ntaub ntawv compressible. Qee cov ntaub ntawv hom, xws li video, suab, dluab, thiab binary cov ntaub ntawv, feem ntau muab kev pab me ntsis los ntawm compression. Tsis txhob ua kom txo cov ntaub ntawv ntawm cov khoom khaws cia yog tias yuav tsis muaj chaw txuag.
- Xav txog kev xaiv compressing ib ntim ntawm cov ntaub ntawv cov ntaub ntawv uas feem ntau compresses zoo.
VMware Virtualization
VMware vSphere yog qhov ua tau zoo thiab ruaj ntseg platform rau virtualization thiab huab ib puag ncig. Cov khoom tseem ceeb ntawm vSphere yog VMware vCenter Server thiab VMware ESXi hypervisor.
vCenter Server yog kev tswj hwm kev sib koom ua ke rau vSphere ib puag ncig. Nws yog ib qho yooj yim rau deploy thiab proactively optimizes peev txheej. ESXi yog qhov qhib qhov hypervisor uas nruab ncaj qha rau ntawm lub cev servers. ESXi muaj kev nkag mus ncaj qha rau cov peev txheej tseem ceeb thiab yog qhov me me ntawm 150MB, txo qis qhov yuav tsum tau nco. Nws muab cov kev ua tau zoo txhim khu kev qha rau ntau yam kev thov ua haujlwm thiab txhawb nqa lub tshuab virtual muaj zog-txog 128 vCPUs, 6 TB ntawm RAM, thiab 120 cov khoom siv.
Rau SQL Server kom khiav tau zoo ntawm cov khoom siv niaj hnub no, SQL Server operating system (SQLOS) yuav tsum nkag siab txog kev tsim kho vajtse. Nrog rau qhov tshwm sim ntawm ntau cov tub ntxhais kawm thiab ntau qhov tsis sib xws ntawm lub cim xeeb nkag (NUMA), kev nkag siab txog kev sib raug zoo ntawm cov cores, cov txheej txheem tsim nyog, thiab cov txheej txheem lub cev tau dhau los ua qhov tseem ceeb tshwj xeeb.
Cov ua
Virtual Processing Unit (vCPU) yog lub hauv paus ua haujlwm virtual uas muab rau lub tshuab virtual. Tag nrho cov naj npawb ntawm vCPUs raug muab suav ua:
Total vCPU = (количество виртуальных сокетов) * (количество виртуальных ядер на сокет)Yog tias qhov ua tau zoo ib yam tseem ceeb, VMware xav kom tag nrho cov vCPUs muab rau txhua lub tshuab virtual yuav tsum tsis txhob tshaj tag nrho cov naj npawb ntawm lub cev muaj nyob ntawm ESXi tus tswv, tab sis koj tuaj yeem nce tus naj npawb ntawm vCPUs faib yog kev soj ntsuam qhia tias tsis siv CPU cov peev txheej. muaj.
Ntawm cov tshuab nrog Intel Hyper-Threading Technology enabled, tus naj npawb ntawm cov logical cores (vCPUs) yog ob npaug ntawm tus lej ntawm lub cev. Hauv qhov no, tsis txhob muab tag nrho cov vCPUs.
Lower-tier SQL Server workloads tsawg cuam tshuam los ntawm latency variability. Yog li, cov haujlwm no tuaj yeem khiav ntawm cov tswv nrog qhov sib piv siab ntawm vCPUs rau lub cev CPUs. Qhov tsim nyog siv CPU qib tuaj yeem nce tag nrho cov txheej txheem dhau los, ua kom cov ntawv tso cai txuag nyiaj ntau, thiab tswj kev ua haujlwm txaus.
Intel Hyper-Threading feem ntau txhim kho tag nrho cov tswv los ntawm 10% mus rau 30%, tawm tswv yim vCPU rau lub cev CPU piv ntawm 1,1 txog 1,3. VMware pom zoo kom ua kom Hyper-Threading hauv UEFI BIOS thaum twg ua tau kom ESXi tuaj yeem ua kom zoo dua ntawm cov thev naus laus zis no. VMware kuj pom zoo kom ua tib zoo kuaj thiab saib xyuas thaum siv Hyper-Threading rau SQL Server workloads.
nco
Yuav luag txhua cov servers niaj hnub no siv lub cim xeeb tsis sib xws (NUMA) architecture rau kev sib txuas lus ntawm lub cim xeeb loj thiab cov txheej txheem. NUMA yog ib qho khoom siv kho vajtse rau kev sib koom ua ke uas siv kev faib cov blocks ntawm lub cev nco ntawm lub cev processors. Ib qho NUMA node yog ib lossis ntau dua CPU sockets nrog rau ib qho thaiv ntawm cov cim xeeb.
NUMA tau yog lub ntsiab lus sib tham dav dav hauv kaum xyoo dhau los. Qhov sib txawv ntawm NUMA yog ib feem ntawm kev siv los ntawm cov neeg muag khoom sib txawv. Nyob rau hauv virtualized ib puag ncig, NUMA complexity kuj yog txiav txim los ntawm tus naj npawb ntawm configuration xaiv thiab txheej - los ntawm cov kho vajtse los ntawm lub hypervisor rau cov qhua khiav hauj lwm qhov system thiab thaum kawg mus rau SQL Server daim ntawv thov. Kev nkag siab zoo ntawm NUMA kho vajtse architecture yog qhov yuav tsum tau ua rau txhua tus SQL Server DBA khiav virtualized SQL Server piv txwv.
Txhawm rau ua tiav cov txiaj ntsig zoo dua ntawm cov servers nrog ntau tus cores, Microsoft tau qhia SoftNUMA. SoftNUMA software tso cai rau koj faib cov peev txheej CPU muaj nyob rau hauv ib qho NUMA rau ntau SoftNUMA nodes. Raws li VMware, SoftNUMA tau sib xws nrog VMware's virtual NUMA (vNUMA) topology thiab tuaj yeem ua kom zoo dua qub database cav scalability thiab kev ua tau zoo rau feem ntau cov haujlwm ...
Thaum virtualizing VMware nrog SQL Server siv:
- Saib xyuas cov tshuab virtual kom pom cov peev txheej nco tsawg rau SQL Server Database Engine. Qhov teeb meem no ua rau muaj kev ua haujlwm I / O nce ntxiv thiab txo kev ua haujlwm.
- Txhawm rau txhim kho kev ua tau zoo, tiv thaiv kev tsis sib haum xeeb ntawm cov tshuab virtual los ntawm kev zam lub cim xeeb dhau ntawm ESXi tus tswv tsev qib.
- Xav txog kev txheeb xyuas cov khoom siv kho vajtse NUMA lub cev lub cim xeeb faib los txiav txim siab qhov siab tshaj plaws ntawm lub cim xeeb uas tuaj yeem muab rau lub tshuab virtual hauv thaj tsam NUMA lub cev.
- Yog tias ua tiav qhov kev ua tau zoo txaus yog lub hom phiaj tseem ceeb, xav txog kev khaws cia sib npaug ntawm lub cim xeeb faib. Qhov kev teeb tsa no ua kom ntseeg tau tias lub tshuab virtual tsuas tau txais lub cim xeeb ntawm lub cev.
Virtualized cia
Kev teeb tsa chaw cia hauv ib puag ncig virtualized yuav tsum muaj kev paub txog kev cia khoom. Raws li nrog NUMA, koj yuav tsum nkag siab tias qhov sib txawv ntawm I / O ua haujlwm li cas - qhov no, los ntawm daim ntawv thov hauv VM, mus rau kev nyeem ntawv lub cev thiab sau cov ntaub ntawv ntawm qhov nruab nrab khaws cia tsis tu ncua.
vSphere muab ntau txoj kev xaiv rau kev teeb tsa chaw cia, uas muaj cov ntawv thov muaj txiaj ntsig hauv kev siv SQL Server nrog Unity XT array. FS VMFS yog cov ntaub ntawv khaws cia ntau tshaj plaws hauv kev thaiv cov kab ke xws li Unity XT. Lub Unity XT array yog qib hauv qab uas muaj lub cev drives nthuav tawm los ntawm vSphere raws li cov logical disks (ntim). Unity XT ntim yog formatted raws li VMFS ntim los ntawm ESXi hypervisor. VMware cov thawj coj tsim ib lossis ntau dua virtual disks (VMDKs) uas tau nthuav tawm rau cov qhua ua haujlwm. RDM tso cai rau lub tshuab virtual kom ncaj qha nkag mus rau Unity XT thaiv qhov chaw cia (ntawm FC lossis iSCSI) yam tsis muaj formatting VMFS. VMFS thiab RDM ntim tuaj yeem muab tib yam kev hloov pauv.
Rau NFS-based cia rau ESXi, Dell EMC pom zoo kom siv VMware NFS es tsis txhob siv lub hom phiaj NFS cov ntaub ntawv. Lub tshuab virtual khiav ntawm SQL Server thiab siv VMDK ntawm NFS cov ntaub ntawv khaws cia tsis paub txog cov txheej txheem NFS. Cov qhua ua haujlwm kho lub tshuab virtual ua lub cev server khiav Windows Server thiab SQL Server. Kev sib koom disks rau kev ua tsis tiav pawg piv txwv teeb tsa ntawm NFS datastores tsis txaus siab.
VMware vSphere Virtual Volumes (VVols) muaj kev tswj hwm ntau dua ntawm qib tshuab virtual, tsis muaj kev cuam tshuam ntawm lub cev lub cim xeeb sawv cev (xws li ntim lossis cov ntaub ntawv kaw lus). Array-based replication nrog VVols tau txais kev txhawb nqa pib nrog VVol 2.0 (vSphere 6.5). Ib qho VVol disk tuaj yeem siv los hloov RDM disk los muab cov ntaub ntawv disk rau SQL Failover Cluster piv txwv pib nrog vSphere 6.7 nrog kev txhawb nqa rau SCSI txuas ntxiv.
Virtualized networks
Kev sib tham hauv lub ntiaj teb virtual ua raws tib lub tswv yim zoo ib yam li hauv lub ntiaj teb lub cev, tab sis siv software es tsis yog lub cev cables thiab keyboards. Qhov cuam tshuam ntawm network latency ntawm SQL Server workloads tuaj yeem sib txawv heev. Kev soj ntsuam kev ntsuas kev ua haujlwm hauv network ntawm cov haujlwm uas twb muaj lawm lossis qhov kev sim ua tau zoo nyob rau lub sijhawm tus neeg sawv cev pab tsim lub network virtual.
Thaum siv VMware virtualization nrog SQL Server, xav txog cov hauv qab no:
- Ob tus qauv thiab faib cov hloov pauv virtual muab cov haujlwm ua haujlwm xav tau los ntawm SQL Server.
- Txhawm rau kom muaj kev sib cais ntawm kev tswj hwm, vSphere vMotion, thiab lub network cia tsheb khiav, siv VLAN tagging thiab virtual hloov chaw nres nkoj pawg.
- VMware pom zoo kom ua kom cov thav duab loj ntawm cov keyboards virtual uas vSphere vMotion tsheb lossis iSCSI tsheb khiav.
- Feem ntau, ua raws cov lus qhia kev sib txuas lus rau cov qhua ua haujlwm thiab kho vajtse.
xaus
SQL Server database ib puag ncig tau dhau los ua qhov loj thiab nyuaj. Hauv SQL Server 2019, Microsoft tau txhim kho SQL Server nta thiab ntxiv cov tshiab, xws li kev txhawb nqa rau cov ntaub ntawv loj nrog Apache Spark thiab HDFS. Dell EMC, koom tes nrog Microsoft, txuas ntxiv muab cov txheej txheem tsim nyog rau SQL Server ib puag ncig - servers, khaws cia thiab tes hauj lwm.
Peb pom qhov nce ntxiv hauv lub sijhawm ua haujlwm thiab txo nqi tag nrho ntawm cov tswv cuab (TCO) thaum khaws cia thiab cov kws tshaj lij database ua haujlwm ua ke los tsim cov kev daws teeb meem rau SQL Server ntawm kev sib koom ua ke. Dell EMC Unity XT tag nrho-flash array yog ib qho kev daws teeb meem nruab nrab haum rau SQL Server cov neeg tsim khoom thiab cov thawj coj uas xav tau kev ua haujlwm siab thiab qis latency. Tsim los khiav ntawm txhua lub flash drive, Unity XT All-Flash txhawb nqa dual CPUs, dual controller configurations, thiab multi-core optimization.
Ntau ntxiv, cov koom haum yog virtualizing lawv SQL Server ib puag ncig. Txawm hais tias virtualization ntxiv lwm txheej txheej tsim rau pawg architecture, nws muab cov txiaj ntsig tseem ceeb. Peb cia siab tias koj pom qee qhov feem ntau siv VMware nta thiab cov cuab yeej nthuav tawm saum toj no muaj txiaj ntsig hauv SQL Server ib puag ncig. Peb kuj pom zoo kom txuas mus rau cov peev txheej kom paub meej ntxiv.
Pab kev sib txuas lus
Dell EMC
- (Page khoom)
- (YouTube) Hmoob
VMware
Microsoft
Tau qhov twg los: www.hab.com