{"id":53529,"date":"2019-12-04T00:00:00","date_gmt":"2019-12-03T21:00:00","guid":{"rendered":"https:\/\/prohoster.info\/blog\/blog_prohoster\/microsoft-sql-server-2019-i-flesh-massivy-dell-emc-unity-xt"},"modified":"2020-02-18T14:01:26","modified_gmt":"2020-02-18T11:01:26","slug":"microsoft-sql-server-2019-i-flesh-massivy-dell-emc-unity-xt","status":"publish","type":"post","link":"https:\/\/prohoster.info\/lv\/blog\/administrirovanie\/microsoft-sql-server-2019-i-flesh-massivy-dell-emc-unity-xt","title":{"rendered":"Microsoft SQL Server 2019 un Dell EMC Unity XT fle\u0161a mas\u012bvi","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p>\u0160odien m\u0113s iepaz\u012bstin\u0101sim j\u016bs ar SQL Server 2019 izmanto\u0161anas iez\u012bm\u0113m ar Unity XT kr\u0101tuves sist\u0113mu, k\u0101 ar\u012b sniegsim ieteikumus SQL Server virtualiz\u0101cijai, izmantojot VMware tehnolo\u0123iju, par pamata infrastrukt\u016bras komponentu iestat\u012b\u0161anu un p\u0101rvald\u012bbu Dell EMC.<\/p>\n<p><noindex><a rel=\"nofollow\" href=\"https:\/\/habr.com\/ru\/company\/dell_emc\/blog\/478366\/\"><img decoding=\"async\" alt=\"Microsoft SQL Server 2019 un Dell EMC Unity XT fle\u0161a mas\u012bvi\" src=\"\/wp-content\/uploads\/2019\/12\/fe6c5fbfbfb8883ce3bcd215bff0f477.jpg\" style=\"display:block;margin: 0 auto;\" \/><\/a><\/noindex><br \/>\n2017. gad\u0101 Dell EMC un VMware public\u0113ja aptaujas rezult\u0101tus par SQL Server tendenc\u0113m un att\u012bst\u012bbu \u2014 \"SQL Server transform\u0101cija: ce\u013c\u0101 uz elast\u012bbu un iztur\u012bbu\" (<noindex><a rel=\"nofollow\" href=\"http:\/\/www.dbta.com\/DBTA-Downloads\/ResearchReports\/SQL-Server-Transformation-Toward-Agility-and-Resiliency-6705.aspx\">SQL Server Transformation: Toward Agility and Resiliency<\/a><\/noindex>), kur\u0101 tika izmantota Profesion\u0101l\u0101s SQL Server asoci\u0101cijas (Professional Association of SQL Server, PASS) kopienas pieredze. Rezult\u0101ti par\u0101da, ka SQL Server datub\u0101zu vidi palielin\u0101s gan izm\u0113rs, gan sare\u017e\u0123\u012bt\u012bba, ko nosaka pieaugo\u0161ie datu apjomi un jauni biznesa pras\u012bbas. SQL Server datub\u0101zes pa\u0161laik tiek izvietotas daudz\u0101s uz\u0146\u0113mumos, nodro\u0161inot kritiski svar\u012bgu lietojumprogrammu darb\u012bbu, un bie\u017ei vien kalpo par pamatu digit\u0101lajai transform\u0101cijai.\u00a0<\/p>\n<p>Laik\u0101, kad \u0161\u012b aptauja tika veikta, Microsoft izlaida n\u0101kamo datu b\u0101zu p\u0101rvald\u012bbas sist\u0113mu \u2014 SQL Server 2019. Papildus uzlabojumiem rel\u0101ciju dzin\u0113ja un datu kr\u0101tuves pamatfunkcij\u0101s par\u0101d\u012bj\u0101s jauni pakalpojumi un funkcijas. Piem\u0113ram, SQL Server 2019 ietver atbalstu liela apjoma datu slodzes apstr\u0101dei, izmantojot Apache Spark un Hadoop izplat\u012bto failu sist\u0113mu (Hadoop Distributed File System, HDFS).<br \/>\n<noindex><a rel=\"nofollow\" name=\"habracut\"><\/a><\/noindex><\/p>\n<h2>Dell EMC un Microsoft alianse<\/h2>\n<p>\nDell EMC un Microsoft ilgi sadarbojas SQL Server risin\u0101jumu izstr\u0101des jom\u0101. Sekm\u012bga Microsoft SQL Server kompleks\u0101s datu b\u0101zes platformas \u012bsteno\u0161ana prasa programmat\u016bras funkciju koordin\u0101ciju ar pamata IT infrastrukt\u016bru. \u0160\u012b infrastrukt\u016bra ietver procesoru apr\u0113\u0137inu jaudu, atmi\u0146as resursus, kr\u0101tuvi un t\u012bkla pakalpojumus. Dell EMC pied\u0101v\u0101 infrastrukt\u016bru SQL Server platformai jebkura veida datu slodzei un lietojumprogramm\u0101m.<\/p>\n<p>Dell EMC PowerEdge serveru l\u012bnija pied\u0101v\u0101 daudzas procesoru un atmi\u0146as konfigur\u0101cijas. \u0160\u012bs konfigur\u0101cijas ir piem\u0113rotas pla\u0161a spektra slodz\u0113m: no maz\u0101m korporat\u012bv\u0101m programm\u0101m l\u012bdz liel\u0101kaj\u0101m kritiski svar\u012bg\u0101m sist\u0113m\u0101m, piem\u0113ram, uz\u0146\u0113mumu resursu pl\u0101no\u0161anai (ERP), datu noliktav\u0101m, padzi\u013cin\u0101tai anal\u012btikai, e-komercijai un citiem. Glab\u0101\u0161anas sist\u0113mas ir paredz\u0113tas strukt\u016br\u0113tu un nestruktur\u0113tu datu uzglab\u0101\u0161anai.\u00a0<\/p>\n<p>Klienti, kas izv\u0113r\u0161 SQL Server 2019 ar Dell EMC infrastrukt\u016bru, var str\u0101d\u0101t ar struktur\u0113tiem un nestruktur\u0113tiem datiem, izmantojot SQL Server un Apache Spark. SQL Server ar\u012b atbalsta klientu piek\u013cuves tehnolo\u0123iju, starpservera komunik\u0101cijas un \u00abservera-glab\u0101tuves\u00bb komunik\u0101cijas kombin\u0101cijas. Dell EMC koncepcija balst\u0101s uz dezintegr\u0113tu modeli, kas pied\u0101v\u0101 atv\u0113rtu ekosist\u0113mu. Organiz\u0101cijas var izv\u0113l\u0113ties no pla\u0161a standarta nozares t\u012bkla lietojumprogrammu, oper\u0113t\u0101jsist\u0113mu un aparat\u016bras platformu kl\u0101sta. \u0160\u0101ds pieejas veids nodro\u0161ina maksim\u0101lu kontroli p\u0101r tehnolo\u0123ij\u0101m un arhitekt\u016br\u0101m, kas noved pie iev\u0113rojam\u0101m izmaksu ietaup\u012bjumiem un elast\u012bbas.<\/p>\n<p>VMware nodro\u0161ina visu kritiski svar\u012bgo infrastrukt\u016bras komponentu virtualiz\u0101ciju, kas nepiecie\u0161ama SQL Server augstas veiktsp\u0113jas un oper\u0101ciju konsekvences sasnieg\u0161anai. Papildus priv\u0101tajam m\u0101ko\u0146am, VMware \u0161obr\u012bd pied\u0101v\u0101 ar\u012b hibr\u012bdmode\u013cus, kas aptver priv\u0101t\u0101s un publisk\u0101s m\u0101ko\u0146u arhitekt\u016bras.\u00a0<\/p>\n<p>Daudzas organiz\u0101cijas izmanto virtualiz\u0101ciju, lai samazin\u0101tu infrastrukt\u016bras izmaksas, nodro\u0161in\u0101tu augstu pieejam\u012bbu un vienk\u0101r\u0161otu av\u0101rijas atjauno\u0161anu. 94% aptauj\u0101to SQL Server speci\u0101listu zi\u0146o par k\u0101du l\u012bmeni virtualiz\u0101cijas sav\u0101 vid\u0113. 70% no tiem, kas izmanto virtualiz\u0101ciju, izv\u0113l\u0113ju\u0161ies VMware. 60% virtualiz\u0101cijas l\u012bmenis SQL Server ir 75% un vair\u0101k. Turkl\u0101t aptaujas rezult\u0101ti p\u0101rliecino\u0161i liecina, ka augsta pieejam\u012bba un av\u0101rijas atjauno\u0161ana, kas \u012bstenota virtualiz\u0101cijas l\u012bmen\u012b, ir k\u013cuvusi par svar\u012bgiem faktoriem l\u0113muma pie\u0146em\u0161an\u0101 par SQL Server datu b\u0101zu virtualiz\u0101ciju.<\/p>\n<h2>Jaunas SQL Server 2019 funkcijas<\/h2>\n<p>\nSQL Server 2019 datu b\u0101zu platforma ietver pla\u0161u tehnolo\u0123iju, funkciju un pakalpojumu kl\u0101stu, kas atbalsta kritiskus pielietojumus, piem\u0113ram, anal\u012btiku, uz\u0146\u0113muma datub\u0101zes, biznesa anal\u012btiku (BI) un piel\u0101gojamu dar\u012bjumu apstr\u0101di (OLTP). SQL Server platforma ir ieguvusi iesp\u0113jas datu integr\u0101cijas p\u0101rvald\u012bbai, datu noliktav\u0101m, atskait\u0113m un papla\u0161in\u0101tai anal\u012btikai, replik\u0101cijas iesp\u0113j\u0101m un pusstruktur\u0113tu datu tipu p\u0101rvald\u012bbai. Protams, ne visiem klientiem vai pielietojumiem ir nepiecie\u0161amas visas \u0161\u012bs funkcijas. Turkl\u0101t daudzos gad\u012bjumos ir ieteicams atsevi\u0161\u0137i nodal\u012bt SQL Server pakalpojumus, izmantojot virtualiz\u0101ciju.\u00a0<\/p>\n<p>M\u016bsdien\u0101s uz\u0146\u0113mumiem bie\u017ei ir j\u0101pa\u013caujas uz lieliem datu apjomiem no pla\u0161a un nep\u0101rtraukti augo\u0161a datu kopumu. Ar SQL Server 2019 j\u016bs varat gandr\u012bz re\u0101l\u0101 laik\u0101 ieg\u016bt v\u0113rt\u012bgu inform\u0101ciju no visiem datiem. SQL Server 2019 klasteri nodro\u0161ina pilnv\u0113rt\u012bgu vidi, lai str\u0101d\u0101tu ar lieliem datu kopumiem, tostarp izmantojot ma\u0161\u012bnm\u0101c\u012b\u0161anos un m\u0101ksl\u012bg\u0101 intelekta iesp\u0113jas. Galven\u0101s jaun\u0101s funkcijas un atjaunin\u0101jumi SQL Server 2019 ir uzskait\u012bti <noindex><a rel=\"nofollow\" href=\"https:\/\/docs.microsoft.com\/ru-ru\/sql\/sql-server\/what-s-new-in-sql-server-ver15?view=sql-server-ver15\">Microsoft dokument\u0101<\/a><\/noindex>.<\/p>\n<h2>Dell EMC Unity XT vid\u0113j\u0101s klases uzglab\u0101\u0161anas sist\u0113ma<\/h2>\n<p>\nDell EMC Unity s\u0113rija tika laistas tirg\u016b pirms gandr\u012bz trim gadiem, un kop\u0161 t\u0101 laika ir p\u0101rdotas vair\u0101k nek\u0101 40 000 sist\u0113mu. Klienti nov\u0113rt\u0113ju\u0161i \u0161o vid\u0113j\u0101s klases mas\u012bvu par t\u0101 vienk\u0101r\u0161\u012bbu, veiktsp\u0113ju un ekonomiskumu. Dell EMC Unity XT vid\u0113j\u0101s klases platformas ir kop\u012bgas uzglab\u0101\u0161anas risin\u0101jumi, kas nodro\u0161ina zemu latentumu, augstu caurlaidsp\u0113ju un mazus p\u0101rvald\u012bbas izdevumus SQL Server slodz\u0113m. Visas Unity XT sist\u0113mas izmanto divu procesoru arhitekt\u016bru (storage processors, SP), lai apkalpotu I\/O un datu oper\u0101ciju izpildi akt\u012bv\u0101\/akt\u012bv\u0101 re\u017e\u012bm\u0101. Unity XT dual SP nodro\u0161ina augstu veiktsp\u0113ju un efektivit\u0101ti ar pilnu iek\u0161\u0113j\u0101s piesl\u0113g\u0161an\u0101s SAS 12 Gbit\/s un patent\u0113tu daudzkodolu arhitekt\u016bru. Disku mas\u012bvi \u013cauj papla\u0161in\u0101t uzglab\u0101\u0161anas ietilp\u012bbu, pievienojot papildus plauktus.<\/p>\n<p><img decoding=\"async\" alt=\"Microsoft SQL Server 2019 un Dell EMC Unity XT fle\u0161a mas\u012bvi\" src=\"\/wp-content\/uploads\/2019\/12\/d39fe24c2a392656402201d8957714bc.jpg\" style=\"display:block;margin: 0 auto;\" \/><br \/>\nDell EMC Unity XT, jaun\u0101s paaudzes mas\u012bvi (hibr\u012bdi un piln\u012bb\u0101 b\u016bv\u0113ti uz flash atmi\u0146as), b\u016btiski paaugstin\u0101ja veiktsp\u0113ju, uzlaboja efektivit\u0101ti, pievienoja jaunas iesp\u0113jas un pakalpojumus daudzm\u0101ko\u0146u vid\u0113m.\u00a0<\/p>\n<p>Unity XT arhitekt\u016bra \u013cauj vienlaikus apstr\u0101d\u0101t datus, samazin\u0101t to apjomus un atbalst\u012bt t\u0101dus pakalpojumus k\u0101 replik\u0101cija bez atbilsto\u0161as veiktsp\u0113jas samazin\u0101\u0161anas. Sal\u012bdzin\u0101jum\u0101 ar iepriek\u0161\u0113j\u0101s paaudzes risin\u0101jumu Dell EMC Unity XT veiktsp\u0113ja ir divk\u0101r\u0161ojusies, un atbildes laiks ir samazin\u0101jies par 75%. Protams, Dell EMC Unity atbalsta NVMe standartu.<\/p>\n<p>NVMe disku mas\u012bvi par\u0101da savas lab\u0101k\u0101s \u012bpa\u0161\u012bbas lietojumos, kas ir jut\u012bgi pret kav\u0113k\u013ciem. Piem\u0113ram, mas\u012bvos datos NVMe nodro\u0161ina zemas kav\u0113\u0161an\u0101s un augstas maksim\u0101l\u0101s datu p\u0101rraides \u0101trums. Kav\u0113\u0161an\u0101s samazin\u0101\u0161ana un paral\u0113lismu palielin\u0101\u0161ana b\u016btiski uzlabo las\u012b\u0161anas\/ierakst\u012b\u0161anas oper\u0101ciju veiktsp\u0113ju. Nav nejau\u0161i, ka IDC prognoze liecina, ka l\u012bdz 2021. gadam NVMe piesl\u0113guma un NVMe-oF (NVMe over Fabric) flash mas\u012bvi veidos aptuveni pusi no visiem p\u0101rdo\u0161anas ie\u0146\u0113mumiem no \u0101r\u0113j\u0101m uzglab\u0101\u0161anas sist\u0113m\u0101m pasaul\u0113.\u00a0<\/p>\n<p>Uzglab\u0101\u0161anas izmaksas uzlabo datu saspie\u0161anas algoritmi. Dell EMC Unity XT var samazin\u0101t datu apjomu l\u012bdz piec\u0101m reiz\u0113m. Cits svar\u012bgs r\u0101d\u012bt\u0101js ir sist\u0113mas kop\u0113j\u0101 efektivit\u0101te. Dell EMC Unity XT izmanto 85% no sist\u0113mas kapacit\u0101tes. Saspie\u0161ana un deduplication tiek veikta tie\u0161saist\u0113 \u2014 kontrolleru l\u012bmen\u012b. Dati tiek saglab\u0101ti saspiest\u0101 veid\u0101. Sist\u0113ma ar\u012b automatiz\u0113 datu att\u0113lu apstr\u0101di.<\/p>\n<p>Vienk\u0101r\u0161ie lieto\u0161an\u0101 Unity flash mas\u012bvi ar apvienotu (bloka un faila) piek\u013cuvi nodro\u0161ina stabilu atbildes laiku, integr\u0113jas ar m\u0101ko\u0146a uzglab\u0101\u0161anas pakalpojumiem, atbalsta moderniz\u0101ciju bez datu migr\u0101cijas. Pamata konfigur\u0101cij\u0101 \u0161\u012b univers\u0101l\u0101 uzglab\u0101\u0161anas sist\u0113ma tiek uzst\u0101d\u012bta 30 min\u016bt\u0113s.<\/p>\n<p>Datu uzglab\u0101\u0161anas tehnolo\u0123ija, ko sauc par \"dinamiskajiem baseiniem\", \u013cauj p\u0101riet no statiska uz dinamisku atmi\u0146as palielin\u0101\u0161anu, nodro\u0161ina augstu operat\u012bvo elast\u012bbu un vienk\u0101r\u0161\u012bbu sist\u0113mas kapacit\u0101tes palielin\u0101\u0161an\u0101. Dynamiskie baseini ietaupa kapacit\u0101ti un bud\u017eetu, prasa maz\u0101k laika p\u0101rveido\u0161anai. Dell EMC Unity kapacit\u0101tes un veiktsp\u0113jas palielin\u0101\u0161ana neprasa datu migr\u0101ciju.\u00a0<\/p>\n<p>Daudzas uz\u0146\u0113mumu \u0161odien, apvienojot savu lok\u0101lo infrastrukt\u016bru, izmanto vair\u0101kus publiskos m\u0101ko\u0146u pakalpojumus. Dell EMC Unity XT var darboties k\u0101 Dell Technologies Cloud m\u0101ko\u0146a vides komponents. \u0160o uzglab\u0101\u0161anas ier\u012bci var izmantot publiskaj\u0101 m\u0101ko\u0146\u0101 un p\u0101rvietot datus uz priv\u0101to m\u0101ko\u0146u. Turkl\u0101t Dell EMC Unity XT ir pieejams \u201ek\u0101 pakalpojums\u201d. Tas ir viens no Dell EMC Cloud Storage Services m\u0101ko\u0146u uzglab\u0101\u0161anas pakalpojumiem.<br \/>\n\u00a0<br \/>\nM\u0101ko\u0146u kr\u0101tuves k\u013c\u016bst arvien popul\u0101r\u0101kas, jo t\u0101s \u013cauj palielin\u0101t ieguld\u012bjumu atdevi, samazinot infrastrukt\u016bras izmaksas. Cloud Storage Services m\u0101ko\u0146u uzglab\u0101\u0161anas pakalpojumi papla\u0161ina klientu datu centrus l\u012bdz m\u0101ko\u0146iem, pied\u0101v\u0101jot Dell EMC uzglab\u0101\u0161anu (tie\u0161i savienotu ar publisk\u0101 m\u0101ko\u0146a resursiem) k\u0101 pakalpojumu. Tre\u0161o pu\u0161u sniedz\u0113ji var nodro\u0161in\u0101t \u0101tras savienojam\u012bbas (ar zemu latentumu) tie\u0161i starp publisko m\u0101ko\u0146u un Dell EMC Unity, PowerMax un Isilon sist\u0113m\u0101m klienta datu centr\u0101.<\/p>\n<p>Unity XT \u0123imen\u0113 ietilpst Unity XT All-Flash, Unity XT Hybrid, UnityVSA un Unity Cloud Edition sist\u0113mas.<br \/>\n\u00a0<\/p>\n<h2>Apvienotie hibr\u012bdie un fle\u0161-masi\u0146i\u00a0<\/h2>\n<p>\nUnity XT Hybrid un Unity XT All-Flash uzglab\u0101\u0161anas sist\u0113mas, kas balst\u012btas uz Intel procesoriem, ievie\u0161 integr\u0113tu arhitekt\u016bru bloka, failu piek\u013cuvei un VMware VVols apjoma atbalstam ar atbalstu t\u012bkla uzglab\u0101\u0161anas protokoliem (NAS), iSCSI un Fibre Channel (FC). Unity XT Hybrid un Unity XT All-Flash platformas ir gatavas NVMe kr\u0101tuves izmanto\u0161anai.<\/p>\n<p>Hibr\u012bdas Unity XT sist\u0113mas atbalsta darb\u012bbu multi-m\u0101ko\u0146u vid\u0113s. Multi-m\u0101ko\u0146u vides atbalsts noz\u012bm\u0113 datu uzglab\u0101\u0161anas sist\u0113mas papla\u0161in\u0101\u0161anu m\u0101ko\u0146os vai izvieto\u0161anu m\u0101ko\u0146os ar elast\u012bgiem resursu izmanto\u0161anas variantiem. Multi-m\u0101ko\u0146u uzglab\u0101\u0161anas risin\u0101jumi ir paredz\u0113ti, lai nodro\u0161in\u0101tu mobilit\u0101ti un datu p\u0101rnesam\u012bbu starp vair\u0101k\u0101m m\u0101ko\u0146u platform\u0101m \u2013 gan priv\u0101t\u0101m, gan publisk\u0101m. Tas ietekm\u0113 ne tikai datu p\u0101rvieto\u0161anu, bet ar\u012b to, k\u0101 lietojumprogrammas piek\u013c\u016bst datiem vair\u0101kos publiskos m\u0101ko\u0146os. <\/p>\n<p><img decoding=\"async\" alt=\"Microsoft SQL Server 2019 un Dell EMC Unity XT fle\u0161a mas\u012bvi\" src=\"\/wp-content\/uploads\/2019\/12\/d61d5fa31b94676109c89338070dbf0b.jpg\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n\u0160ie hibr\u012bdie mas\u012bvi pied\u0101v\u0101 \u0161\u0101das iesp\u0113jas:<\/p>\n<ul>\n<li>Papla\u0161in\u0101m\u012bba l\u012bdz 16 PB \u201eneapstr\u0101d\u0101t\u0101s\u201d ietilp\u012bbas.<\/li>\n<li>Ieb\u016bv\u0113tas datu apjoma samazin\u0101\u0161anas funkcijas visiem fle\u0161a pulkiem.<\/li>\n<li>\u0100tri uzst\u0101d\u012b\u0161ana un konfigur\u0101cija (vid\u0113ji tas aiz\u0146em 25 min\u016btes).<\/li>\n<\/ul>\n<p>\nCieto st\u0101vok\u013ca kr\u0101tuves tehnolo\u0123ijas \u0101tri att\u012bst\u0101s, un tuv\u0101kajos gados tirg\u016b par\u0101d\u012bsies jauni revolucion\u0101ri produkti. Tikm\u0113r organiz\u0101cijas turpin\u0101s nomain\u012bt tradicion\u0101los HDD diskus uz cietajiem diskiem, lai uzlabotu veiktsp\u0113ju, p\u0101rvald\u012b\u0161anas vienk\u0101r\u0161\u012bbu un energoefektivit\u0101ti. Jaun\u0101s paaudzes zibspuld\u017eu kr\u0101tuves izcelsies ar moderniz\u0113t\u0101m uzglab\u0101\u0161anas automatiz\u0101cijas, integr\u0101cijas ar publisko m\u0101ko\u0146u un ieb\u016bv\u0113tu datu aizsardz\u012bbas l\u012bdzek\u013ciem.\u00a0<\/p>\n<p>Unity XT All-Flash sist\u0113mas nodro\u0161ina augstu \u0101trumu, efektivit\u0101ti un vair\u0101ku m\u0101ko\u0146u atbalstu. To iez\u012bmes:<\/p>\n<ul>\n<li>Divk\u0101r\u0161ota veiktsp\u0113ja.<\/li>\n<li>Datu apjoma samazin\u0101\u0161ana l\u012bdz 7:1.<\/li>\n<li>\u0100tra uzst\u0101d\u012b\u0161ana un konfigur\u0101cija (process aiz\u0146em maz\u0101k nek\u0101 30 min\u016btes).<\/li>\n<\/ul>\n<p><\/p>\n<h2>\u00a0UnityVSA<\/h2>\n<p>\nUnityVSA sist\u0113ma ir programmat\u016bras defin\u0113ta glab\u0101\u0161anas sist\u0113ma (S\u0122S) virtu\u0101laj\u0101m vid\u0113m VMware ESXi, kas izmanto servera, koplietojamu vai m\u0101ko\u0146a uzglab\u0101\u0161anas jaudu. UnityVSA HA, konfigur\u0101cija ar div\u0101m UnityVSA kr\u0101tuv\u0113m, nodro\u0161ina papildu k\u013c\u016bmes notur\u012bbu. UnityVSA glab\u0101\u0161ana pied\u0101v\u0101:<\/p>\n<ul>\n<li>L\u012bdz 50 TB jaudas pilnv\u0113rt\u012bgai vienotai uzglab\u0101\u0161anai.<\/li>\n<li>Sader\u012bba ar Unity XT sist\u0113m\u0101m un funkcij\u0101m.<\/li>\n<li>Augstas pieejam\u012bbas sist\u0113mu atbalsts (UnityVSA HA).<\/li>\n<li>Savienojums k\u0101 NAS un iSCSI.<\/li>\n<li>Datu replik\u0101cija no cit\u0101m Unity XT platform\u0101m.<\/li>\n<\/ul>\n<p><\/p>\n<h2>Unity Cloud Edition<\/h2>\n<p>\nLai sinhroniz\u0113tu failus un izpild\u012btu \u0101rk\u0101rtas atjauno\u0161anas oper\u0101cijas m\u0101ko\u0146\u0101, Unity XT saime ietver Unity Cloud Edition versiju, kas nodro\u0161ina:<\/p>\n<ul>\n<li>Pilnv\u0113rt\u012bgas uzglab\u0101\u0161anas iesp\u0113jas, izmantojot programmat\u016bras defin\u0113tu glab\u0101\u0161anas sist\u0113mu (SDS), kas izvietota m\u0101ko\u0146os.<\/li>\n<li>Vienk\u0101r\u0161a bloku un failu kr\u0101tuves izvieto\u0161ana, izmantojot VMware Cloud AWS.<\/li>\n<li>Atskai\u0161u atjauno\u0161anas atbalsts, tostarp test\u0113\u0161ana un datu anal\u012bze.<\/li>\n<\/ul>\n<p>\n<img decoding=\"async\" alt=\"Microsoft SQL Server 2019 un Dell EMC Unity XT fle\u0161a mas\u012bvi\" src=\"\/wp-content\/uploads\/2019\/12\/0f866ce4aaac379a9bb8701e7367fd55.jpg\" style=\"display:block;margin: 0 auto;\" \/><\/p>\n<h2>Unity XT All Flash SQL Server<\/h2>\n<p>\n2017. gada Unisphere Research zi\u0146ojum\u0101 \"SQL Server transform\u0101cija: ce\u013c\u0101 uz elast\u012bbu un k\u013c\u016bmes notur\u012bbu\" (<noindex><a rel=\"nofollow\" href=\"http:\/\/www.dbta.com\/DBTA-Downloads\/ResearchReports\/SQL-Server-Transformation-Toward-Agility-and-Resiliency-6705.aspx\">SQL Server Transformation: Toward Agility and Resiliency<\/a><\/noindex>) 22% respondentu zi\u0146oja, ka vi\u0146i izmanto zibspuld\u017eu uzglab\u0101\u0161anas tehnolo\u0123iju ra\u017eo\u0161an\u0101 (16%) vai pl\u0101no to dar\u012bt (6%). 30% izmanto hibr\u012bda kr\u0101tuves, kas ietver zibspuld\u017eu atmi\u0146u. 13% izmanto zibspuld\u017eu kr\u0101tuves ar tie\u0161u piesl\u0113gumu. 13% veic SQL Server datu b\u0101zu rezerves kopijas zibspuld\u017eu uzglab\u0101\u0161an\u0101.<\/p>\n<p>T\u0101ds \u0101trs flash atmi\u0146as ievie\u0161ana SQL Server izmanto\u0161anai noz\u012bm\u0113, ka Unity XT All-Flash kopas ir \u012bpa\u0161i piem\u0113rotas SQL Server izstr\u0101d\u0101t\u0101jiem un administratoriem. Unity XT All-Flash sist\u0113mas nodro\u0161ina izstr\u0101d\u0101t\u0101jiem un administratoriem t\u0101das iesp\u0113jas un veiktsp\u0113ju, kas p\u0101rsniedz tipisko datu glab\u0101\u0161anas t\u012bklu (SAN) pied\u0101v\u0101to.<\/p>\n<p><img decoding=\"async\" alt=\"Microsoft SQL Server 2019 un Dell EMC Unity XT fle\u0161a mas\u012bvi\" src=\"\/wp-content\/uploads\/2019\/12\/7236f0c77513950c58d26dc5e86b20d5.jpg\" style=\"display:block;margin: 0 auto;\" \/><br \/>\nUnity XT All-Flash sist\u0113mas, kas ir gatavas NVMe ievie\u0161anai (pat v\u0113l augst\u0101kai veiktsp\u0113jai un zemai aizturei), ir 2U formfaktor\u0101, atbalsta divkodolu procesorus, divus kontrolierus akt\u012bvaj\u0101\/akt\u012bvaj\u0101 re\u017e\u012bm\u0101.<\/p>\n<p><b>Unity XT All-Flash mode\u013ci<\/b><\/p>\n<p>Unity XT\u00a0<\/p>\n<p>Procesori\u00a0<\/p>\n<p>Atmi\u0146a (uz procesoru)<\/p>\n<p>Maks. disku skaits<\/p>\n<p>Maks. \"neapstr\u0101d\u0101t\u0101\" kapacit\u0101te (PB)\u00a0<\/p>\n<p>380F\u00a0<\/p>\n<p>1 Intel E5-2603 v4\u00a0<br \/>\n6c\/1.7 GHz<\/p>\n<p>64\u00a0<\/p>\n<p>500\u00a0<\/p>\n<p>2.4\u00a0<\/p>\n<p>480F\u00a0<\/p>\n<p>2 Intel Xeon Silver\u00a0<br \/>\n4108 8c\/1.8 GHz\u00a0<\/p>\n<p>96\u00a0<\/p>\n<p>750\u00a0<\/p>\n<p>4.0\u00a0<\/p>\n<p>680F\u00a0<\/p>\n<p>2 Intel Xeon Silver\u00a0<br \/>\n4116 12c\/2.1 GHz<\/p>\n<p>192\u00a0<\/p>\n<p>1,000\u00a0<\/p>\n<p>8.0\u00a0<\/p>\n<p>880F\u00a0<\/p>\n<p>2 Intel Xeon Gold 6130\u00a0<br \/>\n16c\/2.1 GHz<\/p>\n<p>384\u00a0<\/p>\n<p>1,500\u00a0<\/p>\n<p>16.0\u00a0<\/p>\n<p>S\u012bk\u0101ku inform\u0101ciju var atrast kopas specifik\u0101cij\u0101s (<noindex><a rel=\"nofollow\" href=\"https:\/\/www.dellemc.com\/en-us\/collaterals\/unauth\/data-sheets\/products\/storage\/h17713_dell_emc_unity_xt_series_ss.pdf\">Dell EMC Unity XT Storage Series Specification Sheet<\/a><\/noindex>).<\/p>\n<h2>Datu glab\u0101\u0161anas baseini<\/h2>\n<p>\nDaudzi SQL Server profesion\u0101\u013ci zina, ka visi m\u016bsdienu uzglab\u0101\u0161anas kopas nodro\u0161ina iesp\u0113ju grup\u0113t diskus liel\u0101k\u0101s glab\u0101\u0161anas vien\u012bb\u0101s ar noteiktu RAID aizsardz\u012bbas l\u012bmeni. Atsevi\u0161\u0137as disku grupas ar RAID aizsardz\u012bbu ir tradicion\u0101lie glab\u0101\u0161anas baseini. Kam\u0113r hibr\u012bdas Unity XT sist\u0113mas atbalsta tikai tradicion\u0101los baseinus, Unity XT All-Flash kopas pied\u0101v\u0101 ar\u012b dinamiskos glab\u0101\u0161anas baseinus. Dinamiskajos glab\u0101\u0161anas baseinos RAID aizsardz\u012bba tiek piem\u0113rota diskus segmentiem \u2013 glab\u0101\u0161anas vien\u012bb\u0101m, kas ir maz\u0101kas par pilnu disku. Dinamiskie baseini nodro\u0161ina liel\u0101ku elast\u012bbu diskus baseinu p\u0101rvald\u012bb\u0101 un papla\u0161in\u0101\u0161an\u0101.\u00a0<\/p>\n<p>Dell EMC sniedz ieteikumus par glab\u0101\u0161anas baseinu p\u0101rvald\u012bbu, lai nodro\u0161in\u0101tu maksim\u0101lu veiktsp\u0113ju ar minim\u0101l\u0101m gr\u016bt\u012bb\u0101m. Piem\u0113ram, ieteicams samazin\u0101t Unity XT glab\u0101\u0161anas baseinu skaitu, lai samazin\u0101tu sare\u017e\u0123\u012bt\u012bbu un palielin\u0101tu elast\u012bbu. Tom\u0113r papildu glab\u0101\u0161anas baseinu iestat\u012b\u0161ana var b\u016bt \u013coti sapr\u0101t\u012bga da\u017eos gad\u012bjumos, tostarp, kad jums nepiecie\u0161ams:<\/p>\n<ul>\n<li>Atbalst\u012bt atsevi\u0161\u0137as darba slodzes ar at\u0161\u0137ir\u012bgiem I\/O profiliem.<\/li>\n<li>Izv\u0113l\u0113ties resursus, lai sasniegtu noteiktus veiktsp\u0113jas r\u0101d\u012bt\u0101jus.<\/li>\n<li>Izdal\u012bt atsevi\u0161\u0137us resursus multivides m\u0101konim.<\/li>\n<li>Izveidot maz\u0101kas dom\u0113nas, lai aizsarg\u0101tu no k\u013c\u016bmes.<\/li>\n<\/ul>\n<p><\/p>\n<h2>Glab\u0101\u0161anas apjomi (LUN)<\/h2>\n<p>\nK\u0101 atrast kompromisu starp p\u0101rvald\u012bbu un elast\u012bbu, izv\u0113loties apjomu skaitu mas\u012bv\u0101? Lai nodro\u0161in\u0101tu maksim\u0101lu elast\u012bbu Unity ar SQL Server, ieteicams veidot apjomus katram datu b\u0101zes failam. Praks\u0113 liel\u0101k\u0101 da\u013ca organiz\u0101ciju izmanto daudzk\u0101rt\u012bgu pieeju, kur kritiski svar\u012bgas datu b\u0101zes sa\u0146em maksim\u0101lu elast\u012bbu, bet maz\u0101k svar\u012bgo datu b\u0101zu faili tiek apkopoti maz\u0101k\u0101 skait\u0101 lielos apjomos. M\u0113s rekomend\u0113jam izp\u0113t\u012bt visus datu b\u0101\u017eu un ar t\u0101m saist\u012bto lietojumprogrammu pras\u012bbas, jo datu aizsardz\u012bbas un uzraudz\u012bbas tehnolo\u0123ijas ir atkar\u012bgas no failu izol\u0101cijas un izvietojuma.<\/p>\n<p>Daudzos apjomos bie\u017ei ir gr\u016bti p\u0101rvald\u012bt, \u012bpa\u0161i virtu\u0101laj\u0101s vid\u0113s. Virtualiz\u0113t\u0101s SQL Server vides ir labs piem\u0113rs tam, kad var b\u016bt j\u0113ga apvienot da\u017e\u0101da veida failus vien\u0101 apjom\u0101. Datu b\u0101zes administrators vai kr\u0101tuves administrators (vai abi) nosakot veidojamo apjomu skaitu, j\u0101izv\u0113las pareizais balanss starp elast\u012bbu un apkalpo\u0161anas \u0113rtumu.<\/p>\n<h2>Failu kr\u0101tuve<\/h2>\n<p>\nNAS serveri izvieto failu sist\u0113mas Unity XT kr\u0101tuves sist\u0113m\u0101. Failu sist\u0113m\u0101m var piek\u013c\u016bt, izmantojot SMB vai NFS protokolus, un pateicoties daudzprotokolu failu sist\u0113mai, var izmantot abus protokolus vienlaikus. Lai savienotu hostu ar SMB, NFS un daudzprotokolu failu sist\u0113m\u0101m, k\u0101 ar\u012b ar VMware NFS datu kr\u0101tuv\u0113m un VMware virtu\u0101lajiem apjomiem, NAS serveri izmanto virtu\u0101los interfeisus. Failu sist\u0113mas un virtu\u0101lie interfeisi ir izol\u0113ti viena NAS servera ietvaros, \u013caujot izmantot vair\u0101kus NAS serverus daudz\u012bpa\u0161nieku videi. NAS serveri autom\u0101tiski p\u0101rsl\u0113dzas, ja notiek k\u013c\u016bme, ja kr\u0101tuves procesors neizdodas. Ar tiem saist\u012bt\u0101s failu sist\u0113mas ar\u012b tiek p\u0101rsl\u0113gtas k\u013c\u016bmes gad\u012bjum\u0101.<\/p>\n<p>SQL Server 2012 (11.x) un jaun\u0101k\u0101s versijas atbalsta Server Message Block (SMB) 3.0 protokolu, kas \u013cauj kop\u012bgot t\u012bkla failus uzglab\u0101\u0161anai. Gan patst\u0101v\u012bgai uzst\u0101d\u012b\u0161anai, gan k\u013c\u016bdu tolerances kopklasterim varat uzst\u0101d\u012bt sist\u0113mas datu b\u0101zes (master, model, msdb un tempdb) un lietot\u0101ju datu b\u0101zes Database Engine ar SMB uzglab\u0101\u0161anas opciju. SMB uzglab\u0101\u0161ana ir laba iesp\u0113ja, ja izmantojat Always On Availability Groups augstas pieejam\u012bbas grup\u0101s, jo kop\u0113jam failu resursam ir nepiecie\u0161ama piek\u013cuve augsti pieejamam t\u012bkla resursam.<\/p>\n<p>SMB kop\u012bgo failu resursu izveide SQL Server izvieto\u0161anai ar Unity XT uzglab\u0101\u0161anu ir vienk\u0101r\u0161s tr\u012bs so\u013cu process: j\u0101izveido NAS servers, failu sist\u0113ma un SMB kop\u012bgo resurss. Dell EMC Unisphere Storage Management programmat\u016bra ietver iestat\u012b\u0161anas vedni, kas pal\u012bdz\u0113s veikt \u0161o procesu. Tom\u0113r, izvietojot SQL Server darba slodzes kop\u012bgo failu resursos SMB, nedr\u012bkst aizmirst par da\u017e\u0101m svar\u012bg\u0101m apsv\u0113rumiem, kas var neb\u016bt tie\u0161i saist\u012btas ar kop\u012bgo failu resursu izmanto\u0161anu. Microsoft ir izveidojusi uzst\u0101d\u012b\u0161anas un dro\u0161\u012bbas jaut\u0101jumu sarakstu kop\u0101 ar pa\u0161laik zin\u0101maj\u0101m probl\u0113m\u0101m; detaliz\u0113t\u0101k skatiet sada\u013c\u0101 \u201cSQL Server uzst\u0101d\u012b\u0161ana ar SMB failu uzglab\u0101\u0161anu\u201d dokumentos. <noindex><a rel=\"nofollow\" href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/database-engine\/install-windows\/install-sql-server-with-smb-fileshare-as-a-storage-option?view=sql-server-2017\">Microsoft dokumentos<\/a><\/noindex>.<\/p>\n<h2>Datu snapshots<\/h2>\n<p>\nDati ir k\u013cuvis par svar\u012bg\u0101ko uz\u0146\u0113mumu resursu, un m\u016bsdien\u0101s kritiskajiem vid\u0113m ir nepiecie\u0161ama ne tikai dubl\u0113\u0161ana. Ir nepiecie\u0161ams, lai lietojumprogrammas vienm\u0113r b\u016btu pieejamas, nodro\u0161inot nep\u0101rtrauktas darb\u012bbas un atjaunin\u0101jumus. T\u0101m ar\u012b ir nepiecie\u0161ama augsta datu veiktsp\u0113ja un pieejam\u012bba, izmantojot t\u0101das iesp\u0113jas k\u0101 viet\u0113j\u0101 snapshot replik\u0101cija un att\u0101l\u0101 replik\u0101cija.<\/p>\n<p>Unity XT uzglab\u0101\u0161anas sist\u0113ma pied\u0101v\u0101 snapshot veido\u0161anas iesp\u0113jas blokiem un failiem, kas izmanto kop\u012bgus darba pl\u016bsmus, oper\u0101cijas un arhitekt\u016bru. Unity snapshot metodolo\u0123ija nodro\u0161ina vienk\u0101r\u0161u un efekt\u012bvu veidu, k\u0101 aizsarg\u0101t datus. Snapshots atvieglo datu atjauno\u0161anu \u2014 varat atgriezties pie agr\u0101ka snapshot vai nokop\u0113t izv\u0113l\u0113tus datus no iepriek\u0161\u0113j\u0101 snapshot. N\u0101kamaj\u0101 tabul\u0101 ir nor\u0101d\u012bti snapshots glab\u0101\u0161anas laiki Unity XT sist\u0113m\u0101m.<\/p>\n<h2>Viet\u0113j\u0101 un att\u0101l\u0101 datu snapshots uzglab\u0101\u0161ana<\/h2>\n<p><\/p>\n<p>Snapshot tips<\/p>\n<p>flags -k integr\u0101cijai ar<br \/>\nUI<br \/>\nREST<\/p>\n<p>Rokasgr\u0101mata\u00a0<\/p>\n<p>Saska\u0146\u0101 ar grafiku\u00a0<\/p>\n<p>Rokasgr\u0101mata\u00a0<\/p>\n<p>Saska\u0146\u0101 ar grafiku\u00a0<\/p>\n<p>Rokasgr\u0101mata\u00a0<\/p>\n<p>Saska\u0146\u0101 ar grafiku\u00a0<\/p>\n<p>Viet\u0113jais\u00a0<\/p>\n<p>1 gads\u00a0<\/p>\n<p>1 gads<\/p>\n<p>5 gadi\u00a0<\/p>\n<p>4 ned\u0113\u013cas<\/p>\n<p>100 gadi<\/p>\n<p>Bez ierobe\u017eojumiem<\/p>\n<p>T\u0101lvad\u012bbas\u00a0<\/p>\n<p>5 gadi<\/p>\n<p>255 ned\u0113\u013cas\u00a0<\/p>\n<p>5 gadi<\/p>\n<p>255 ned\u0113\u013cas<\/p>\n<p>5 gadi<\/p>\n<p>255 ned\u0113\u013cas<\/p>\n<p>Momentuz\u0146\u0113mumi nav tie\u0161a aizvieto\u0161ana citiem datu aizsardz\u012bbas pa\u0146\u0113mieniem, piem\u0113ram, datu dubl\u0113\u0161anai. Tie var tikai papildin\u0101t tradicion\u0101lo datu dubl\u0113\u0161anu k\u0101 pirmo aizsardz\u012bbas l\u012bniju scen\u0101rijiem ar zemu RTO.<\/p>\n<p>Dell EMC Unity momentuz\u0146\u0113mumu funkcija ietver datu apjoma samazin\u0101jumu un papla\u0161in\u0101tu deduplication. Momentuz\u0146\u0113mumi ar\u012b g\u016bst labumu no vietas taup\u012b\u0161anas, kas tiek pan\u0101kta uz s\u0101kotn\u0113j\u0101 glab\u0101\u0161anas resursa. Kad j\u016bs veicat momentuz\u0146\u0113mumu uz glab\u0101\u0161anas resursa ar datu apjoma samazin\u0101\u0161anas funkcij\u0101m, dati avot\u0101 var tikt saspiesti vai deduplic\u0113ti.<\/p>\n<p>Apskat\u012bsim da\u017eus koment\u0101rus par datu b\u0101zes atjauno\u0161anu, izmantojot momentuz\u0146\u0113mumus ar SQL Server datu b\u0101z\u0113m:<\/p>\n<ul>\n<li>Visiem SQL Server datu b\u0101zes komponentiem j\u0101b\u016bt aizsarg\u0101tiem k\u0101 datu kopai. Kad datu faili un \u017eurn\u0101li atrodas da\u017e\u0101d\u0101s LUN, \u0161\u012bm LUN j\u0101b\u016bt da\u013cai no konsekventas grupas. Konsekventa grupa nodro\u0161ina, ka momentuz\u0146\u0113mums tiks veikts vienlaic\u012bgi vis\u0101m LUN grup\u0101. Kad datu faili un \u017eurn\u0101li atrodas vair\u0101kos kop\u012bgos SMB resursos, kop\u012bgie resursi j\u0101novieto vien\u0101 failu sist\u0113m\u0101.<\/li>\n<li>Atjaunojot SQL Server datu b\u0101zi no blokiem balst\u012bta momentuz\u0146\u0113muma, ja SQL Server instances j\u0101paliek piesl\u0113gtam, izmantojiet piesl\u0113g\u0161anos pie Unisphere hosta. Atjauno\u0161anai, balstoties uz failiem, tiek izveidots papildu kop\u012bgs SMB resurss, izmantojot momentuz\u0146\u0113mumu k\u0101 avotu. P\u0113c to piesl\u0113g\u0161anas datu b\u0101zes var pievienot ar citu nosaukumu vai aizst\u0101t eso\u0161o datu b\u0101zi ar atjaunoto.<\/li>\n<\/ul>\n<p><\/p>\n<ul>\n<li>Izmantojot atjauno\u0161anas metodi, izmantojot momentuz\u0146\u0113mumu atjauno\u0161anu Unisphere, p\u0101rvietojiet SQL Server instance uz bezsaistes re\u017e\u012bmu. SQL Server nezin par atjauno\u0161anas oper\u0101cij\u0101m. P\u0101rvieto\u0161anas instances uz bezsaistes re\u017e\u012bmu nodro\u0161ina, ka apjomi netiks boj\u0101ti datu b\u0101zes ierakst\u012b\u0161anas oper\u0101ciju laik\u0101 pirms atjauno\u0161anas. Tikl\u012bdz instances tiks restart\u0113ts, SQL Server av\u0101rijas atjauno\u0161ana noved\u012bs datu b\u0101zes uz saska\u0146otu st\u0101vokli.<\/li>\n<li>At\u013caujiet uzreiz izveidot moment\u0101nus att\u0113lus vair\u0101kiem kr\u0101tuves objektiem vienlaic\u012bgi, un pirms papildu att\u0113lu aktiviz\u0113\u0161anas, uzraugot sist\u0113mu, p\u0101rliecinieties, ka t\u0101 atrodas ieteiktajos darba re\u017e\u012bmos.<\/li>\n<\/ul>\n<p><\/p>\n<h2>Automatiz\u0101cija un att\u0113lu pl\u0101no\u0161ana<\/h2>\n<p>\nMoment\u0101nus att\u0113lus Unity XT var automatiz\u0113t. Uzglab\u0101\u0161anas p\u0101rvald\u012bbas sist\u0113m\u0101 Unisphere pieejamas \u0161\u0101das noklus\u0113juma att\u0113lu iesp\u0113jas: noklus\u0113juma aizsardz\u012bba, \u012bsa uzglab\u0101\u0161anas aizsardz\u012bba un gara uzglab\u0101\u0161anas aizsardz\u012bba. Katrs variants izveido ikdienas att\u0113lus un saglab\u0101 tos da\u017e\u0101dus laika periodus.<\/p>\n<p>Var izv\u0113l\u0113ties vienu (vai abus) pl\u0101no\u0161anas variantus \u2014 katras x stundas (no 1 l\u012bdz 24) un katru dienu \/ ned\u0113\u013cu. Ikdienas \/ ikned\u0113\u013cas moment\u0101no att\u0113lu pl\u0101no\u0161ana \u013cauj nor\u0101d\u012bt noteiktu laiku un dienas att\u0113lu izveidei. Katram izv\u0113l\u0113tajam variantam j\u0101nosaka uzglab\u0101\u0161anas politika, kas var b\u016bt konfigur\u0113ta autom\u0101tiskai baseina dz\u0113\u0161anai vai pagaidu uzglab\u0101\u0161anai.<\/p>\n<p>Papildu inform\u0101cija par Unity att\u0113liem \u2013 <noindex><a rel=\"nofollow\" href=\"https:\/\/www.dellemc.com\/en-us\/collaterals\/unauth\/white-papers\/products\/storage\/h15089-dell-emc-unity-snapshots-and-thin-clones.pdf\">Dell EMC Unity dokument\u0101cij\u0101<\/a><\/noindex>.\u00a0<\/p>\n<h2>Tievie kloni<\/h2>\n<p>\nTievais klons ir las\u0101m\u0101 \/ rakst\u0101maj\u0101 pieejama kopija tiev\u0101 bloka uzglab\u0101\u0161anas resursam, piem\u0113ram, apjomam, konsekventai grupai vai VMware VMFS datu kr\u0101tuvei, kas koplieto blokos ar vec\u0101ku resursu. Tievie kloni ir lielisks veids, k\u0101 \u0101tri un kompakti att\u0113lot SQL Server datub\u0101zes kopijas, ko nevar pan\u0101kt ar tradicion\u0101lajiem SQL Server r\u012bkiem. P\u0113c tam, kad tievais klons ir att\u0113lots serverim, apjomu var p\u0101rlikt darb\u012bbas re\u017e\u012bm\u0101 (tie\u0161saist\u0113), un datub\u0101ze tiks pievienota, izmantojot DB pievieno\u0161anas metodi SQL Server.<\/p>\n<p>Izmantojot atjaunin\u0101\u0161anas funkciju ar tievajiem kloniem, atsl\u0113dziet (iek\u013caujiet offline re\u017e\u012bm\u0101) visas datub\u0101zes, kas atrodas uz tiev\u0101 klona. To j\u0101dara pirms atjaunin\u0101\u0161anas oper\u0101cijas. Ja datub\u0101zes netiek p\u0101rliktas offline re\u017e\u012bm\u0101 pirms atjaunin\u0101\u0161anas, tas var izrais\u012bt datu neatbilst\u012bbu vai nepareizu datu rezult\u0101tu SQL Server.<\/p>\n<h2>Datu replik\u0101cija<\/h2>\n<p>\nReplik\u0101cija ir programmat\u016bras funkcija, kas sinhroniz\u0113 datus ar att\u0101lin\u0101tu sist\u0113mu taj\u0101 pa\u0161\u0101 objekt\u0101 vai cit\u0101 viet\u0101. Replik\u0101cijas un konfigur\u0101cijas parametri Unity \u013cauj izv\u0113l\u0113ties efekt\u012bvu risin\u0101jumu, lai apmierin\u0101tu RTO\/RPO pras\u012bbas SQL Server datub\u0101z\u0113m, saglab\u0101jot veiktsp\u0113jas un caurlaid\u012bbas l\u012bdzsvaru.<\/p>\n<p>Izmantojot Dell EMC Unity replik\u0101ciju SQL Server datub\u0101zu aizsardz\u012bbai uz vair\u0101k\u0101m apjomiem, ir j\u0101ierobe\u017eo visi dati un datub\u0101zu \u017eurn\u0101lu apjomi vien\u0101 konsekvent\u0101 grup\u0101 vai failu sist\u0113m\u0101. Tad replik\u0101cija tiek konfigur\u0113ta grup\u0101 vai failu sist\u0113m\u0101 un var ietvert apjomus vai kop\u012bgus resursus no vair\u0101k\u0101m datub\u0101z\u0113m. Datub\u0101z\u0113m, kur\u0101m nepiecie\u0161ami da\u017e\u0101di replik\u0101cijas parametri, j\u0101atrodas atsevi\u0161\u0137os LUN, konsekvent\u0101s grup\u0101s vai failu sist\u0113m\u0101s.<\/p>\n<p>Pl\u0101n\u0101s kopijas ir savietojamas gan ar sinhrono, gan ar asinhrono replik\u0101ciju. Kad pl\u0101no kopa tiek replik\u0113ta galam\u0113r\u0137\u012b, t\u0101 k\u013c\u016bst par piln\u012bgu apjoma, konsekvent\u0101s grupas vai VMFS kr\u0101tuves kopiju. P\u0113c replik\u0101cijas pl\u0101na kopa ir piln\u012bgi neatkar\u012bgs apjoms ar saviem iestat\u012bjumiem. <\/p>\n<p><img decoding=\"async\" alt=\"Microsoft SQL Server 2019 un Dell EMC Unity XT fle\u0161a mas\u012bvi\" src=\"\/wp-content\/uploads\/2019\/12\/58d0ecdba09abdd75de974e87d84188c.jpg\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<i>Pl\u0101n\u0101s kopijas replik\u0101cijas process starp avota un m\u0113r\u0137a sist\u0113m\u0101m.<\/i><\/p>\n<p>Tempdb datub\u0101zes replik\u0101cija nav nepiecie\u0161ama, jo fails tiek p\u0101rb\u016bv\u0113ts SQL Server restart\u0113\u0161anas laik\u0101, t\u0101d\u0113\u013c metadati neatbilst citu SQL Server instan\u010du metodei. R\u016bp\u012bga apjomu izv\u0113le replik\u0101cijai un \u0161o apjomu saturam nov\u0113r\u0161 nevajadz\u012bgu replik\u0101cijas trafiku.<\/p>\n<h2>Microsoft SQL Server integr\u0113t\u0101 datu kop\u0113\u0161anas p\u0101rvald\u012bba<\/h2>\n<p>\nLiel\u0101k\u0101 da\u013ca m\u016bsdienu uzglab\u0101\u0161anas izstr\u0101d\u0101jumu (ieskaitot visus Dell EMC produktus) var izveidot \"ar oper\u0113t\u0101jsist\u0113mu saska\u0146otas\" failu kopijas, veicot:<\/p>\n<ul>\n<li>Oper\u0113t\u0101jsist\u0113mas veikto rakst\u012b\u0161anas sec\u012bbu visos l\u012bme\u0146os \u2014 no saimniekdatora l\u012bdz kr\u0101tuvei.<\/li>\n<li>Apjomu grup\u0113\u0161anu, lai vair\u0101k\u0101m failiem uz da\u017e\u0101diem apjomiem saglab\u0101tu rakst\u012b\u0161anas sec\u012bbu.<\/li>\n<\/ul>\n<p>\nAr pla\u0161u m\u0113rogu uzglab\u0101\u0161anas ier\u012b\u010du izplat\u012bbu Microsoft izstr\u0101d\u0101ja API glab\u0101t\u0101ju pieg\u0101d\u0101t\u0101jiem. \u0160is API \u013cauj glab\u0101t\u0101ju pieg\u0101d\u0101t\u0101jiem koordin\u0113t savas darb\u012bbas ar SQL Server datu b\u0101zu programmat\u016bru, lai izveidotu \"ar lietojumprogrammu saska\u0146otas kopijas\" izmantojot apjoma mirk\u013catt\u0113lu (VSS) pakalpojumu. \u0160\u012bs kopijas imitu p\u0101rs\u016bt\u012b\u0161anu starp SQL Server un oper\u0113t\u0101jsist\u0113mu pl\u0101nveida un SQL Server izsl\u0113g\u0161anas laik\u0101. Visas rakst\u012b\u0161anas buferes tiek izt\u012br\u012btas, un transakcijas tiek aptur\u0113tas l\u012bdz br\u012bdim, kad visi diski tiek atjaunin\u0101ti un saska\u0146oti konkr\u0113tam laika br\u012bdim, kas ir fiks\u0113ts SQL \u017eurn\u0101l\u0101.<\/p>\n<p>Dell EMC AppSync programmat\u016bra, integr\u0113ta ar Unity XT mirk\u013catt\u0113liem, vienk\u0101r\u0161o un automatiz\u0113 ar lietojumprogrammu saska\u0146otu darba datu kopiju veido\u0161anas, izmanto\u0161anas un p\u0101rvald\u012b\u0161anas procesu. \u0160\u012b programmat\u016bra ir paredz\u0113ta izmanto\u0161anai kopiju p\u0101rvald\u012bbas scen\u0101rijos datu b\u0101zu atjauno\u0161anai un to atk\u0101rtotai izmanto\u0161anai.\u00a0<\/p>\n<p>AppSync programmat\u016bra autom\u0101tiski atkl\u0101j lietojumprogrammu datu b\u0101zes, p\u0113ta datu b\u0101zes strukt\u016bru un att\u0113lo failu strukt\u016bru caur aparat\u016bras vai virtualiz\u0101cijas sl\u0101\u0146iem uz pamat\u0101 eso\u0161o Unity XT uzglab\u0101\u0161anu. T\u0101 organiz\u0113 visas nepiecie\u0161am\u0101s darb\u012bbas, s\u0101kot no kopijas izveides un p\u0101rbaudes l\u012bdz mirk\u013catt\u0113lu mont\u0113\u0161anai m\u0113r\u0137a host\u0101 un datu b\u0101zes palai\u0161anai vai atjauno\u0161anai. AppSync atbalsta un vienk\u0101r\u0161o SQL Server darba procesos, kas iek\u013cauj darba datu b\u0101zes atjaunin\u0101\u0161anu un atjauno\u0161anu.<\/p>\n<h2>Datu apjoma samazin\u0101\u0161ana un papla\u0161in\u0101ta dublik\u0101tu nov\u0113r\u0161ana<\/h2>\n<p>\nDell EMC Unity uzglab\u0101\u0161anas sist\u0113mu \u0123imene pied\u0101v\u0101 daudzfunkcion\u0101lus un viegli lietojamus datu apjoma samazin\u0101\u0161anas pakalpojumus. Ietaup\u012bjumi tiek sasniegti ne tikai uz konfigur\u0113taj\u0101m prim\u0101raj\u0101m uzglab\u0101\u0161anas resursiem, bet ar\u012b uz \u0161o resursu mirk\u013catt\u0113liem un pl\u0101najiem kloniem. Mirk\u013catt\u0113li un pl\u0101n\u0101s kloni manto s\u0101kotn\u0113j\u0101 uzglab\u0101\u0161anas resursa apjoma samazin\u0101\u0161anas iestat\u012bjumus, kas palielina ietaup\u012bjumu jaudu.<\/p>\n<p>Datu apjoma samazin\u0101\u0161anas funkcija ietver datu deduplication, saspie\u0161anu un nulles bloku atkl\u0101\u0161anu, kas potenci\u0101li palielina noder\u012bg\u0101 kr\u0101tuves apjoma pieejam\u012bbu lietot\u0101ju objektiem un iek\u0161\u0113jai lieto\u0161anai. Unity XT datu apjoma samazin\u0101\u0161anas funkcija aizst\u0101j saspie\u0161anas funkciju Unity OE 4.3 un v\u0113l\u0101k\u0101s versij\u0101s. Saspie\u0161ana ir datu samazin\u0101\u0161anas algoritms, kas var samazin\u0101t fizisko jaudas izplat\u012bbu, kas nepiecie\u0161ama datu kopas saglab\u0101\u0161anai.<\/p>\n<p>Unity XT sist\u0113mas ar\u012b nodro\u0161ina papla\u0161in\u0101tu deduplication funkciju, ko var aktiviz\u0113t, ja datu apjoma samazin\u0101\u0161ana ir iesl\u0113gta. Papla\u0161in\u0101ta deduplication samazina nepiecie\u0161amo jaudu lietot\u0101ju datiem, saglab\u0101jot tikai nelielu skaitu kopiju (bie\u017ei vien tikai vienu kopiju) Unity datu blokiem. Deduplication joma ir viens LUN. \u0145emiet to v\u0113r\u0101, izv\u0113loties glab\u0101\u0161anas sh\u0113mu. Maz\u0101ks LUN skaits nodro\u0161ina lab\u0101ku deduplication, ta\u010du liel\u0101ks LUN skaits nodro\u0161ina paaugstin\u0101tu veiktsp\u0113ju.\u00a0<\/p>\n<p>Jaudas ietaup\u012bjums, pateicoties papla\u0161in\u0101tai deduplication, var nodro\u0161in\u0101t visliel\u0101ko atdevi liel\u0101kaj\u0101 da\u013c\u0101 vide, bet ar\u012b prasa resursus Unity sist\u0113mas procesoriem. OE 5.0, ja t\u0101 ir iesl\u0113gta, papla\u0161in\u0101t\u0101 deduplication deduplic\u0113 jebkuru bloku (saspie\u017eamu vai nesaspie\u017eamu). Papildu inform\u0101ciju skatiet <noindex><a rel=\"nofollow\" href=\"https:\/\/www.emc.com\/collateral\/white-papers\/h15571-dell-emc-unity-compression.pdf\">Dell EMC dokument\u0101cij\u0101<\/a><\/noindex>.<\/p>\n<p>N\u0101kamaj\u0101 tabul\u0101 ir nor\u0101d\u012btas atbalst\u012bt\u0101s konfigur\u0101cijas datu samazin\u0101\u0161anai un papla\u0161in\u0101tai deduplication:<\/p>\n<h2>Datu samazin\u0101\u0161ana Unity (vis\u0101s mode\u013cos) un papla\u0161in\u0101ta deduplication atbalsts<\/h2>\n<p><\/p>\n<p>Unity OE versija\u00a0<\/p>\n<p>Tehnolo\u0123ija\u00a0<\/p>\n<p>Atbalst\u012bt\u0101 baseina veids\u00a0<\/p>\n<p>Atbalst\u012btie mode\u013ci<\/p>\n<p>4.3 \/ 4.4\u00a0<\/p>\n<p>Datu apjoma samazin\u0101\u0161ana\u00a0<\/p>\n<p>Flash atmi\u0146as baseins \u2013 tradicion\u0101ls vai dinamisks\u00a0<\/p>\n<p>300, 400, 500, 600, 300F, 400F, 500F, 600F, 350F, 450F, 550F, 650F\u00a0<\/p>\n<p>4.5\u00a0<br \/>\n\u00a0<\/p>\n<p>Datu apjoma samazin\u0101\u0161ana\u00a0<\/p>\n<p>300, 400, 500, 600, 300F, 400F, 500F, 600F, 350F, 450F, 550F, 650F\u00a0<\/p>\n<p>Datu apjoma samazin\u0101\u0161ana un papla\u0161in\u0101ta deduplication*<\/p>\n<p>450F, 550F, 650F\u00a0<\/p>\n<p>5\u00a0<br \/>\n\u00a0<\/p>\n<p>Datu apjoma samazin\u0101\u0161ana\u00a0<\/p>\n<p>300, 400, 500, 600, 300F, 400F, 500F, 600F, 350F, 450F, 550F, 650F, 380, 480, 680, 880, 380F, 480F, 680F, 880F\u00a0<\/p>\n<p>Datu apjoma samazin\u0101\u0161ana un papla\u0161in\u0101ta dublik\u0101tu nov\u0113r\u0161ana<\/p>\n<p>450F, 550F, 650F, 380, 480, 680, 880, 380F, 480F, 680F, 880F<\/p>\n<p><i> * Datu apjoma samazin\u0101\u0161ana p\u0113c noklus\u0113juma ir izsl\u0113gta, un to nepiecie\u0161ams aktiviz\u0113t, pirms papla\u0161in\u0101t\u0101 deduplication k\u013c\u016bst pieejama k\u0101 opcija. P\u0113c datu apjoma samazin\u0101\u0161anas aktiviz\u0113\u0161anas papla\u0161in\u0101t\u0101 deduplication k\u013c\u016bst pieejama, ta\u010du p\u0113c noklus\u0113juma t\u0101 ir izsl\u0113gta.<\/i><\/p>\n<h2>Datu apjoma samazin\u0101\u0161ana Unity un datu saspie\u0161ana SQL Server<\/h2>\n<p>\nSQL Server 2008 Enterprise Edition izlaidums bija pirmais izlaidums ar ieb\u016bv\u0113t\u0101m datu saspie\u0161anas iesp\u0113j\u0101m. Saspie\u017eot uz rindu un lapu l\u012bme\u0146iem, SQL Server 2008 izmanto iek\u0161\u0113j\u0101s datu b\u0101zes tabulas form\u0101ta zin\u0101\u0161anas, lai samazin\u0101tu datu b\u0101zes objektu aiz\u0146emto vietu. Vietas samazin\u0101\u0161ana \u013cauj saglab\u0101t vair\u0101k rindu lap\u0101 un vair\u0101k lapu bufera grup\u0101. T\u0101 k\u0101 dati, kas netiek saglab\u0101ti 8k datu lapas form\u0101t\u0101, piem\u0113ram, \u0101r\u0113jie dati, piem\u0113ram, NVARCHAR (MAX), neizmanto saspie\u0161anas metodes uz rind\u0101m vai lap\u0101m, Microsoft ieviesa Transact-SQL funkcijas COMPRESS un DECOMPRESS.\u00a0<\/p>\n<p>\u0160\u012bs funkcijas izmanto tradicion\u0101lo pieeju datu saspie\u0161anai (GZIP algoritmu), ko nepiecie\u0161ams izsaukt katr\u0101 datu sada\u013c\u0101, lai saspie\u017e un atspie\u017e.<\/p>\n<p>Unity XT saspie\u0161ana, kas nav saist\u012bta tikai ar SQL Server, izmanto programmat\u016bras algoritmu datu anal\u012bzei un saspie\u0161anai uzglab\u0101\u0161anas sist\u0113m\u0101. Kop\u0161 Unity OE 4.1 izlaiduma, Unity datu saspie\u0161ana bija pieejama blokveida uzglab\u0101\u0161anas apjomiem un VMFS datu uzglab\u0101\u0161anas jom\u0101m ar zibatmi\u0146u. S\u0101kot ar Unity OE 4.2, saspie\u0161ana ir pieejama ar\u012b failu sist\u0113m\u0101m un NFS datu uzglab\u0101\u0161anas viet\u0101m zibatmi\u0146as uzglab\u0101\u0161anas grup\u0101s.<\/p>\n<p>Datub\u0101zes saspie\u0161anas metodes izv\u0113le SQL Server ir atkar\u012bga no vair\u0101kiem faktoriem. \u0160ie faktori ietver datu b\u0101zes satura veidu, pieejamos CPU resursus \u2014 gan uzglab\u0101\u0161an\u0101, gan datu b\u0101zu serveros, k\u0101 ar\u012b I\/O resursus, kas nepiecie\u0161ami SLA uztur\u0113\u0161anai. Kopum\u0101 var sagaid\u012bt papildu vietas ekonomiju datiem, kas tiek saspie\u0161ti, izmantojot SQL Server l\u012bdzek\u013cus, tom\u0113r dati, kas ir saspie\u0161ti ar TSQL saspie\u0161anas funkciju, izmantojot GZIP algoritmu, visticam\u0101k, neieg\u016bs iev\u0113rojamu papildu apjoma samazin\u0101jumu no Unity XT saspie\u0161anas funkcij\u0101m, jo liel\u0101k\u0101 da\u013ca ieguvumu tiek sasniegti, izmantojot pirmo piem\u0113roto visp\u0101r\u012bgo algoritmu.<\/p>\n<p>Unity saspie\u0161ana nodro\u0161ina vietas ekonomiju, ja datu objekts tiek saspie\u017eams vismaz par 25%. Pirms saspie\u0161anas aktiviz\u0113\u0161anas uzglab\u0101\u0161anas objektam nosakiet, vai taj\u0101 ir dati, kas var tikt saspie\u0161ti. Neaktiviz\u0113jiet saspie\u0161anu uzglab\u0101\u0161anas objektam, ja tas nesniegs ietaup\u012bjumu apjom\u0101.\u00a0<\/p>\n<p>Pie\u0146emot l\u0113mumu par to, vai izmantot datu apjoma samazin\u0101\u0161anu Unity, SQL Server datub\u0101zes l\u012bme\u0146a saspie\u0161anu vai abus, \u0146emiet v\u0113r\u0101 sekojo\u0161o:<\/p>\n<ul>\n<li>Dati, kas tiek ierakst\u012bti Unity sist\u0113m\u0101, tiek apstiprin\u0101ti, kad hosta saglab\u0101ti sist\u0113mas ke\u0161atmi\u0146\u0101. Tom\u0113r saspie\u0161anas process netiks uzs\u0101kti, l\u012bdz ke\u0161atmi\u0146a netiks not\u012br\u012bta.<\/li>\n<\/ul>\n<p><\/p>\n<ul>\n<li>Ietaup\u012bjums, ko nodro\u0161ina saspie\u0161ana, tiek sasniegts ne tikai Unity XT glab\u0101\u0161anas resursos, bet ar\u012b momentuz\u0146\u0113mumos un pl\u0101no klonu resursos.<\/li>\n<li>Saspie\u0161anas proces\u0101 vair\u0101ki bloki tiek apkopoti, izmantojot izlases algoritmu, lai noteiktu, vai dati ir saspie\u017eami. Ja izlases algoritms nosaka, ka var pan\u0101kt tikai minim\u0101lu ietaup\u012bjumu, saspie\u0161ana tiek izlaista un dati tiek ierakst\u012bti izmanto\u0161anas basein\u0101.<\/li>\n<li>Kad dati tiek saspie\u017eami pirms ierakst\u012b\u0161anas glab\u0101\u0161an\u0101, oper\u0101ciju apjoms ar tiem iev\u0113rojami samazin\u0101s. T\u0101d\u0113\u013c saspie\u0161ana pal\u012bdz samazin\u0101t uz NVRAM nodilumu, samazinot fizisko datu apjomu, kas tiek ierakst\u012bts uz ier\u012bc\u0113m.<\/li>\n<\/ul>\n<p>\nPapildu inform\u0101ciju par rindu un lapu saspie\u0161anu SQL Server datub\u0101z\u0113s tabul\u0101m un indeksiem skat\u012bt <noindex><a rel=\"nofollow\" href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/data-compression\/data-compression\">Microsoft dokumentos<\/a><\/noindex>.<\/p>\n<p>Neaizmirstiet, ka jebkurai saspie\u0161anai ir nepiecie\u0161ami procesora resursi. Augstu caurlaidsp\u0113jas pras\u012bbu gad\u012bjum\u0101 saspie\u0161ana var iev\u0113rojami ietekm\u0113t veiktsp\u0113ju. Augstas rakst\u012b\u0161anas slodzes OLAP var samazin\u0101t saspie\u0161anas priek\u0161roc\u012bbas SQL Server datub\u0101z\u0113m.<\/p>\n<p>Dell EMC speci\u0101listi p\u0113t\u012bja potenci\u0101los ietaup\u012bjumus, izmantojot re\u0101los datu samazin\u0101\u0161anas koeficientus Unity sist\u0113m\u0101. Grupa apkopoja datus par VMware virtu\u0101laj\u0101m ma\u0161\u012bn\u0101m, failu koplieto\u0161anas risin\u0101jumiem, SQL Server datub\u0101z\u0113m, Microsoft Hyper-V virtu\u0101laj\u0101m ma\u0161\u012bn\u0101m utt.<\/p>\n<p>P\u0113t\u012bjuma rezult\u0101ti r\u0101d\u012bja, ka SQL Server \u017eurn\u0101lu apjoma samazin\u0101jums ir gandr\u012bz 10 reizes maz\u0101ks nek\u0101 datu failiem:<\/p>\n<ul>\n<li>Datu b\u0101zes apjoms = 1,49: 1 (32,96%)<\/li>\n<li>\u017durn\u0101lu apjoms = 12,9: 1 (92,25%)<\/li>\n<\/ul>\n<p>\nSQL Server datu b\u0101ze tika apr\u012bkota ar diviem apjomiem. Datu b\u0101zes faili tiek glab\u0101ti vien\u0101 apjom\u0101, bet transakciju \u017eurn\u0101li \u2014 otr\u0101. Datu samazin\u0101\u0161anas tehnolo\u0123ijas izmanto\u0161ana datu b\u0101zes apjomos var nodro\u0161in\u0101t uzglab\u0101\u0161anas ietaup\u012bjumus; tom\u0113r pie\u0146emot l\u0113mumu par deduplik\u0101cijas iek\u013cau\u0161anu datu b\u0101zes apjomos, j\u0101\u0146em v\u0113r\u0101 t\u0101s ietekme uz veiktsp\u0113ju. Lai gan faktisk\u0101 datu b\u0101zes apjoma samazin\u0101\u0161ana var at\u0161\u0137irties atkar\u012bb\u0101 no glab\u0101tajiem datiem, p\u0113t\u012bjuma rezult\u0101ti par\u0101d\u012bja, ka SQL Server transakciju \u017eurn\u0101li var <noindex><a rel=\"nofollow\" href=\"https:\/\/www.dellemc.com\/resources\/en-us\/asset\/white-papers\/products\/storage\/h17574-dell-emc-unity-data-reduction-analysis-wp.pdf\">b\u016bt iev\u0113rojami samazin\u0101ti<\/a><\/noindex>.<\/p>\n<h2>Lab\u0101k\u0101s datu apjoma samazin\u0101\u0161anas prakses<\/h2>\n<p>\nPirms datu apjoma samazin\u0101\u0161anas iek\u013cau\u0161anas glab\u0101\u0161anas objekt\u0101, izskatiet \u0161\u0101das rekomend\u0101cijas:<\/p>\n<ul>\n<li>Izmantojiet glab\u0101\u0161anas sist\u0113mas uzraudz\u012bbu, lai p\u0101rliecin\u0101tos, ka tai ir pieejami resursi datu apjoma samazin\u0101\u0161anas atbalstam.<\/li>\n<li>Iek\u013caujiet datu apjoma samazin\u0101\u0161anu vair\u0101kiem glab\u0101\u0161anas objektiem vienlaic\u012bgi. Pirms t\u0101s iek\u013cau\u0161anas papildu glab\u0101\u0161anas objektos uzraugiet sist\u0113mu, lai p\u0101rliecin\u0101tos, ka t\u0101 atrodas rekomend\u0113tajos darba re\u017e\u012bmos.<\/li>\n<li>Unity XT x80F mode\u013cos datu apjoma samazin\u0101\u0161ana nodro\u0161in\u0101s ietaup\u012bjumu, ja glab\u0101\u0161an\u0101 eso\u0161ie dati tiek saspiesti vismaz par 1%.<\/li>\n<\/ul>\n<p>\nDatu apjoma samazin\u0101\u0161ana iepriek\u0161\u0113jos Unity x80F mode\u013cos, kas darbojas ar OE 5.0, nodro\u0161in\u0101ja ietaup\u012bjumu, ja dati tika saspiesti vismaz par 25%.<\/p>\n<ul>\n<li>Pirms datu apjoma samazin\u0101\u0161anas iek\u013cau\u0161anas glab\u0101\u0161anas objekt\u0101 noteiciet, vai objekts satur saspiestamus datus. Noteikti datu tipi, piem\u0113ram, video, audio, att\u0113li un bin\u0101rie dati, parasti sniedz maz ieg\u016bto no saspiest\u012bbas. Neiek\u013caujiet datu apjoma samazin\u0101\u0161anu glab\u0101\u0161anas objekt\u0101, ja vietas ietaup\u012bjums neb\u016bs.<\/li>\n<li>Apsveriet izv\u0113les datu apjoma samazin\u0101\u0161anu datu failu apjomam, kuri parasti labi saspiest.<\/li>\n<\/ul>\n<p><\/p>\n<h2>VMware virtualiz\u0101cija<\/h2>\n<p>\nVMware vSphere ir efekt\u012bva un dro\u0161a platforma virtualiz\u0101cijai un m\u0101ko\u0146u videi. Galvenie vSphere komponenti ir VMware vCenter Server un VMware ESXi hipervizors.<\/p>\n<p>vCenter Server \u2014 vienota vad\u012bbas platforma vSphere vid\u0113m. T\u0101 izce\u013cas ar vienk\u0101r\u0161u izvieto\u0161anu un proakt\u012bvu resursu optimiz\u0101ciju. ESXi \u2014 atv\u0113rt\u0101 koda hipervizors, kas tiek instal\u0113ts tie\u0161i fiziskajos serveros. ESXi nodro\u0161ina tie\u0161u piek\u013cuvi pamatresursiem un nelielais izm\u0113rs 150 MB samazina pras\u012bbas attiec\u012bb\u0101 uz atmi\u0146u. Tas nodro\u0161ina uzticamu veiktsp\u0113ju da\u017e\u0101d\u0101m lietojumprogrammu slodz\u0113m un atbalsta jaud\u012bgas virtu\u0101lo ma\u0161\u012bnu konfigur\u0101cijas \u2014 l\u012bdz 128 virtu\u0101lajiem CPU, 6 TB RAM un 120 ier\u012bc\u0113m.<\/p>\n<p>Lai SQL Server efekt\u012bvi darbotos m\u016bsdienu aparat\u016br\u0101, SQL Server oper\u0113t\u0101jsist\u0113mai (SQLOS) j\u0101sp\u0113j \u201esaprast\u201d aparat\u016bras strukt\u016bru. Ar daudzkodolu un daudzpunktu nehomog\u0113n\u0101s piek\u013cuves atmi\u0146ai (NUMA) sist\u0113mu par\u0101d\u012b\u0161anos ir k\u013cuvusi \u012bpa\u0161i svar\u012bga izpratne par attiec\u012bb\u0101m starp kodoliem, lo\u0123iskajiem un fiziskajiem procesoriem.<\/p>\n<h2>Procesori\u00a0<\/h2>\n<p>\nVirtu\u0101lais processors (vCPU) ir virtu\u0101lais centr\u0101lais procesors, kas pie\u0161\u0137irts virtu\u0101lajai ma\u0161\u012bnai. Kop\u0113jais pie\u0161\u0137irto virtu\u0101lo CPU skaits tiek apr\u0113\u0137in\u0101ts k\u0101:<\/p>\n<pre><code class=\"plaintext\">Kop\u0113jais vCPU = (virtu\u0101lo soketu skaits) * (virtu\u0101lo kodolu skaits uz soketu)<\/code><\/pre>\n<p>\nJa stabila veiktsp\u0113ja ir svar\u012bga, VMware ieteicams, lai kop\u0113jais pie\u0161\u0137irto virtu\u0101lo CPU skaits vis\u0101m virtu\u0101laj\u0101m ma\u0161\u012bn\u0101m nep\u0101rsniegtu fizisko kodolu kop\u0113jo skaitu, kas pieejams ESXi viesdator\u0101, ta\u010du var palielin\u0101t pie\u0161\u0137irto virtu\u0101lo CPU skaitu, ja uzraudz\u012bba r\u0101da, ka ir pieejami neizmantoti CPU resursi.<\/p>\n<p>Sist\u0113m\u0101s ar aktiviz\u0113tu Intel Hyper-Threading tehnolo\u0123iju lo\u0123isko kodolu (vCPU) skaits ir divreiz liel\u0101ks par fizisko kodolu skaitu. \u0160aj\u0101 gad\u012bjum\u0101 nevajadz\u0113tu pie\u0161\u0137irt kop\u0113jo virtu\u0101lo CPU skaitu.<\/p>\n<p>Uz SQL Server zem\u0101ka l\u012bme\u0146a slodz\u0113m mai\u0146as latence maz\u0101k ietekm\u0113. T\u0101d\u0113j\u0101di \u0161\u012bs slodzes var tikt izpild\u012btas uz viesdatoriem ar augst\u0101ku virtu\u0101lo CPU un fizisko attiec\u012bbu. Sapr\u0101t\u012bgi CPU noslodzes l\u012bme\u0146i var palielin\u0101t sist\u0113mas kop\u0113jo caurlaidsp\u0113ju, maksim\u0101li ieekonom\u0113jot licences un saglab\u0101jot adekv\u0101tu veiktsp\u0113ju.<\/p>\n<p>Intel Hyper-Threading parasti paaugstina hosta kop\u0113jo caurlaid\u012bbu par 10\u201330%, kas liecina par virtu\u0101lo CPU un fizisko procesoru attiec\u012bbu no 1,1 l\u012bdz 1,3. VMware iesaka iesp\u0113jot Hyper-Threading BIOS UEFI, ja tas ir iesp\u0113jams, lai ESXi var\u0113tu izmantot \u0161\u012bs tehnolo\u0123ijas priek\u0161roc\u012bbas. VMware ar\u012b iesaka veikt r\u016bp\u012bgu test\u0113\u0161anu un uzraudz\u012bbu, izmantojot Hyper-Threading SQL Server darba slodz\u0113m.<\/p>\n<h2>Atmi\u0146a<\/h2>\n<p>\nGandr\u012bz visi m\u016bsdienu serveri izmanto atmi\u0146as piek\u013cuves arhitekt\u016bru ar nehomog\u0113nu piek\u013cuvi atmi\u0146ai (NUMA) sazi\u0146ai starp galveno atmi\u0146u un procesoriem. NUMA ir aparat\u016bras arhitekt\u016bra kop\u012bgajai atmi\u0146ai, kas \u012bsteno fizisk\u0101s atmi\u0146as bloku sadal\u012b\u0161anu starp fiziskajiem procesoriem. NUMA mezgls ir viens vai vair\u0101ki CPU soketi kop\u0101 ar atdedz\u0113tu atmi\u0146as bloku.\u00a0<\/p>\n<p>P\u0113d\u0113j\u0101 desmitgad\u0113 NUMA ir bijusi pla\u0161i apspriesta t\u0113ma. Attiec\u012bg\u0101 NUMA sare\u017e\u0123\u012bt\u012bba ir saist\u012bta ar da\u017e\u0101du pieg\u0101d\u0101t\u0101ju \u012bstenojumiem. Virtualiz\u0113t\u0101s vid\u0113s NUMA sare\u017e\u0123\u012bt\u012bba tiek noteikta ar\u012b ar konfigur\u0101cijas parametru un l\u012bme\u0146u skaitu \u2014 no aparat\u016bras caur hipervizoru l\u012bdz viesu oper\u0113t\u0101jsist\u0113mai un beidzot ar SQL Server programmat\u016bru. Laba izpratne par NUMA aparat\u016bras arhitekt\u016bru ir oblig\u0101ts nosac\u012bjums jebkuram SQL Server datub\u0101zes administratoram, kas str\u0101d\u0101 ar virtualiz\u0113tu SQL Server instanci.<\/p>\n<p>Lai pan\u0101ktu liel\u0101ku efektivit\u0101ti serveros ar lielu kodolu skaitu, Microsoft ieviesa SoftNUMA. SoftNUMA programmat\u016bra \u013cauj dal\u012bt pieejamos CPU resursus vienas NUMA ietvaros vair\u0101kos SoftNUMA mezglos. Saska\u0146\u0101 ar VMware, SoftNUMA ir sader\u012bga ar VMware virtu\u0101lo NUMA topolo\u0123iju (vNUMA) un var papildu optimiz\u0113t datu b\u0101zes dzin\u0113ja m\u0113rogojam\u012bbu un veiktsp\u0113ju liel\u0101kajai da\u013cai darba slod\u017eu...<\/p>\n<p>Str\u0101d\u0101jot ar VMware virtualiz\u0101ciju un SQL Server, izmantojiet:<\/p>\n<ul>\n<li>Virtu\u0101lo ma\u0161\u012bnu uzraudz\u012bba, lai atkl\u0101tu atmi\u0146as resursu tr\u016bkumu SQL Server datub\u0101zes dzin\u0113jam. \u0160\u012b probl\u0113ma izraisa iev\u0113rojamu ieejas-izejas oper\u0101ciju skaita pieaugumu un veiktsp\u0113jas samazin\u0101\u0161anos.<\/li>\n<\/ul>\n<p><\/p>\n<ul>\n<li>Lai uzlabotu veiktsp\u0113ju, nov\u0113r\u0161iet atmi\u0146as konfliktus starp virtu\u0101laj\u0101m ma\u0161\u012bn\u0101m, izvairoties no p\u0101rm\u0113r\u012bgas atmi\u0146as noslodzes uz ESXi hosta.<\/li>\n<li>Apsveriet iesp\u0113ju p\u0101rbaud\u012bt NUMA fizisk\u0101s atmi\u0146as pie\u0161\u0137ir\u0161anu, lai noteiktu maksim\u0101lo atmi\u0146as apjomu, kas var tikt pie\u0161\u0137irts virtu\u0101lajai ma\u0161\u012bnai fiziskaj\u0101s NUMA robe\u017e\u0101s.<\/li>\n<li>Ja adekv\u0101tas veiktsp\u0113jas sasnieg\u0161ana ir galvenais m\u0113r\u0137is, apsveriet iesp\u0113ju rezerv\u0113t atmi\u0146u, kas ir vien\u0101da ar pie\u0161\u0137irto atmi\u0146u. \u0160\u012b iestat\u012bjumu konfig\u016br\u0113\u0161ana garant\u0113, ka virtu\u0101l\u0101 ma\u0161\u012bna sa\u0146em tikai fizisko atmi\u0146u.<\/li>\n<\/ul>\n<p><\/p>\n<h2>Virtualiz\u0113ta kr\u0101tuv\u0113<\/h2>\n<p>\nKr\u0101tuves konfigur\u0113\u0161ana virtualiz\u0113t\u0101 vid\u0113 prasa zin\u0101\u0161anas par uzglab\u0101\u0161anas infrastrukt\u016bru. L\u012bdz\u012bgi k\u0101 ar NUMA, ir svar\u012bgi saprast, k\u0101 darbojas da\u017e\u0101di ievades-izvades l\u012bme\u0146i - \u0161aj\u0101 gad\u012bjum\u0101 no lietojumprogrammas VM l\u012bdz fiziskajai datu las\u012b\u0161anai un ierakst\u012b\u0161anai uz past\u0101v\u012bgiem glab\u0101\u0161anas nes\u0113jiem.<\/p>\n<p>vSphere nodro\u0161ina virkni iestat\u012bjumu kr\u0101tuves konfigur\u0113\u0161anai, kas ir noder\u012bgi SQL Server ievie\u0161an\u0101 ar Unity XT mas\u012bvu. FS VMFS ir vispla\u0161\u0101k izmantot\u0101 datu kr\u0101tuves metode blokveida glab\u0101\u0161anas sist\u0113m\u0101s, piem\u0113ram, Unity XT. Unity XT mas\u012bvs ir apak\u0161\u0113jais l\u012bmenis, kas sast\u0101v no fiziskajiem diskiem, kurus vSphere att\u0113lo k\u0101 lo\u0123iskos diskus (apjomi). Unity XT apjomi tiek format\u0113ti k\u0101 VMFS apjomi ESXi hiperre\u017eisor\u0101. VMware administratoriem tiek izveidoti viens vai vair\u0101ki virtu\u0101lie diski (VMDK), kas tiek att\u0113loti viesu oper\u0113t\u0101jsist\u0113m\u0101. RDM \u013cauj virtu\u0101lajai ma\u0161\u012bnai tie\u0161i piek\u013c\u016bt blokveida glab\u0101\u0161anai (pa FC vai iSCSI) Unity XT bez VMFS format\u0113\u0161anas. VMFS un RDM apjomi var nodro\u0161in\u0101t l\u012bdz\u012bgu dar\u012bjumu caurlaid\u012bbu.\u00a0<\/p>\n<p>Attiec\u012bb\u0101 uz NFS glab\u0101\u0161anu ESXi Dell EMC iesaka izmantot VMware NFS, nevis visp\u0101r\u0113jas izmanto\u0161anas NFS failu sist\u0113mas. Virtu\u0101l\u0101 ma\u0161\u012bna, kas darbojas SQL Server un izmanto VMDK NFS datu kr\u0101tuv\u0113, nezina par apak\u0161\u0113jo NFS sl\u0101ni. Viesu oper\u0113t\u0101jsist\u0113ma uztver virtu\u0101lo ma\u0161\u012bnu k\u0101 fizisku serveri, kas darbojas ar Windows Server un SQL Server. Kop\u012bgie diski klastera pieejam\u012bbas konfigur\u0101cij\u0101s NFS datu kr\u0101tuv\u0113s nav atbalst\u012bti.<\/p>\n<p>VMware vSphere (VVols) virtu\u0101lie apjomi nodro\u0161ina smalk\u0101ku p\u0101rvald\u012bbu virtu\u0101l\u0101s ma\u0161\u012bnas l\u012bmen\u012b neatkar\u012bgi no pamat\u0101 eso\u0161\u0101s fizisk\u0101s atmi\u0146as strukt\u016bras (piem\u0113ram, apjomiem vai failu sist\u0113m\u0101m). Mas\u012bvu replik\u0101cija ar VVols ir atbalst\u012bta kop\u0161 VVol 2.0 (vSphere 6.5). VVol disks var tikt izmantots k\u0101 RDM disks, lai pie\u0161\u0137irtu diskus resursiem SQL replik\u0101cijas klaster\u012b, s\u0101kot ar vSphere 6.7, ar tie\u0161o rezerv\u0113\u0161anu, izmantojot SCSI.<\/p>\n<h2>Virtu\u0101liz\u0113tas t\u012bklu<\/h2>\n<p>\nT\u012bkls virtu\u0101laj\u0101 vid\u0113 seko t\u0101m pa\u0161\u0101m lo\u0123iskaj\u0101m koncepcij\u0101m k\u0101 fiziskaj\u0101 pasaul\u0113, ta\u010du izmanto programmat\u016bru, nevis fiziskos kabe\u013cus un sl\u0113d\u017eus. T\u012bkla aiztures ietekme uz SQL Server darba slodz\u0113m var b\u016bt \u013coti at\u0161\u0137ir\u012bga. Eso\u0161\u0101s darba slodzes vai labi realiz\u0113tas testa sist\u0113mas veiktsp\u0113jas r\u0101d\u012bt\u0101ju uzraudz\u012bba reprezentat\u012bv\u0101 period\u0101 pal\u012bdz veidot virtu\u0101lo t\u012bklu.<\/p>\n<p>Izmantojot VMware virtualiz\u0101ciju ar SQL Server, j\u0101patur pr\u0101t\u0101 sekojo\u0161ais:<\/p>\n<ul>\n<li>Gan standarta, gan sadal\u012btie virtu\u0101lie sl\u0113d\u017ei nodro\u0161ina SQL Server pras\u012bb\u0101m nepiecie\u0161amo funkcionalit\u0101ti.<\/li>\n<li>Lai lo\u0123iski sadal\u012btu p\u0101rvald\u012bbas, vSphere vMotion un t\u012bkla kr\u0101tuves trafiku, izmantojiet VLAN mar\u0137\u0113\u0161anu un virtu\u0101l\u0101 sl\u0113d\u017ea porta grupas.<\/li>\n<li>VMware stingri iesaka iesp\u0113jot lielos kadrus virtu\u0101lajos sl\u0113d\u017eos, kur tiek izmantots vSphere vMotion vai iSCSI trafiks.<\/li>\n<li>Kopum\u0101 iev\u0113rojiet t\u012bkla ieteikumus viesu oper\u0113t\u0101jsist\u0113m\u0101m un aparat\u016brai.<\/li>\n<\/ul>\n<p><\/p>\n<h2>\u00a0Secin\u0101jums\u00a0<\/h2>\n<p>\nSQL Server datu b\u0101zu vid\u0113s palielin\u0101s apjoms un sare\u017e\u0123\u012bt\u012bba. SQL Server 2019 Microsoft ir uzlabojis galven\u0101s SQL Server funkcijas un pievienojis jaunas, piem\u0113ram, atbalstu lielo datu darba slodz\u0113m ar Apache Spark un HDFS. Dell EMC sadarb\u012bb\u0101 ar Microsoft turpina sniegt nepiecie\u0161amos infrastrukt\u016bras komponentus SQL Server videi \u2014 serverus, glab\u0101tuves un t\u012bklus.\u00a0<\/p>\n<p>M\u0113s nov\u0113rojam iev\u0113rojamu pieaugumu darbsp\u0113jas laik\u0101 un samazin\u0101\u0161anos kop\u0113j\u0101s \u012bpa\u0161umties\u012bbu izmaks\u0101s (TCO), ja kr\u0101tuves un datu b\u0101zu speci\u0101listi kop\u012bgi str\u0101d\u0101 pie infrastrukt\u016bras risin\u0101jumiem SQL Server platform\u0101m ar kop\u012bgu kr\u0101tuvi. Dell EMC Unity XT fle\u0161atmi\u0146as arrays ir vid\u0113j\u0101s klases risin\u0101jums, kas ir piem\u0113rots SQL Server izstr\u0101d\u0101t\u0101jiem un administratoriem, kam nepiecie\u0161ama augsta veiktsp\u0113ja un zema latent\u012bba. Unity XT All-Flash sist\u0113ma, kas paredz\u0113ta darbam ar vis\u0101m fle\u0161atmi\u0146\u0101m, atbalsta divu procesoru CPU, divu kontrolieru konfigur\u0101cijas un daudzkodolu optimiz\u0101ciju.<\/p>\n<p>Aizvien bie\u017e\u0101k organiz\u0101cijas virtualiz\u0113 savas SQL Server vid\u0113jas. Lai gan virtualiz\u0101cija pievieno arhitekt\u016brai v\u0113l vienu l\u012bmeni, t\u0101 sniedz iev\u0113rojamas priek\u0161roc\u012bbas. Ceram, ka jums noder\u0113s da\u017ei no visbie\u017e\u0101k izmantotajiem VMware funkcij\u0101m un r\u012bkiem SQL Server vid\u0113, kas iepriek\u0161 min\u0113ti. M\u0113s ar\u012b iesak\u0101m resursus, lai ieg\u016btu papildu inform\u0101ciju.<\/p>\n<h2>Noder\u012bgas saites<\/h2>\n<p>\n<b class=\"spoiler_title\">Dell EMC<\/b><\/p>\n<ul>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/community.emc.com\/docs\/DOC-67007\">Microsoft SQL Info Hub par Gataviem Risiniem<\/a><\/noindex><\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.emc.com\/collateral\/white-papers\/h16389-unity-storage-with-microsoft-sql-server-wp.pdf\">Dell EMC Unity kr\u0101tuve ar Microsoft SQL Server<\/a><\/noindex><\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.dellemc.com\/en-us\/collaterals\/unauth\/white-papers\/products\/storage\/h15093-dell-emc-unity-best-practices-guide.pdf\">Dell EMC Unity: Lab\u0101ko Praktiku Ce\u013cvedis<\/a><\/noindex><\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.emc.com\/collateral\/white-papers\/h15571-dell-emc-unity-compression.pdf\">Dell EMC Unity: Saspie\u0161anas Balt\u0101 Gr\u0101mata<\/a><\/noindex><\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.dellemc.com\/en-us\/collaterals\/unauth\/white-papers\/products\/storage\/h15089-dell-emc-unity-snapshots-and-thin-clones.pdf\">Dell EMC Unity: Snapshot un Pl\u0101nas Klones Balt\u0101 Gr\u0101mata<\/a><\/noindex><\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.dellemc.com\/resources\/en-us\/asset\/white-papers\/products\/storage\/h17574-dell-emc-unity-data-reduction-analysis-wp.pdf\">Dell EMC Unity: Datu Samazin\u0101\u0161anas Anal\u012bze<\/a><\/noindex><\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.dellemc.com\/en-us\/collaterals\/unauth\/white-papers\/products\/storage\/h16870-dell_emc_unity-data_reduction.pdf\">Dell EMC Unity: Datu Samazin\u0101\u0161anas Balt\u0101 Gr\u0101mata<\/a><\/noindex><\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.dellemc.com\/en-us\/collaterals\/unauth\/data-sheets\/products\/storage\/h17713_dell_emc_unity_xt_series_ss.pdf\">Dell EMC Unity XT Storage Series Specification Sheet<\/a><\/noindex><\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.dellemc.com\/en-us\/storage\/unity.htm\">Dell EMC XT Unity All-Flash Apvienot\u0101 Kr\u0101tuve<\/a><\/noindex> (produkta lapa)<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.youtube.com\/watch?v=oJ9T1lJf538\">Dell EMC Unity Produkta P\u0101rskats un Arhitekt\u016bra ar Kaushik Ghosh<\/a><\/noindex> (YouTube)<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.dellemc.com\/en-us\/microsites\/guarantee-programs\/all-flash-storage-efficiency.htm\">Dell EMC N\u0101kotnes Pier\u0101d\u012bjumu Lojalit\u0101tes Programma<\/a><\/noindex><\/li>\n<\/ul>\n<p>\n<b class=\"spoiler_title\">VMware<\/b><\/p>\n<ul>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/blogs.vmware.com\/apps\/microsoft\/sql\">SQL Server Emu\u0101ri<\/a><\/noindex><\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.vmware.com\/solutions\/business-critical-apps\/sql-virtualization.html\">Microsoft SQL virtualiz\u0101cija uz VMware vSphere<\/a><\/noindex><\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.vmware.com\/content\/dam\/digitalmarketing\/vmware\/en\/pdf\/solutions\/sql-server-on-vmware-best-practices-guide.pdf\">Microsoft SQL Server arhitekt\u016bra uz VMware vSphere \u2014 Lab\u0101ko Praktiku Ce\u013cvedis<\/a><\/noindex><\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.vmware.com\/content\/dam\/digitalmarketing\/vmware\/en\/pdf\/techpaper\/performance\/sql-server-vsphere65-perf.pdf\">Microsoft SQL Server veiktsp\u0113jas raksturojums uz VMware vSphere 6.5<\/a><\/noindex><\/li>\n<\/ul>\n<p>\n<b class=\"spoiler_title\">Microsoft<\/b><\/p>\n<ul>\n<li><noindex><a rel=\"nofollow\" href=\"http:\/\/info.microsoft.com\/rs\/157-GQE-382\/images\/EN-US-CNTNT-white-paper-DBMod-Microsoft-SQL-Server-2019-Technical-white-paper.pdf\"><\/a><\/noindex><noindex><a rel=\"nofollow\" href=\"https:\/\/cloudblogs.microsoft.com\/sqlserver\/\">Microsoft SQL Server 2019 tehnisk\u0101 balt\u0101 gr\u0101mata<br \/>\nSQL Server Emu\u0101rs<\/a><\/noindex><br \/>\n<noindex><a rel=\"nofollow\" href=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/default.aspx\">Microsoft Datu Platforma<\/a><\/noindex><br \/>\n<noindex><a rel=\"nofollow\" href=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/sql-server-2019\">Iepaz\u012bstin\u0101m ar SQL Server 2019<\/a><\/noindex><br \/>\n<noindex><a rel=\"nofollow\" href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/sql-server\/what-s-new-in-sql-server-ver15-prerelease?view=sqlallproducts-allversions\">SQL Server 2019 CTP pazi\u0146ojumu arh\u012bvs<\/a><\/noindex>\n<\/li>\n<\/ul>\n<p>Avots: <a content=\"nofollow\" rel=\"nofollow\" href=\"https:\/\/habr.com\/ru\/company\/dell_emc\/blog\/478366\/\">habr.com<\/a><\/p>","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"excerpt":{"rendered":"<p>\u0421\u0435\u0433\u043e\u0434\u043d\u044f \u043c\u044b \u043f\u043e\u0437\u043d\u0430\u043a\u043e\u043c\u0438\u043c \u0432\u0430\u0441 \u0441 \u043e\u0441\u043e\u0431\u0435\u043d\u043d\u043e\u0441\u0442\u044f\u043c\u0438 \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u043d\u0438\u044f SQL Server 2019 \u0441 \u0441\u0438\u0441\u0442\u0435\u043c\u043e\u0439 \u0445\u0440\u0430\u043d\u0435\u043d\u0438\u044f Unity XT, \u0430 \u0442\u0430\u043a\u0436\u0435 \u0434\u0430\u0434\u0438\u043c \u0440\u0435\u043a\u043e\u043c\u0435\u043d\u0434\u0430\u0446\u0438\u0438 \u043f\u043e \u0432\u0438\u0440\u0442\u0443\u0430\u043b\u0438\u0437\u0430\u0446\u0438\u0438 SQL Server \u0441 \u043f\u043e\u043c\u043e\u0449\u044c\u044e \u0442\u0435\u0445\u043d\u043e\u043b\u043e\u0433\u0438\u0438 VMware, \u043f\u043e \u043d\u0430\u0441\u0442\u0440\u043e\u0439\u043a\u0435 \u0438 \u0443\u043f\u0440\u0430\u0432\u043b\u0435\u043d\u0438\u044e \u0431\u0430\u0437\u043e\u0432\u044b\u043c\u0438 \u043a\u043e\u043c\u043f\u043e\u043d\u0435\u043d\u0442\u0430\u043c\u0438 \u0438\u043d\u0444\u0440\u0430\u0441\u0442\u0440\u0443\u043a\u0442\u0443\u0440\u044b Dell EMC. \u0412 2017 \u0433\u043e\u0434\u0443 Dell EMC \u0438 VMware \u043e\u043f\u0443\u0431\u043b\u0438\u043a\u043e\u0432\u0430\u043b\u0438 \u0440\u0435\u0437\u0443\u043b\u044c\u0442\u0430\u0442\u044b \u043e\u043f\u0440\u043e\u0441\u0430 \u043e \u0442\u0435\u043d\u0434\u0435\u043d\u0446\u0438\u044f\u0445 \u0438 \u044d\u0432\u043e\u043b\u044e\u0446\u0438\u0438 SQL Server \u2014 \u00ab\u0422\u0440\u0430\u043d\u0441\u0444\u043e\u0440\u043c\u0430\u0446\u0438\u044f SQL [&hellip;]<\/p>\n","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[688],"tags":[],"class_list":["post-53529","post","type-post","status-publish","format-standard","hentry","category-administrirovanie"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 5.0.4 - aioseo.com -->\n\t<meta name=\"description\" content=\"\u0421\u0435\u0433\u043e\u0434\u043d\u044f \u043c\u044b \u043f\u043e\u0437\u043d\u0430\u043a\u043e\u043c\u0438\u043c \u0432\u0430\u0441 \u0441 \u043e\u0441\u043e\u0431\u0435\u043d\u043d\u043e\u0441\u0442\u044f\u043c\u0438 \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u043d\u0438\u044f SQL Server 2019 \u0441 \u0441\u0438\u0441\u0442\u0435\u043c\u043e\u0439 \u0445\u0440\u0430\u043d\u0435\u043d\u0438\u044f Unity XT, \u0430 \u0442\u0430\u043a\u0436\u0435 \u0434\u0430\u0434\u0438\u043c \u0440\u0435\u043a\u043e\u043c\u0435\u043d\u0434\u0430\u0446\u0438\u0438 \u043f\u043e \u0432\u0438\u0440\u0442\u0443\u0430\u043b\u0438\u0437\u0430\u0446\u0438\u0438 SQL Server \u0441 \u043f\u043e\u043c\u043e\u0449\u044c\u044e \u0442\u0435\u0445\u043d\u043e\u043b\u043e\u0433\u0438\u0438 VMware, \u043f\u043e \u043d\u0430\u0441\u0442\u0440\u043e\u0439\u043a\u0435 \u0438 \u0443\u043f\u0440\u0430\u0432\u043b\u0435\u043d\u0438\u044e.\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<meta name=\"author\" content=\"Yuri Gagarin\"\/>\n\t<link rel=\"canonical\" href=\"https:\/\/prohoster.info\/lv\/blog\/administrirovanie\/microsoft-sql-server-2019-i-flesh-massivy-dell-emc-unity-xt\" \/>\n\t\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.4\" \/>\n\t\t<meta property=\"og:locale\" content=\"lv_LV\" \/>\n\t\t<meta property=\"og:site_name\" content=\"ProHoster | \u041a\u0443\u043f\u0438\u0442\u044c \u043d\u0430\u0434\u0435\u0436\u043d\u044b\u0439 \u0445\u043e\u0441\u0442\u0438\u043d\u0433 \u0434\u043b\u044f \u0441\u0430\u0439\u0442\u043e\u0432 \u0441 \u0437\u0430\u0449\u0438\u0442\u043e\u0439 \u043e\u0442 DDoS, VPS VDS \u0441\u0435\u0440\u0432\u0435\u0440\u044b\" \/>\n\t\t<meta property=\"og:type\" content=\"article\" \/>\n\t\t<meta property=\"og:title\" content=\"\ud83e\udd47Microsoft SQL Server 2019 \u0438 \u0444\u043b\u044d\u0448-\u043c\u0430\u0441\u0441\u0438\u0432\u044b Dell EMC Unity XT | ProHoster\" \/>\n\t\t<meta property=\"og:description\" content=\"\u0421\u0435\u0433\u043e\u0434\u043d\u044f \u043c\u044b \u043f\u043e\u0437\u043d\u0430\u043a\u043e\u043c\u0438\u043c \u0432\u0430\u0441 \u0441 \u043e\u0441\u043e\u0431\u0435\u043d\u043d\u043e\u0441\u0442\u044f\u043c\u0438 \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u043d\u0438\u044f SQL Server 2019 \u0441 \u0441\u0438\u0441\u0442\u0435\u043c\u043e\u0439 \u0445\u0440\u0430\u043d\u0435\u043d\u0438\u044f Unity XT, \u0430 \u0442\u0430\u043a\u0436\u0435 \u0434\u0430\u0434\u0438\u043c \u0440\u0435\u043a\u043e\u043c\u0435\u043d\u0434\u0430\u0446\u0438\u0438 \u043f\u043e \u0432\u0438\u0440\u0442\u0443\u0430\u043b\u0438\u0437\u0430\u0446\u0438\u0438 SQL Server \u0441 \u043f\u043e\u043c\u043e\u0449\u044c\u044e \u0442\u0435\u0445\u043d\u043e\u043b\u043e\u0433\u0438\u0438 VMware, \u043f\u043e \u043d\u0430\u0441\u0442\u0440\u043e\u0439\u043a\u0435 \u0438 \u0443\u043f\u0440\u0430\u0432\u043b\u0435\u043d\u0438\u044e.\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/prohoster.info\/lv\/blog\/administrirovanie\/microsoft-sql-server-2019-i-flesh-massivy-dell-emc-unity-xt\" \/>\n\t\t<meta property=\"og:image\" content=\"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg\" \/>\n\t\t<meta property=\"og:image:secure_url\" content=\"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg\" \/>\n\t\t<meta property=\"og:image:width\" content=\"350\" \/>\n\t\t<meta property=\"og:image:height\" content=\"350\" \/>\n\t\t<meta property=\"article:published_time\" content=\"2019-12-03T21:00:00+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2020-02-18T11:01:26+00:00\" \/>\n\t\t<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/prohoster\" \/>\n\t\t<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/prohoster\" \/>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"\ud83e\udd47Microsoft SQL Server 2019 un Dell EMC Unity XT fle\u0161atmi\u0146as | ProHoster","description":"\u0160odien m\u0113s iepaz\u012bstin\u0101sim j\u016bs ar SQL Server 2019 izmanto\u0161anas \u012bpatn\u012bb\u0101m ar Unity XT glab\u0101\u0161anas sist\u0113mu, k\u0101 ar\u012b sniegsim ieteikumus SQL Server virtualiz\u0101cijai, izmantojot VMware tehnolo\u0123iju, par konfigur\u0101ciju un p\u0101rvald\u012bbu.","canonical_url":"https:\/\/prohoster.info\/lv\/blog\/administrirovanie\/microsoft-sql-server-2019-i-flesh-massivy-dell-emc-unity-xt","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"lv_LV","og:site_name":"ProHoster | \u041a\u0443\u043f\u0438\u0442\u044c \u043d\u0430\u0434\u0435\u0436\u043d\u044b\u0439 \u0445\u043e\u0441\u0442\u0438\u043d\u0433 \u0434\u043b\u044f \u0441\u0430\u0439\u0442\u043e\u0432 \u0441 \u0437\u0430\u0449\u0438\u0442\u043e\u0439 \u043e\u0442 DDoS, VPS VDS \u0441\u0435\u0440\u0432\u0435\u0440\u044b","og:type":"article","og:title":"\ud83e\udd47Microsoft SQL Server 2019 \u0438 \u0444\u043b\u044d\u0448-\u043c\u0430\u0441\u0441\u0438\u0432\u044b Dell EMC Unity XT | ProHoster","og:description":"\u0421\u0435\u0433\u043e\u0434\u043d\u044f \u043c\u044b \u043f\u043e\u0437\u043d\u0430\u043a\u043e\u043c\u0438\u043c \u0432\u0430\u0441 \u0441 \u043e\u0441\u043e\u0431\u0435\u043d\u043d\u043e\u0441\u0442\u044f\u043c\u0438 \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u043d\u0438\u044f SQL Server 2019 \u0441 \u0441\u0438\u0441\u0442\u0435\u043c\u043e\u0439 \u0445\u0440\u0430\u043d\u0435\u043d\u0438\u044f Unity XT, \u0430 \u0442\u0430\u043a\u0436\u0435 \u0434\u0430\u0434\u0438\u043c \u0440\u0435\u043a\u043e\u043c\u0435\u043d\u0434\u0430\u0446\u0438\u0438 \u043f\u043e \u0432\u0438\u0440\u0442\u0443\u0430\u043b\u0438\u0437\u0430\u0446\u0438\u0438 SQL Server \u0441 \u043f\u043e\u043c\u043e\u0449\u044c\u044e \u0442\u0435\u0445\u043d\u043e\u043b\u043e\u0433\u0438\u0438 VMware, \u043f\u043e \u043d\u0430\u0441\u0442\u0440\u043e\u0439\u043a\u0435 \u0438 \u0443\u043f\u0440\u0430\u0432\u043b\u0435\u043d\u0438\u044e.","og:url":"https:\/\/prohoster.info\/lv\/blog\/administrirovanie\/microsoft-sql-server-2019-i-flesh-massivy-dell-emc-unity-xt","og:image":"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg","og:image:secure_url":"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg","og:image:width":350,"og:image:height":350,"article:published_time":"2019-12-03T21:00:00+00:00","article:modified_time":"2020-02-18T11:01:26+00:00","article:publisher":"https:\/\/www.facebook.com\/prohoster","article:author":"https:\/\/www.facebook.com\/prohoster"},"aioseo_meta_data":{"post_id":"53529","title":null,"description":null,"keywords":null,"keyphrases":null,"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":null,"og_custom_url":null,"og_article_section":null,"og_article_tags":null,"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"","isEnabled":true},"graphs":[]},"schema_type":null,"schema_type_options":null,"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":null,"robots_max_videopreview":null,"robots_max_imagepreview":"large","priority":null,"frequency":null,"local_seo":null,"seo_analyzer_scan_date":"2026-01-24 07:44:22","breadcrumb_settings":null,"limit_modified_date":false,"reviewed_by":null,"ai":null,"created":"2021-02-28 20:23:55","updated":"2026-01-24 07:44:22","focus_keyword":null,"additional_keywords":null,"truseo_locale":null},"gt_translate_keys":[{"key":"link","format":"url"}],"_links":{"self":[{"href":"https:\/\/prohoster.info\/lv\/wp-json\/wp\/v2\/posts\/53529","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/lv\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/lv\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/lv\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/lv\/wp-json\/wp\/v2\/comments?post=53529"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/lv\/wp-json\/wp\/v2\/posts\/53529\/revisions"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/lv\/wp-json\/wp\/v2\/media?parent=53529"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/lv\/wp-json\/wp\/v2\/categories?post=53529"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/lv\/wp-json\/wp\/v2\/tags?post=53529"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}