{"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\/sk\/blog\/administrirovanie\/microsoft-sql-server-2019-i-flesh-massivy-dell-emc-unity-xt","title":{"rendered":"Microsoft SQL Server 2019 a flashov\u00e9 pole Dell EMC Unity XT","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p>Dnes v\u00e1s zozn\u00e1mime s vlastnos\u0165ami pou\u017e\u00edvania SQL Server 2019 so syst\u00e9mom ukladania Unity XT a poskytneme odpor\u00fa\u010dania na virtualiz\u00e1ciu SQL Server pomocou technol\u00f3gie VMware, ako aj na nastavenie a spr\u00e1vu z\u00e1kladn\u00fdch komponentov infra\u0161trukt\u00fary 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 a flashov\u00e9 pole Dell EMC Unity XT\" src=\"\/wp-content\/uploads\/2019\/12\/fe6c5fbfbfb8883ce3bcd215bff0f477.jpg\" style=\"display:block;margin: 0 auto;\" \/><\/a><\/noindex><br \/>\nV roku 2017 Dell EMC a VMware zverejnili v\u00fdsledky prieskumu o trendoch a evol\u00facii SQL Server \u2013 \u201eTransform\u00e1cia SQL Server: na ceste k flexibilite a odolnosti\u201c (<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>), v ktorom sa vyu\u017e\u00edvali sk\u00fasenosti \u010dlenov Profesion\u00e1lnej asoci\u00e1cie SQL Server (Professional Association of SQL Server, PASS). V\u00fdsledky ukazuj\u00fa, \u017ee prostredia datab\u00e1z SQL Server rast\u00fa nielen na ve\u013ekosti, ale aj zlo\u017eitosti, \u010do je sp\u00f4soben\u00e9 rast\u00facimi objemami d\u00e1t a nov\u00fdmi obchodn\u00fdmi po\u017eiadavkami. Datab\u00e1zy SQL Server s\u00fa v s\u00fa\u010dasnosti nasaden\u00e9 v mnoh\u00fdch spolo\u010dnostiach, pri\u010dom zabezpe\u010duj\u00fa fungovanie kriticky d\u00f4le\u017eit\u00fdch aplik\u00e1ci\u00ed a \u010dasto sl\u00fa\u017eia ako z\u00e1klad digit\u00e1lnej transform\u00e1cie.\u00a0<\/p>\n<p>Od vykonania tohto prieskumu Microsoft vydal \u010fal\u0161iu gener\u00e1ciu S\u00daDB \u2013 SQL Server 2019. Okrem zlep\u0161enia z\u00e1kladn\u00fdch funkci\u00ed rela\u010dn\u00e9ho enginu a ukladania d\u00e1t sa objavili nov\u00e9 slu\u017eby a funkcie. Napr\u00edklad SQL Server 2019 zah\u0155\u0148a podporu pracovn\u00fdch z\u00e1\u0165a\u017e\u00ed pre ve\u013ek\u00e9 d\u00e1ta pomocou Apache Spark a distribuovan\u00e9ho s\u00faborov\u00e9ho syst\u00e9mu Hadoop (Hadoop Distributed File System, HDFS).<br \/>\n<noindex><a rel=\"nofollow\" name=\"habracut\"><\/a><\/noindex><\/p>\n<h2>Aliancia Dell EMC a Microsoft<\/h2>\n<p>\nDell EMC a Microsoft dlhodobo spolupracuj\u00fa v oblasti v\u00fdvoja rie\u0161en\u00ed pre SQL Server. \u00daspe\u0161n\u00e1 implement\u00e1cia komplexnej platformy datab\u00e1z, ako je Microsoft SQL Server, vy\u017eaduje koordin\u00e1ciu funkci\u00ed softv\u00e9ru s podkladovou IT infra\u0161trukt\u00farou. T\u00e1to infra\u0161trukt\u00fara zah\u0155\u0148a v\u00fdpo\u010dtov\u00e9 zdroje procesora, pam\u00e4tov\u00e9 zdroje, \u00falo\u017eisk\u00e1 a sie\u0165ov\u00e9 slu\u017eby. Dell EMC pon\u00faka infra\u0161trukt\u00faru pre platformu SQL Server pre ak\u00fdko\u013evek typ z\u00e1\u0165a\u017ee a aplik\u00e1ci\u00ed.<\/p>\n<p>Rada serverov Dell EMC PowerEdge pon\u00faka mno\u017estvo konfigur\u00e1ci\u00ed procesorov a pam\u00e4te. Tieto konfigur\u00e1cie s\u00fa vhodn\u00e9 pre \u0161irok\u00e9 spektrum z\u00e1\u0165a\u017e\u00ed: od mal\u00fdch podnikov\u00fdch aplik\u00e1ci\u00ed po najv\u00e4\u010d\u0161ie kriticky d\u00f4le\u017eit\u00e9 syst\u00e9my, ako s\u00fa pl\u00e1novanie zdrojov podniku (ERP), \u00falo\u017eisk\u00e1 d\u00e1t, pokro\u010dil\u00e1 analytika, elektronick\u00fd obchod a \u010fal\u0161ie. Rada SCSI je navrhnut\u00e1 na ukladanie \u0161trukt\u00farovan\u00fdch a ne\u0161trukt\u00farovan\u00fdch d\u00e1t.\u00a0<\/p>\n<p>Z\u00e1kazn\u00edci, ktor\u00ed nasadzuj\u00fa SQL Server 2019 s infra\u0161trukt\u00farou Dell EMC, m\u00f4\u017eu pracova\u0165 so \u0161trukt\u00farovan\u00fdmi aj ne\u0161trukt\u00farovan\u00fdmi \u00fadajmi pomocou SQL Server a Apache Spark. SQL Server tie\u017e podporuje kombin\u00e1cie technol\u00f3gi\u00ed klientskeho pr\u00edstupu, medzi-serverovej komunik\u00e1cie a komunik\u00e1cie \u201eserver-sklad\u201c. Koncepcia Dell EMC je zalo\u017een\u00e1 na de-aggregovanej modelu, ktor\u00fd pon\u00faka otvoren\u00fa ekosyst\u00e9mu. Organiz\u00e1cie si m\u00f4\u017eu vybra\u0165 z \u0161irokej \u0161k\u00e1ly \u0161tandardn\u00fdch priemyseln\u00fdch sie\u0165ov\u00fdch aplik\u00e1ci\u00ed, opera\u010dn\u00fdch syst\u00e9mov a hardv\u00e9rov\u00fdch platforiem. Tento pr\u00edstup poskytuje maxim\u00e1lnu kontrolu nad technol\u00f3giami a architekt\u00farami, \u010do vedie k v\u00fdznamnej \u00faspore n\u00e1kladov a flexibilite.<\/p>\n<p>VMware zabezpe\u010duje virtualiz\u00e1ciu v\u0161etk\u00fdch kritick\u00fdch komponentov infra\u0161trukt\u00fary, ktor\u00e9 s\u00fa potrebn\u00e9 SQL Serveru na dosiahnutie vysokej v\u00fdkonnosti a konzistentnosti oper\u00e1ci\u00ed. Okrem s\u00fakromn\u00e9ho cloudu pon\u00fakaj\u00fa VMware pre pracovn\u00e9 za\u0165a\u017eenia v s\u00fa\u010dasnosti aj hybridn\u00e9 modely, ktor\u00e9 pokr\u00fdvaj\u00fa s\u00fakromn\u00e9 a verejn\u00e9 cloudov\u00e9 architekt\u00fary.\u00a0<\/p>\n<p>Mnoh\u00e9 organiz\u00e1cie sa uchy\u013euj\u00fa k virtualiz\u00e1cii, aby zn\u00ed\u017eili n\u00e1klady na infra\u0161trukt\u00faru, zabezpe\u010dili vysok\u00fa dostupnos\u0165 a zjednodu\u0161ili havarijn\u00e9 obnovovanie. 94% respondentov medzi odborn\u00edkmi na SQL Server hl\u00e1si ur\u010dit\u00fa \u00farove\u0148 virtualiz\u00e1cie vo svojej prostred\u00ed. 70% t\u00fdch, ktor\u00ed pou\u017e\u00edvaj\u00fa virtualiz\u00e1ciu, si vybralo VMware. U 60% sa \u00farove\u0148 virtualiz\u00e1cie SQL Serveru pohybuje na \u00farovni 75% a viac. Navy\u0161e v\u00fdsledky prieskumu presved\u010divo preukazuj\u00fa, \u017ee vysok\u00e1 dostupnos\u0165 a havarijn\u00e9 obnovovanie realizovan\u00e9 na \u00farovni virtualiz\u00e1cie sa stali d\u00f4le\u017eit\u00fdmi faktormi pri rozhodovan\u00ed o virtualiz\u00e1cii datab\u00e1z SQL Server.<\/p>\n<h2>Nov\u00e9 funkcie SQL Server 2019<\/h2>\n<p>\nPlatforma datab\u00e1z SQL Server 2019 zah\u0155\u0148a \u0161irok\u00fa \u0161k\u00e1lu technol\u00f3gi\u00ed, funkci\u00ed a slu\u017eieb, ktor\u00e9 podporuj\u00fa kriticky d\u00f4le\u017eit\u00e9 aplik\u00e1cie, ako s\u00fa analytika, podnikov\u00e9 datab\u00e1zy, obchodn\u00e1 analytika (BI) a \u0161k\u00e1lovate\u013en\u00e9 spracovanie transakci\u00ed (OLTP). Platforma SQL Server z\u00edskala schopnosti na riadenie integr\u00e1cie d\u00e1t, d\u00e1tov\u00e9ho skladu, reportingu a pokro\u010dilej analytiky, funkcie replik\u00e1cie a spr\u00e1vy polostrukt\u00farovan\u00fdch typov d\u00e1t. Samozrejme, nie v\u0161etci klienti alebo aplik\u00e1cie potrebuj\u00fa v\u0161etky tieto funkcie. Okrem toho je v mnoh\u00fdch pr\u00edpadoch v\u00fdhodn\u00e9 oddeli\u0165 slu\u017eby SQL Server pomocou virtualiz\u00e1cie.\u00a0<\/p>\n<p>Dnes sa podniky \u010dasto musia spolieha\u0165 na ve\u013ek\u00e9 objemy d\u00e1t z \u0161irok\u00e9ho spektra neust\u00e1le sa zvy\u0161uj\u00facich s\u00faborov d\u00e1t. S pomocou SQL Server 2019 m\u00f4\u017eete z\u00edskava\u0165 cenn\u00e9 inform\u00e1cie takmer v re\u00e1lnom \u010dase zo v\u0161etk\u00fdch d\u00e1t. Klastre SQL Server 2019 poskytuj\u00fa plnohodnotn\u00e9 prostredie na pr\u00e1cu s ve\u013ek\u00fdmi s\u00fabormi d\u00e1t, vr\u00e1tane vyu\u017e\u00edvania strojov\u00e9ho u\u010denia a schopnost\u00ed umelej inteligencie. Hlavn\u00e9 nov\u00e9 funkcie a aktualiz\u00e1cie v SQL Server 2019 s\u00fa uveden\u00e9 v <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\">dokumente Microsoft<\/a><\/noindex>.<\/p>\n<h2>Syst\u00e9m ukladania strednej triedy Dell EMC Unity XT<\/h2>\n<p>\nS\u00e9ria \u00falo\u017en\u00fdch syst\u00e9mov Dell EMC Unity sa objavila pred takmer troma rokmi a odvtedy bolo predan\u00fdch viac ako 40 000 syst\u00e9mov. Z\u00e1kazn\u00edci ocenili tento \u00falo\u017en\u00fd syst\u00e9m strednej triedy za jeho jednoduchnos\u0165, v\u00fdkon a n\u00e1kladov\u00fa efekt\u00edvnos\u0165. Platformy strednej triedy Dell EMC Unity XT s\u00fa rie\u0161enia s univerz\u00e1lnym \u00falo\u017eiskom, ktor\u00e9 zabezpe\u010duj\u00fa n\u00edzku latenciu, vysok\u00fa priepustnos\u0165 a n\u00edzke n\u00e1klady na spr\u00e1vu pre pracovn\u00e9 za\u0165a\u017eenia SQL Server. V\u0161etky syst\u00e9my Unity XT pou\u017e\u00edvaj\u00fa architekt\u00faru s dvoma procesormi (storage processors, SP) na obsluhu vstupu-v\u00fdstupu a vykon\u00e1vanie oper\u00e1ci\u00ed s d\u00e1tami v re\u017eime active\/active. V Unity XT je pre zaistenie vysokej v\u00fdkonnosti a efektivity pou\u017eit\u00e1 pln\u00e1 intern\u00e1 konektivita SAS 12 Gbit\/s a patentovan\u00e1 viacjadrov\u00e1 architekt\u00fara. Diskov\u00e9 polia umo\u017e\u0148uj\u00fa zvy\u0161ova\u0165 kapacitu ukladania pomocou dodato\u010dn\u00fdch pol\u00edc.<\/p>\n<p><img decoding=\"async\" alt=\"Microsoft SQL Server 2019 a flashov\u00e9 pole Dell EMC Unity XT\" src=\"\/wp-content\/uploads\/2019\/12\/d39fe24c2a392656402201d8957714bc.jpg\" style=\"display:block;margin: 0 auto;\" \/><br \/>\nV Dell EMC Unity XT, novej gener\u00e1cii \u00falo\u017e\u00edsk (hybridn\u00fdch a plne flashov\u00fdch), sa v\u00fdrazne zlep\u0161il v\u00fdkon, efektivita a pridali sa nov\u00e9 funkcie a slu\u017eby pre multi-cloud prostredia.\u00a0<\/p>\n<p>Architekt\u00fara Unity XT umo\u017e\u0148uje s\u00fa\u010dasn\u00e9 spracovanie d\u00e1t, zni\u017eovanie ich objemu a podporu slu\u017eieb ako replik\u00e1cia bez ovplyvnenia v\u00fdkonu aplik\u00e1ci\u00ed. V porovnan\u00ed so star\u0161ou gener\u00e1ciou sa v\u00fdkon \u00falo\u017en\u00e9ho syst\u00e9mu Dell EMC Unity XT zdvojn\u00e1sobil, doba odozvy sa zn\u00ed\u017eila o 75%. A samozrejme, Dell EMC Unity podporuje \u0161tandard NVMe.<\/p>\n<p>\u00dalo\u017en\u00e9 syst\u00e9my s NVMe diskami vykazuj\u00fa svoje najlep\u0161ie vlastnosti v aplik\u00e1ci\u00e1ch citliv\u00fdch na latenciu. Napr\u00edklad, v aplik\u00e1ci\u00e1ch ako s\u00fa obrovsk\u00e9 datab\u00e1zy, NVMe zabezpe\u010duje n\u00edzke latencie a vysok\u00e9 \u0161pi\u010dkov\u00e9 r\u00fdchlosti prenosu d\u00e1t. Zn\u00ed\u017eenie latencie a zv\u00fd\u0161enie paralelizmu v\u00fdrazne zvy\u0161uj\u00fa v\u00fdkon oper\u00e1ci\u00ed \u010d\u00edtania\/z\u00e1pisu. Nie je n\u00e1hodou, \u017ee pod\u013ea predpovede IDC do roku 2021 NVMe pripojen\u00e9 flash \u00falo\u017eisk\u00e1 a NVMe-oF (NVMe over Fabric) bud\u00fa tvori\u0165 pribli\u017ene polovicu v\u0161etk\u00fdch pr\u00edjmov z predaja extern\u00fdch \u00falo\u017e\u00edsk na svete.\u00a0<\/p>\n<p>Ekonomickos\u0165 ukladania zlep\u0161uj\u00fa algoritmy kompresie d\u00e1t. Dell EMC Unity XT dok\u00e1\u017ee zn\u00ed\u017ei\u0165 objem d\u00e1t a\u017e p\u00e4\u0165kr\u00e1t. In\u00fdm d\u00f4le\u017eit\u00fdm ukazovate\u013eom je celkov\u00e1 efekt\u00edvnos\u0165 syst\u00e9mu. Dell EMC Unity XT vyu\u017e\u00edva syst\u00e9mov\u00fa kapacitu na 85%. Kompresia a deduplik\u00e1cia sa vykon\u00e1vaj\u00fa v re\u017eime inline \u2013 na \u00farovni ovl\u00e1da\u010dov. \u00dadaje s\u00fa uchov\u00e1van\u00e9 v stla\u010denej podobe. Syst\u00e9m tie\u017e automatizuje pr\u00e1cu so sn\u00edmkami d\u00e1t.<\/p>\n<p>Jednoduch\u00e9 na pou\u017e\u00edvanie flash \u00falo\u017eisk\u00e1 Unity s unifikovan\u00fdm (blokov\u00fdm a s\u00faborov\u00fdm) pr\u00edstupom zabezpe\u010duj\u00fa stabiln\u00fa dobu odozvy, integruj\u00fa sa s cloudov\u00fdmi slu\u017ebami ukladania a podporuj\u00fa upgrade bez migr\u00e1cie d\u00e1t. V z\u00e1kladnej konfigur\u00e1cii sa tento univerz\u00e1lny \u00falo\u017en\u00fd syst\u00e9m in\u0161taluje za 30 min\u00fat.<\/p>\n<p>Technol\u00f3gia ukladania d\u00e1t naz\u00fdvan\u00e1 \u201edynamick\u00e9 pooly\u201c umo\u017e\u0148uje prechod od statick\u00e9ho k dynamick\u00e9mu roz\u0161irovaniu pam\u00e4te, poskytuje vysok\u00fa prev\u00e1dzkov\u00fa flexibilitu a jednoduchos\u0165 pri zvy\u0161ovan\u00ed kapacity syst\u00e9mu. Dynamick\u00e9 pooly \u0161etria kapacitu a rozpo\u010det, vy\u017eaduj\u00fa menej \u010dasu na prestavbu. Zvy\u0161ovanie kapacity a v\u00fdkonu Dell EMC Unity nevy\u017eaduje migr\u00e1ciu d\u00e1t.\u00a0<\/p>\n<p>Mnoh\u00e9 spolo\u010dnosti dnes pou\u017e\u00edvaj\u00fa nieko\u013eko verejn\u00fdch cloudov\u00fdch slu\u017eieb v kombin\u00e1cii so svojou lok\u00e1lnou infrastrukturou. Dell EMC Unity XT m\u00f4\u017ee fungova\u0165 ako s\u00fa\u010das\u0165 cloudov\u00e9ho prostredia Dell Technologies Cloud. Tento \u00falo\u017en\u00fd syst\u00e9m sa d\u00e1 vyu\u017ei\u0165 vo verejnom cloude a pren\u00e1\u0161a\u0165 d\u00e1ta do s\u00fakromn\u00e9ho cloudu. Navy\u0161e, \u00falo\u017en\u00fd syst\u00e9m Dell EMC Unity XT je k dispoz\u00edcii na modeli \u201eako slu\u017eba\u201c. Ide o jednu z cloudov\u00fdch slu\u017eieb \u00falo\u017en\u00e9ho syst\u00e9mu Dell EMC Cloud Storage Services.<br \/>\n\u00a0<br \/>\nCloudov\u00e9 \u00falo\u017eisk\u00e1 z\u00edskavaj\u00fa \u010doraz v\u00e4\u010d\u0161iu popularitu, preto\u017ee umo\u017e\u0148uj\u00fa zv\u00fd\u0161i\u0165 n\u00e1vratnos\u0165 invest\u00edci\u00ed zn\u00ed\u017een\u00edm n\u00e1kladov na infra\u0161trukt\u00faru. Slu\u017eby cloudov\u00e9ho \u00falo\u017eiska Cloud Storage Services roz\u0161iruj\u00fa centr\u00e1 spracovania d\u00e1t z\u00e1kazn\u00edkov do cloudu, poskytuj\u00fac \u00falo\u017eisko Dell EMC (priamo pripojen\u00e9 k zdrojom verejn\u00e9ho cloudu) ako slu\u017ebu. Tret\u00ed poskytovatelia m\u00f4\u017eu zabezpe\u010di\u0165 vysokor\u00fdchlostn\u00e9 pripojenie (s n\u00edzkou latenciou) verejn\u00e9ho cloudu priamo so syst\u00e9mami Dell EMC Unity, PowerMax a Isilon v d\u00e1tovom centre z\u00e1kazn\u00edka.<\/p>\n<p>Do rodiny Unity XT patria syst\u00e9my Unity XT All-Flash, Unity XT Hybrid, UnityVSA a Unity Cloud Edition.<br \/>\n\u00a0<\/p>\n<h2>Upraven\u00e9 hybridn\u00e9 a flash \u00falo\u017eisk\u00e1\u00a0<\/h2>\n<p>\nSyst\u00e9my \u00falo\u017eiska Unity XT Hybrid a Unity XT All-Flash, zalo\u017een\u00e9 na procesoroch Intel, realizuj\u00fa integrovan\u00fa architekt\u00faru pre blokov\u00fd, s\u00faborov\u00fd pr\u00edstup a objemy VMware VVols s podporou protokolov sie\u0165ov\u00e9ho ukladania (NAS), iSCSI a Fibre Channel (FC). Platformy Unity XT Hybrid a Unity XT All-Flash s\u00fa pripraven\u00e9 na pou\u017eitie s NVMe \u00falo\u017eiskami.<\/p>\n<p>Hybridn\u00e9 syst\u00e9my Unity XT podporuj\u00fa prev\u00e1dzku v multicloudov\u00fdch prostrediach. Podpora multicloudov\u00fdch prostred\u00ed znamen\u00e1 roz\u0161\u00edrenie syst\u00e9mu ukladania d\u00e1t do cloudu alebo nasadenie v cloude s flexibiln\u00fdmi mo\u017enos\u0165ami vyu\u017eitia zdrojov. Multicloudov\u00e9 \u00falo\u017eisk\u00e1 s\u00fa navrhnut\u00e9 tak, aby poskytovali mobilitu a prenosnos\u0165 d\u00e1t medzi viacer\u00fdmi cloudov\u00fdmi platformami \u2013 s\u00fakromn\u00fdmi aj verejn\u00fdmi. To ovplyv\u0148uje nielen procesy pres\u00favania d\u00e1t, ale aj organiz\u00e1ciu pr\u00edstupu aplik\u00e1ci\u00ed k d\u00e1tam v nieko\u013ek\u00fdch verejn\u00fdch cloudoch. <\/p>\n<p><img decoding=\"async\" alt=\"Microsoft SQL Server 2019 a flashov\u00e9 pole Dell EMC Unity XT\" src=\"\/wp-content\/uploads\/2019\/12\/d61d5fa31b94676109c89338070dbf0b.jpg\" style=\"display:block;margin: 0 auto;\" \/><br \/>\nTieto hybridn\u00e9 \u00falo\u017eisk\u00e1 poskytuj\u00fa nasleduj\u00face mo\u017enosti:<\/p>\n<ul>\n<li>\u0160k\u00e1lovate\u013enos\u0165 a\u017e do 16 PB \u201ehrubej\u201c kapacity.<\/li>\n<li>Vstavan\u00e9 funkcie zmen\u0161ovania objemu d\u00e1t pre v\u0161etky flash pooly.<\/li>\n<li>R\u00fdchla in\u0161tal\u00e1cia a nastavenie (v priemere trv\u00e1 25 min\u00fat).<\/li>\n<\/ul>\n<p>\nTechnol\u00f3gie pevn\u00fd diskov sa r\u00fdchlo vyv\u00edjaj\u00fa a v najbli\u017e\u0161\u00edch rokoch sa na trhu objavia nov\u00e9 revolu\u010dn\u00e9 produkty. Medzit\u00fdm bud\u00fa organiz\u00e1cie pokra\u010dova\u0165 v nahr\u00e1dzan\u00ed tradi\u010dn\u00fdch HDD diskov pevn\u00fdmi diskami na zv\u00fd\u0161enie v\u00fdkonnosti, jednoduchosti spr\u00e1vy a \u00faspory energie. Nov\u00e9 gener\u00e1cie flashov\u00fdc hmat\u00edc bud\u00fa charakterizova\u0165 pokro\u010dilej\u0161ie n\u00e1stroje na automatiz\u00e1ciu ukladania, integr\u00e1ciu s verejn\u00fdm cloudom a integrovan\u00fa ochranu d\u00e1t.\u00a0<\/p>\n<p>Syst\u00e9my Unity XT All-Flash zabezpe\u010duj\u00fa vysok\u00fa r\u00fdchlos\u0165, efekt\u00edvnos\u0165 a podporu viacer\u00fdch cloudov. Ich vlastnosti:<\/p>\n<ul>\n<li>Dvojn\u00e1sobn\u00e1 v\u00fdkonnos\u0165.<\/li>\n<li>Zn\u00ed\u017eenie objemu d\u00e1t a\u017e 7:1.<\/li>\n<li>R\u00fdchla in\u0161tal\u00e1cia a nastavenie (proces trv\u00e1 menej ako 30 min\u00fat).<\/li>\n<\/ul>\n<p><\/p>\n<h2>\u00a0UnityVSA<\/h2>\n<p>\nSyst\u00e9m UnityVSA je softv\u00e9rom definovan\u00fd \u00falo\u017en\u00fd syst\u00e9m pre virtu\u00e1lne prostredia VMware ESXi, ktor\u00fd vyu\u017e\u00edva serverov\u00fa, zdie\u013ean\u00fa alebo cloudov\u00fa kapacitu \u00falo\u017eiska. UnityVSA HA, konfigur\u00e1cia s dvomi \u00falo\u017eiskami UnityVSA, poskytuje dodato\u010dn\u00fa odolnos\u0165 vo\u010di zlyhaniu. \u00dalo\u017eisko UnityVSA pon\u00faka:<\/p>\n<ul>\n<li>A\u017e 50 TB kapacity plne funk\u010dn\u00e9ho unified storage.<\/li>\n<li>Kompatibilitu so syst\u00e9mami a funkciami Unity XT.<\/li>\n<li>Podporu syst\u00e9mov vysokej dostupnosti (UnityVSA HA).<\/li>\n<li>Pripojenie ako NAS a iSCSI.<\/li>\n<li>Replik\u00e1ciu d\u00e1t z in\u00fdch platforiem Unity XT.<\/li>\n<\/ul>\n<p><\/p>\n<h2>Unity Cloud Edition<\/h2>\n<p>\nPre synchroniz\u00e1ciu s\u00faborov a oper\u00e1ci\u00ed obnovy po hav\u00e1rii s cloudom obsahuje rodina Unity XT verziu Unity Cloud Edition, ktor\u00e1 zabezpe\u010duje:<\/p>\n<ul>\n<li>Plne funk\u010dn\u00e9 mo\u017enosti ukladania s pou\u017eit\u00edm softv\u00e9rovo definovan\u00e9ho \u00falo\u017eiska (SDS), nasaden\u00e9ho v cloude.<\/li>\n<li>Jednoduch\u00e9 nasadenie blokov\u00e9ho a s\u00faborov\u00e9ho ukladania pomocou VMware Cloud v AWS.<\/li>\n<li>Podporu pre obnovu po hav\u00e1rii, vr\u00e1tane testovania a anal\u00fdzy d\u00e1t.<\/li>\n<\/ul>\n<p>\n<img decoding=\"async\" alt=\"Microsoft SQL Server 2019 a flashov\u00e9 pole Dell EMC Unity XT\" src=\"\/wp-content\/uploads\/2019\/12\/0f866ce4aaac379a9bb8701e7367fd55.jpg\" style=\"display:block;margin: 0 auto;\" \/><\/p>\n<h2>Unity XT All Flash pre SQL Server<\/h2>\n<p>\nV spr\u00e1ve Unisphere Research z roku 2017 'Transform\u00e1cia SQL Server: na ceste k flexibilite a odolnosti' (<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% respondentov uviedlo, \u017ee pou\u017e\u00edvaj\u00fa technol\u00f3giu flash \u00falo\u017eiska v produkcii (16%) alebo pl\u00e1nuj\u00fa tak urobi\u0165 (6%). 30% vyu\u017e\u00edva hybridn\u00e9 matice, ktor\u00e9 zah\u0155\u0148aj\u00fa flash pam\u00e4\u0165. 13% pou\u017e\u00edva flash matice s priamym pripojen\u00edm. 13% rob\u00ed z\u00e1lohy datab\u00e1z SQL Server na flash \u00falo\u017eisku.<\/p>\n<p>R\u00fdchla implement\u00e1cia flash \u00falo\u017e\u00edsk na pou\u017eitie so SQL Serverom znamen\u00e1, \u017ee rie\u0161enia Unity XT All-Flash s\u00fa obzvl\u00e1\u0161\u0165 vhodn\u00e9 pre v\u00fdvoj\u00e1rov a administr\u00e1torov SQL Servera. Syst\u00e9my Unity XT All-Flash poskytuj\u00fa v\u00fdvoj\u00e1rom a administr\u00e1torom SQL Servera mo\u017enosti a v\u00fdkon, ktor\u00e9 presahuj\u00fa to, \u010do pon\u00fakaj\u00fa typick\u00e9 \u00falo\u017en\u00e9 siete (SAN).<\/p>\n<p><img decoding=\"async\" alt=\"Microsoft SQL Server 2019 a flashov\u00e9 pole Dell EMC Unity XT\" src=\"\/wp-content\/uploads\/2019\/12\/7236f0c77513950c58d26dc5e86b20d5.jpg\" style=\"display:block;margin: 0 auto;\" \/><br \/>\nSyst\u00e9my Unity XT All-Flash, ktor\u00e9 s\u00fa pripraven\u00e9 na implement\u00e1ciu NVMe (pre e\u0161te vy\u0161\u0161\u00ed v\u00fdkon a n\u00edzku latenciu), maj\u00fa form\u00e1t 2U, podporuj\u00fa dvojjadrov\u00e9 procesory a dva kontrol\u00e9ry v re\u017eime active\/active.<\/p>\n<p><b>Modely Unity XT All-Flash<\/b><\/p>\n<p>Unity XT\u00a0<\/p>\n<p>Procesory\u00a0<\/p>\n<p>Pam\u00e4\u0165 (na procesor)<\/p>\n<p>Max. po\u010det diskov<\/p>\n<p>Max. \u201ehrub\u00e1\u201c kapacita (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>Podrobnosti n\u00e1jdete v \u0161pecifik\u00e1ci\u00e1ch po\u013ea (<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>\u00dalo\u017en\u00e9 pooly<\/h2>\n<p>\nMnoh\u00ed profesion\u00e1li pracuj\u00faci so SQL Serverom vedia, \u017ee v\u0161etky modern\u00e9 \u00falo\u017en\u00e9 pole umo\u017e\u0148uj\u00fa zoskupenie diskov do v\u00e4\u010d\u0161\u00edch \u00falo\u017en\u00fdch jednotiek s pevnou \u00farov\u0148ou ochrany RAID. Samostatn\u00e9 skupiny diskov s ochranou RAID s\u00fa tradi\u010dn\u00e9 \u00falo\u017en\u00e9 pooly. K\u00fdm hybridn\u00e9 syst\u00e9my Unity XT podporuj\u00fa len tradi\u010dn\u00e9 pooly, rie\u0161enia Unity XT All-Flash pon\u00fakaj\u00fa aj dynamick\u00e9 \u00falo\u017en\u00e9 pooly. V pr\u00edpade dynamick\u00fdch \u00falo\u017en\u00fdch poolov sa ochrana RAID aplikuje na extenty diskov \u2013 jednotky \u00falo\u017en\u00e9ho priestoru men\u0161ie ako cel\u00fd disk. Dynamick\u00e9 \u00falo\u017en\u00e9 pooly poskytuj\u00fa v\u00e4\u010d\u0161iu flexibilitu v spr\u00e1ve a roz\u0161irovan\u00ed diskov\u00fdch poolov.\u00a0<\/p>\n<p>Dell EMC poskytuje odpor\u00fa\u010dania na spr\u00e1vu \u00falo\u017en\u00fdch poolov pre dosiahnutie maxim\u00e1lneho v\u00fdkonu pri minim\u00e1lnej zlo\u017eitosti. Napr\u00edklad sa odpor\u00fa\u010da minimalizova\u0165 po\u010det \u00falo\u017en\u00fdch poolov Unity XT, aby sa zn\u00ed\u017eila zlo\u017eitos\u0165 a zv\u00fd\u0161ila flexibilita. Av\u0161ak nastavenie dodato\u010dn\u00fdch \u00falo\u017en\u00fdch poolov m\u00f4\u017ee by\u0165 ve\u013emi rozumn\u00e9 v niektor\u00fdch pr\u00edpadoch, vr\u00e1tane situ\u00e1ci\u00ed, ke\u010f potrebujete:<\/p>\n<ul>\n<li>Podporova\u0165 samostatn\u00e9 pracovn\u00e9 za\u0165a\u017eenia s r\u00f4znymi profilmi vstupu\/v\u00fdstupu.<\/li>\n<li>Vyhradi\u0165 zdroje na dosiahnutie konkr\u00e9tnych parametrov v\u00fdkonu.<\/li>\n<li>Vyhradi\u0165 samostatn\u00e9 zdroje pre viacn\u00e1sobnos\u0165.<\/li>\n<li>Vytv\u00e1ra\u0165 men\u0161ie dom\u00e9ny na ochranu proti zlyhaniu<\/li>\n<\/ul>\n<p><\/p>\n<h2>\u00dalo\u017en\u00e9 objemy (LUN)<\/h2>\n<p>\nAko n\u00e1js\u0165 rovnov\u00e1hu medzi spravovan\u00edm a flexibilitou pri v\u00fdbere po\u010dtu zv\u00e4zkov v poli? Pre maxim\u00e1lnu flexibilitu v Unity so SQL Serverom sa odpor\u00fa\u010da vytvori\u0165 zv\u00e4zky pre ka\u017ed\u00fd s\u00fabor datab\u00e1zy. V praxi v\u00e4\u010d\u0161ina organiz\u00e1ci\u00ed pou\u017e\u00edva viac\u00farov\u0148ov\u00fd pr\u00edstup, kde kriticky d\u00f4le\u017eit\u00e9 datab\u00e1zy dosahuj\u00fa maxim\u00e1lnu flexibilitu a s\u00fabory menej d\u00f4le\u017eit\u00fdch datab\u00e1z s\u00fa zoskupen\u00e9 na men\u0161om po\u010dte ve\u013ek\u00fdch zv\u00e4zkov. Odpor\u00fa\u010dame d\u00f4kladne presk\u00fama\u0165 v\u0161etky po\u017eiadavky na datab\u00e1zy a ak\u00e9ko\u013evek s\u00favisiace aplik\u00e1cie, preto\u017ee technol\u00f3gie ochrany d\u00e1t a sledovania z\u00e1visia od izol\u00e1cie a umiestnenia s\u00faborov.<\/p>\n<p>S mno\u017estvom zv\u00e4zkov sa \u010dasto \u0165a\u017eko manipuluje, najm\u00e4 vo virtu\u00e1lnych prostrediach. Virtualizovan\u00e9 prostredia SQL Server s\u00fa dobr\u00fdm pr\u00edkladom, kedy m\u00e1 zmysel umiestni\u0165 nieko\u013eko typov s\u00faborov na jeden zv\u00e4zok. Spr\u00e1vca datab\u00e1zy alebo spr\u00e1vca \u00falo\u017eiska (alebo obaja) by mali pri ur\u010den\u00ed po\u010dtu vytvoren\u00fdch zv\u00e4zkov n\u00e1js\u0165 spr\u00e1vnu rovnov\u00e1hu medzi flexibilitou a jednoduchou \u00fadr\u017ebou.<\/p>\n<h2>S\u00faborov\u00e9 \u00falo\u017eisko<\/h2>\n<p>\nServery NAS ukladaj\u00fa s\u00faborov\u00e9 syst\u00e9my na \u00falo\u017enom syst\u00e9me Unity XT. K s\u00faborov\u00fdm syst\u00e9mom je mo\u017en\u00e9 pristupova\u0165 prostredn\u00edctvom protokolov SMB alebo NFS a v\u010faka viacprotokolov\u00e9mu s\u00faborov\u00e9mu syst\u00e9mu je mo\u017en\u00e9 vyu\u017e\u00edva\u0165 oba protokoly s\u00fa\u010dasne. Na pripojenie hostite\u013ea k s\u00faborov\u00fdm syst\u00e9mom SMB, NFS a viacprotokolov\u00fdm syst\u00e9mom, ako aj k \u00falo\u017eisk\u00e1m d\u00e1t VMware NFS a virtu\u00e1lnym zv\u00e4zkom VMware, servery NAS pou\u017e\u00edvaj\u00fa virtu\u00e1lne rozhrania. S\u00faborov\u00e9 syst\u00e9my a virtu\u00e1lne rozhrania s\u00fa v r\u00e1mci jedn\u00e9ho servera NAS izolovan\u00e9, \u010do umo\u017e\u0148uje vyu\u017e\u00edva\u0165 viacer\u00e9 servery NAS pre viacodberate\u013enos\u0165. Servery NAS sa automaticky prep\u00ednaj\u00fa pri zlyhan\u00ed, ak zlyh\u00e1 procesor \u00falo\u017eiska. S nimi spojen\u00e9 s\u00faborov\u00e9 syst\u00e9my sa tie\u017e prep\u00ednaj\u00fa pri zlyhan\u00ed.<\/p>\n<p>SQL Server 2012 (11.x) a nov\u0161ie verzie podporuj\u00fa protokol Server Message Block (SMB) 3.0, ktor\u00fd umo\u017e\u0148uje zdie\u013eanie sie\u0165ovej jednotky na ukladanie. \u010ci u\u017e ide o offline in\u0161tal\u00e1ciu alebo o clustery s vysokou dostupnos\u0165ou, m\u00f4\u017eete nain\u0161talova\u0165 syst\u00e9mov\u00e9 datab\u00e1zy (master, model, msdb a tempdb) a pou\u017e\u00edvate\u013esk\u00e9 datab\u00e1zy Database Engine s mo\u017enos\u0165ou ukladania SMB. Pou\u017eitie \u00falo\u017eiska SMB je dobrou vo\u013ebou pri vyu\u017e\u00edvan\u00ed vysokodostupnostn\u00fdch skup\u00edn Always On Availability Groups, preto\u017ee komunitn\u00fd s\u00faborov\u00fd zdroj vy\u017eaduje pr\u00edstup k vysoko dostupn\u00e9mu sie\u0165ov\u00e9mu zdroju.<\/p>\n<p>Vytvorenie zdie\u013ean\u00fdch s\u00faborov\u00fdch zdrojov SMB pre nasadenie SQL Serveru s \u00falo\u017eiskom Unity XT je jednoduch\u00fd trojkro\u010dn\u00fd proces: je potrebn\u00e9 vytvori\u0165 server NAS, s\u00faborov\u00fd syst\u00e9m a zdie\u013ean\u00fd zdroj SMB. Softv\u00e9r Dell EMC Unisphere Storage Management zah\u0155\u0148a n\u00e1stroj na nastavenie, ktor\u00fd pom\u00f4\u017ee tento proces uskuto\u010dni\u0165. Pri umiestnen\u00ed pracovn\u00fdch z\u00e1\u0165a\u017e\u00ed SQL Serveru na zdie\u013ean\u00fdch s\u00faborov\u00fdch zdrojoch SMB by ste v\u0161ak nemali zabudn\u00fa\u0165 na niektor\u00e9 d\u00f4le\u017eit\u00e9 \u00favahy, ktor\u00e9 sa nemusia nutne t\u00fdka\u0165 pou\u017e\u00edvania zdie\u013ean\u00fdch s\u00faborov\u00fdch zdrojov SMB. Microsoft vytvoril zoznam ot\u00e1zok in\u0161tal\u00e1cie a zabezpe\u010denia spolu s aktu\u00e1lne zn\u00e1mych probl\u00e9mov; detaily n\u00e1jdete v \u010dasti \u201eIn\u0161tal\u00e1cia SQL Servera s \u00falo\u017eiskom s\u00faborov SMB\u201c v <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\">dokumentoch Microsoft<\/a><\/noindex>.<\/p>\n<h2>Snapshoty d\u00e1t<\/h2>\n<p>\nD\u00e1ta sa stali najd\u00f4le\u017eitej\u0161\u00edm zdrojom spolo\u010dnost\u00ed a dnes kritick\u00e9 prostredia vy\u017eaduj\u00fa nielen z\u00e1lohovanie. Aplik\u00e1cie musia by\u0165 v\u017edy online a zabezpe\u010den\u00e9 bez preru\u0161enia oper\u00e1ci\u00ed a aktualiz\u00e1ci\u00ed. Tie\u017e vy\u017eaduj\u00fa vysok\u00fd v\u00fdkon a dostupnos\u0165 d\u00e1t prostredn\u00edctvom tak\u00fdch mo\u017enost\u00ed ako lok\u00e1lna replik\u00e1cia snapshotov a vzdialen\u00e1 replik\u00e1cia.<\/p>\n<p>\u00dalo\u017eisko Unity XT pon\u00faka mo\u017enosti vytv\u00e1rania snapshotov pre bloky a s\u00fabory, pri\u010dom pou\u017e\u00edvaj\u00fa spolo\u010dn\u00e9 pracovn\u00e9 toky, oper\u00e1cie a architekt\u00faru. Metodol\u00f3giou snapshotov Unity sa zabezpe\u010duje jednoduch\u00fd a efekt\u00edvny sp\u00f4sob ochrany d\u00e1t. Snapshoty u\u013eah\u010duj\u00fa obnovenie d\u00e1t \u2014 m\u00f4\u017eete sa vr\u00e1ti\u0165 k star\u0161iemu snapshotu, alebo m\u00f4\u017eete skop\u00edrova\u0165 vybran\u00e9 d\u00e1ta z predch\u00e1dzaj\u00faceho snapshotu. V nasleduj\u00facej tabu\u013eke s\u00fa uveden\u00e9 doby uchov\u00e1vania snapshotov pre syst\u00e9my Unity XT.<\/p>\n<h2>Lok\u00e1lne a vzdialen\u00e9 ukladanie snapshotov d\u00e1t<\/h2>\n<p><\/p>\n<p>Typ snapshotu<\/p>\n<p>CLI<br \/>\nUI<br \/>\nREST<\/p>\n<p>Ru\u010dne\u00a0<\/p>\n<p>Pod\u013ea pl\u00e1nu\u00a0<\/p>\n<p>Ru\u010dne\u00a0<\/p>\n<p>Pod\u013ea pl\u00e1nu\u00a0<\/p>\n<p>Ru\u010dne\u00a0<\/p>\n<p>Pod\u013ea pl\u00e1nu\u00a0<\/p>\n<p>Lok\u00e1lny\u00a0<\/p>\n<p>1 rok\u00a0<\/p>\n<p>1 rok<\/p>\n<p>5 rokov\u00a0<\/p>\n<p>4 t\u00fd\u017edne<\/p>\n<p>100 rokov<\/p>\n<p>Bez obmedzen\u00ed<\/p>\n<p>Dia\u013ekov\u00fd\u00a0<\/p>\n<p>5 rokov<\/p>\n<p>255 t\u00fd\u017ed\u0148ov\u00a0<\/p>\n<p>5 rokov<\/p>\n<p>255 t\u00fd\u017ed\u0148ov<\/p>\n<p>5 rokov<\/p>\n<p>255 t\u00fd\u017ed\u0148ov<\/p>\n<p>Snapshots nie s\u00fa priamou n\u00e1hradou in\u00fdch met\u00f3d ochrany \u00fadajov, ako je z\u00e1lohovanie. M\u00f4\u017eu len doplni\u0165 tradi\u010dn\u00e9 z\u00e1lohovanie ako prv\u00fa l\u00ednia obrany pre scen\u00e1re s n\u00edzkym RTO.<\/p>\n<p>Funkcia okam\u017eit\u00fdch snapshotov Dell EMC Unity zah\u0155\u0148a zmen\u0161ovanie objemu d\u00e1t a pokro\u010dil\u00fa deduplik\u00e1ciu. Sn\u00edmky tie\u017e profituj\u00fa z \u00faspory priestoru, ktor\u00e1 sa dosahuje na p\u00f4vodnom \u00falo\u017enom zdroji. Ke\u010f vytvor\u00edte sn\u00edmku zdroja \u00falo\u017eiska s podporou funkci\u00ed zmen\u0161ovania objemu d\u00e1t, \u00fadaje v zdroji m\u00f4\u017eu by\u0165 komprimovan\u00e9 alebo deduplikovan\u00e9.<\/p>\n<p>Uve\u010fme nieko\u013eko pozn\u00e1mok t\u00fdkaj\u00facich sa obnovy datab\u00e1zy pri pou\u017eit\u00ed snapshotov s datab\u00e1zami SQL Server:<\/p>\n<ul>\n<li>V\u0161etky komponenty datab\u00e1zy SQL Server musia by\u0165 chr\u00e1nen\u00e9 ako s\u00fabor \u00fadajov. Ke\u010f s\u00fa s\u00fabory d\u00e1t a denn\u00edkov na r\u00f4znych LUN, tieto LUN musia by\u0165 s\u00fa\u010das\u0165ou konzistentnej skupiny. Konzistentn\u00e1 skupina zaru\u010duje, \u017ee sn\u00edmka bude vykonan\u00e1 s\u00fa\u010dasne na v\u0161etk\u00fdch LUN v skupine. Ke\u010f s\u00fa s\u00fabory d\u00e1t a denn\u00edkov na nieko\u013ek\u00fdch zdie\u013ean\u00fdch s\u00faborov\u00fdch prostriedkoch SMB, zdie\u013ean\u00e9 prostriedky musia by\u0165 v jednej s\u00faborovej s\u00fastave.<\/li>\n<li>Pri obnove datab\u00e1zy SQL Server zo snapshotu na z\u00e1klade blokov, ak mus\u00ed by\u0165 in\u0161tancia SQL Server pripojen\u00e1, pou\u017eite pripojenie k hostite\u013eovi Unisphere. Pre obnovu na z\u00e1klade s\u00faborov sa vytvor\u00ed \u010fal\u0161\u00ed zdie\u013ean\u00fd prostriedok SMB s pou\u017eit\u00edm sn\u00edmky ako zdroja. Po pripojen\u00ed objemov datab\u00e1zy m\u00f4\u017eete pripoji\u0165 pod in\u00fdm n\u00e1zvom alebo nahradi\u0165 existuj\u00facu datab\u00e1zu obnovenou.<\/li>\n<\/ul>\n<p><\/p>\n<ul>\n<li>Pri vykon\u00e1van\u00ed obnovy pomocou met\u00f3dy obnovy snapshotov Snapshot Restore v Unisphere nastavte in\u0161tanciu SQL Server do offline re\u017eimu. SQL Server nevie o oper\u00e1ci\u00e1ch obnovy. Prevod in\u0161tancie do offline re\u017eimu zaru\u010duje, \u017ee objemy nebud\u00fa po\u0161koden\u00e9 pri oper\u00e1ci\u00e1ch z\u00e1pisu do datab\u00e1zy pred obnovou. Akon\u00e1hle bude in\u0161tancia re\u0161tartovan\u00e1, havarijn\u00e1 obnova SQL Server privedie datab\u00e1zy do konzistentn\u00e9ho stavu.<\/li>\n<li>Povo\u013ete okam\u017eit\u00e9 sn\u00edmky pre viac \u00falo\u017en\u00fdch objektov s\u00fa\u010dasne a potom pred zapnut\u00edm \u010fal\u0161\u00edch sn\u00edmok sa uistite, \u017ee syst\u00e9m je v odpor\u00fa\u010dan\u00fdch pracovn\u00fdch re\u017eimoch po\u010das monitorovania.<\/li>\n<\/ul>\n<p><\/p>\n<h2>Automatiz\u00e1cia a pl\u00e1novanie sn\u00edmok<\/h2>\n<p>\nOkam\u017eit\u00e9 sn\u00edmky v Unity XT je mo\u017en\u00e9 automatizova\u0165. V syst\u00e9me spr\u00e1vy \u00falo\u017eiska Unisphere s\u00fa k dispoz\u00edcii nasleduj\u00face predvolen\u00e9 mo\u017enosti sn\u00edmok: predvolen\u00e1 ochrana, ochrana s krat\u0161\u00edm \u010dasom uchovania a ochrana s dlh\u0161\u00edm \u010dasom uchovania. Ka\u017ed\u00e1 mo\u017enos\u0165 vytv\u00e1ra denn\u00e9 sn\u00edmky a uchov\u00e1va ich po\u010das r\u00f4znych \u010dasov\u00fdch obdob\u00ed.<\/p>\n<p>M\u00f4\u017eete si vybra\u0165 jednu (alebo obe) z mo\u017enost\u00ed pl\u00e1novania \u2014 ka\u017ed\u00fdch x hod\u00edn (od 1 do 24) a denne \/ t\u00fd\u017edenne. Denn\u00e9 \/ t\u00fd\u017edenn\u00e9 pl\u00e1novanie okam\u017eit\u00fdch sn\u00edmok umo\u017e\u0148uje ur\u010di\u0165 konkr\u00e9tny \u010das a dni na vytv\u00e1ranie sn\u00edmok. Pre ka\u017ed\u00fa vybran\u00fa mo\u017enos\u0165 je potrebn\u00e9 nastavi\u0165 politiku uchovania, ktor\u00e1 m\u00f4\u017ee by\u0165 nastaven\u00e1 na automatick\u00e9 odstr\u00e1nenie z\u00e1sobn\u00edka alebo do\u010dasn\u00e9 uchovanie.<\/p>\n<p>\u010eal\u0161ie inform\u00e1cie o sn\u00edmkach Unity s\u00fa v <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\">dokument\u00e1cii Dell EMC Unity<\/a><\/noindex>.\u00a0<\/p>\n<h2>Tenk\u00e9 klony<\/h2>\n<p>\nTenk\u00fd klon je dostupn\u00e1 na \u010d\u00edtanie\/z\u00e1pis k\u00f3pia tenk\u00e9ho blokov\u00e9ho \u00falo\u017en\u00e9ho zdroja, ako je zv\u00e4zok, konzistentn\u00e1 skupina alebo \u00falo\u017eisko d\u00e1t VMware VMFS, ktor\u00e1 zdie\u013ea bloky s rodi\u010dovsk\u00fdm zdrojom. Tenk\u00e9 klony s\u00fa skvel\u00fdm sp\u00f4sobom, ako r\u00fdchlo a kompaktn\u00e9 prezentova\u0165 k\u00f3pie datab\u00e1zy SQL Server, \u010do nemo\u017eno dosiahnu\u0165 pomocou tradi\u010dn\u00fdch n\u00e1strojov SQL Server. Po tom, ako je tenk\u00fd klon prezentovan\u00fd hostite\u013eovi, m\u00f4\u017eu by\u0165 zv\u00e4zky uveden\u00e9 do prev\u00e1dzkov\u00e9ho re\u017eimu (online) a datab\u00e1za bude pripojen\u00e1 pomocou met\u00f3dy pripojenia DB v SQL Server.<\/p>\n<p>Pri pou\u017e\u00edvan\u00ed funkcie aktualiz\u00e1cie s tenk\u00fdmi klonmi vypnite (preve\u010fte do offline re\u017eimu) v\u0161etky datab\u00e1zy, ktor\u00e9 sa nach\u00e1dzaj\u00fa na tenkom clone. Mus\u00edte tak urobi\u0165 pred opera\u010dnou aktualiz\u00e1ciou. Ak datab\u00e1zy neprevediete do offline re\u017eimu pred vykonan\u00edm aktualiz\u00e1cie, m\u00f4\u017ee to vies\u0165 k chyb\u00e1m nezrovnalosti \u00fadajov alebo nespr\u00e1vnym v\u00fdsledkom \u00fadajov v SQL Server.<\/p>\n<h2>Replik\u00e1cia \u00fadajov<\/h2>\n<p>\nReplik\u00e1cia je softv\u00e9rov\u00e1 funkcia, ktor\u00e1 synchronizuje \u00fadaje s vzdialen\u00fdm syst\u00e9mom na tom istom objekte alebo na inom mieste. Parametre replik\u00e1cie a konfigur\u00e1cie Unity umo\u017e\u0148uj\u00fa zvoli\u0165 efekt\u00edvny sp\u00f4sob splnenia po\u017eiadaviek RTO\/RPO pre datab\u00e1zy SQL Server, pri\u010dom sa zachov\u00e1va rovnov\u00e1ha medzi v\u00fdkonom a priepustnos\u0165ou.<\/p>\n<p>Pri pou\u017eit\u00ed replik\u00e1cie Dell EMC Unity na ochranu datab\u00e1z SQL Server na viacer\u00fdch zv\u00e4zkoch by sa v\u0161etky \u00fadaje a zv\u00e4zky \u017eurn\u00e1lov datab\u00e1zy mali obmedzi\u0165 na jednu konzistentn\u00fa skupinu alebo s\u00faborov\u00fd syst\u00e9m. N\u00e1sledne sa replik\u00e1cia nastav\u00ed v skupine alebo s\u00faborovom syst\u00e9me a m\u00f4\u017ee zah\u0155\u0148a\u0165 zv\u00e4zky alebo zdie\u013ean\u00e9 prostriedky viacer\u00fdch datab\u00e1z. Datab\u00e1zy, pre ktor\u00e9 s\u00fa potrebn\u00e9 r\u00f4zne parametre replik\u00e1cie, musia by\u0165 umiestnen\u00e9 v samostatn\u00fdch LUN, konzistentn\u00fdch skupin\u00e1ch alebo s\u00faborov\u00fdch syst\u00e9moch.<\/p>\n<p>Tenk\u00e9 klony s\u00fa kompatibiln\u00e9 ako so synchronnou, tak aj s asynchr\u00f3nnou replik\u00e1ciou. Ke\u010f je tenk\u00fd klon replikovan\u00fd na miesto ur\u010denia, st\u00e1va sa \u00faplnou k\u00f3piou zv\u00e4zku, konzistentnej skupiny alebo \u00falo\u017eiska VMFS. Po replik\u00e1cii je tenk\u00fd klon \u00faplne nez\u00e1visl\u00fdm zv\u00e4zkom s vlastn\u00fdmi nastaveniami. <\/p>\n<p><img decoding=\"async\" alt=\"Microsoft SQL Server 2019 a flashov\u00e9 pole Dell EMC Unity XT\" src=\"\/wp-content\/uploads\/2019\/12\/58d0ecdba09abdd75de974e87d84188c.jpg\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<i>Proces replik\u00e1cie tenk\u00e9ho klonu medzi p\u00f4vodn\u00fdm a cie\u013eov\u00fdm syst\u00e9mom.<\/i><\/p>\n<p>Replik\u00e1cia datab\u00e1zy tempdb nie je potrebn\u00e1, preto\u017ee s\u00fabor sa prestavuje pri re\u0161tarte SQL Servera, a preto metad\u00e1ta nezodpovedaj\u00fa met\u00f3de in\u00fdch in\u0161tanci\u00ed SQL Servera. D\u00f4kladn\u00fd v\u00fdber zv\u00e4zkov na replik\u00e1ciu a obsahu t\u00fdchto zv\u00e4zkov odstra\u0148uje zbyto\u010dn\u00fd prev\u00e1dzkov\u00fd tok replik\u00e1cie.<\/p>\n<h2>Integrovan\u00e1 spr\u00e1va kop\u00edrovania \u00fadajov Microsoft SQL Server<\/h2>\n<p>\nV\u00e4\u010d\u0161ina modern\u00fdch \u00falo\u017en\u00fdch produktov (vr\u00e1tane v\u0161etk\u00fdch produktov Dell EMC) m\u00f4\u017ee vytv\u00e1ra\u0165 \u201es\u00fahlasn\u00e9 s opera\u010dn\u00fdm syst\u00e9mom\u201c k\u00f3pie s\u00faborov ak\u00e9hoko\u013evek typu prostredn\u00edctvom:<\/p>\n<ul>\n<li>S\u00fahlasn\u00e9ho poradia z\u00e1pisu opera\u010dn\u00fdm syst\u00e9mom na v\u0161etk\u00fdch \u00farovniach \u2014 od hostite\u013ea po ulo\u017eenie.<\/li>\n<li>Zgrupovania zv\u00e4zkov, aby sa pre nieko\u013eko s\u00faborov na r\u00f4znych zv\u00e4zkoch zachoval poriadok z\u00e1pisu.<\/li>\n<\/ul>\n<p>\nS roz\u0161\u00edren\u00edm \u0161k\u00e1lovate\u013en\u00fdch \u00falo\u017en\u00fdch zariaden\u00ed vyvinula spolo\u010dnos\u0165 Microsoft API pre dod\u00e1vate\u013eov \u00falo\u017en\u00fdch syst\u00e9mov. Toto API umo\u017e\u0148uje dod\u00e1vate\u013eom \u00falo\u017e\u00edsk koordinova\u0165 svoje akcie s programom datab\u00e1z SQL Server na vytv\u00e1ranie \"k\u00f3pi\u00ed zladen\u00fdch s aplik\u00e1ciou\" pomocou slu\u017eby na tie\u0148ovanie objemov (VSS). Tieto k\u00f3pie napodob\u0148uj\u00fa interakciu SQL Servera a opera\u010dn\u00e9ho syst\u00e9mu po\u010das pl\u00e1novanej a dokon\u010dovacej \u010dinnosti SQL Servera. V\u0161etky z\u00e1pisov\u00e9 vyrovn\u00e1vacie pam\u00e4te s\u00fa vy\u010disten\u00e9 a transakcie s\u00fa pozastaven\u00e9, k\u00fdm nie s\u00fa v\u0161etky disky aktualizovan\u00e9 a zladen\u00e9 na konkr\u00e9tny \u010dasov\u00fd okamih, ktor\u00fd je zaznamenan\u00fd v denn\u00edku SQL.<\/p>\n<p>Softv\u00e9r Dell EMC AppSync, integrovan\u00fd so sn\u00edmkami Unity XT, zjednodu\u0161uje a automatizuje proces vytv\u00e1rania, pou\u017e\u00edvania a spr\u00e1vy k\u00f3pi\u00ed pracovn\u00fdch \u00fadajov zladen\u00fdch s aplik\u00e1ciou. Tento softv\u00e9r je ur\u010den\u00fd na pou\u017eitie v scen\u00e1roch spr\u00e1vy k\u00f3pi\u00ed na obnovenie datab\u00e1z a ich op\u00e4tovn\u00e9 pou\u017eitie.\u00a0<\/p>\n<p>Softv\u00e9r AppSync automaticky zis\u0165uje datab\u00e1zy aplik\u00e1ci\u00ed, sk\u00fama \u0161trukt\u00faru datab\u00e1z a zobrazuje s\u00faborov\u00fa \u0161trukt\u00faru cez \u00farovne hardv\u00e9ru alebo virtualiz\u00e1cie na z\u00e1kladn\u00e9 \u00falo\u017eisko Unity XT. Organizuje v\u0161etky potrebn\u00e9 \u010dinnosti, od vytv\u00e1rania a overovania k\u00f3pie po montovanie okam\u017eit\u00fdch sn\u00edmkov na cie\u013eovom hostite\u013eovi a spustenie alebo obnovenie datab\u00e1zy. AppSync podporuje a zjednodu\u0161uje pracovn\u00e9 toky SQL Servera, ktor\u00e9 zah\u0155\u0148aj\u00fa aktualiz\u00e1ciu a obnovenie pracovnej datab\u00e1zy.<\/p>\n<h2>Zn\u00ed\u017eenie objemu d\u00e1t a pokro\u010dil\u00e1 deduplik\u00e1cia<\/h2>\n<p>\nRodina syst\u00e9mov \u00falo\u017en\u00fdch d\u00e1t Dell EMC Unity pon\u00faka multifunk\u010dn\u00e9 a jednoduch\u00e9 slu\u017eby na zni\u017eovanie objemu d\u00e1t. \u00daspory s\u00fa dosahovan\u00e9 nielen na nastaven\u00fdch prim\u00e1rnych zdrojoch \u00falo\u017eiska, ale aj na sn\u00edmkach a tenk\u00fdch klonoch t\u00fdchto zdrojov. Okam\u017eit\u00e9 sn\u00edmky a tenk\u00e9 klony dedi\u010dia nastavenie zni\u017eovania objemu d\u00e1t p\u00f4vodn\u00e9ho \u00falo\u017eiska, \u010do zvy\u0161uje \u00fasporu kapacity.<\/p>\n<p>Funkcia zmen\u0161ovania objemu d\u00e1t zah\u0155\u0148a \u010dinnosti de-duplik\u00e1cie, kompresie a detekcie pr\u00e1zdnych blokov, \u010do potenci\u00e1lne zvy\u0161uje objem dostupn\u00e9ho \u00falo\u017en\u00e9ho priestoru pre pou\u017e\u00edvate\u013esk\u00e9 objekty a intern\u00e9 pou\u017eitie. Funkcia zmen\u0161ovania objemu d\u00e1t Unity XT nahr\u00e1dza funkciu kompresie v Unity OE 4.3 a nov\u0161\u00edch verzi\u00e1ch. Kompresia je algoritmus zmen\u0161ovania d\u00e1t, ktor\u00fd m\u00f4\u017ee zmen\u0161i\u0165 fyzick\u00e9 rozdelenie kapacity potrebnej na ulo\u017eenie s\u00faboru d\u00e1t.<\/p>\n<p>Syst\u00e9my Unity XT tie\u017e poskytuj\u00fa roz\u0161\u00edren\u00fa funkciu de-duplik\u00e1cie, ktor\u00fa je mo\u017en\u00e9 aktivova\u0165, ak je zapnut\u00e9 zmen\u0161ovanie objemu d\u00e1t. Roz\u0161\u00edren\u00e1 de-duplik\u00e1cia zmen\u0161uje potrebn\u00fa kapacitu pre pou\u017e\u00edvate\u013esk\u00e9 d\u00e1ta a uchov\u00e1va len mal\u00e9 mno\u017estvo k\u00f3pi\u00ed (\u010dasto len jednu k\u00f3piu) blokov d\u00e1t Unity. Oblas\u0165 de-duplik\u00e1cie je jeden LUN. Zoh\u013eadnite to pri v\u00fdbere sch\u00e9my ukladania. Menej LUN vedie k lep\u0161ej de-duplik\u00e1cii, ale viac LUN zabezpe\u010duje vy\u0161\u0161\u00ed v\u00fdkon.\u00a0<\/p>\n<p>\u00daspora kapacity v\u010faka roz\u0161\u00edrenej de-duplik\u00e1cii m\u00f4\u017ee prinies\u0165 najv\u00e4\u010d\u0161\u00ed \u00fa\u017eitok v v\u00e4\u010d\u0161ine prostred\u00ed, ale tie\u017e si vy\u017eaduje vyu\u017e\u00edvanie procesorov\u00fdch zdrojov syst\u00e9mu Unity. V OE 5.0, ak je povolen\u00e1, roz\u0161\u00edren\u00e1 de-duplik\u00e1cia de-duplikuje ak\u00fdko\u013evek blok (komprimovan\u00fd alebo nekomprimovan\u00fd). \u010eal\u0161ie inform\u00e1cie n\u00e1jdete v <noindex><a rel=\"nofollow\" href=\"https:\/\/www.emc.com\/collateral\/white-papers\/h15571-dell-emc-unity-compression.pdf\">dokument\u00e1cii Dell EMC<\/a><\/noindex>.<\/p>\n<p>V nasleduj\u00facej tabu\u013eke s\u00fa uveden\u00e9 podporovan\u00e9 konfigur\u00e1cie pre zmen\u0161ovanie objemu d\u00e1t a roz\u0161\u00edren\u00fa de-duplik\u00e1ciu:<\/p>\n<h2>Zmen\u0161ovanie d\u00e1t v Unity (v\u0161etky modely) a roz\u0161\u00edren\u00e1 podpora de-duplik\u00e1cie<\/h2>\n<p><\/p>\n<p>Verzia Unity OE\u00a0<\/p>\n<p>Technol\u00f3gia\u00a0<\/p>\n<p>Podporovan\u00fd typ poolu\u00a0<\/p>\n<p>Podporovan\u00e9 modely<\/p>\n<p>4.3 \/ 4.4\u00a0<\/p>\n<p>Zmen\u0161ovanie objemu d\u00e1t\u00a0<\/p>\n<p>Pool flash pam\u00e4te \u2014 tradi\u010dn\u00fd alebo dynamick\u00fd\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>Zmen\u0161ovanie objemu d\u00e1t\u00a0<\/p>\n<p>300, 400, 500, 600, 300F, 400F, 500F, 600F, 350F, 450F, 550F, 650F\u00a0<\/p>\n<p>Zmen\u0161ovanie objemu d\u00e1t a roz\u0161\u00edren\u00e1 de-duplik\u00e1cia*<\/p>\n<p>450F, 550F, 650F\u00a0<\/p>\n<p>5\u00a0<br \/>\n\u00a0<\/p>\n<p>Zmen\u0161ovanie objemu d\u00e1t\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>Zn\u00ed\u017eenie objemu d\u00e1t a pokro\u010dil\u00e1 deduplik\u00e1cia<\/p>\n<p>450F, 550F, 650F, 380, 480, 680, 880, 380F, 480F, 680F, 880F<\/p>\n<p><i> * Zmen\u0161ovanie objemu d\u00e1t je predvolene vypnut\u00e9 a mus\u00ed sa zapn\u00fa\u0165 predt\u00fdm, ako sa roz\u0161\u00edren\u00e1 de-duplik\u00e1cia stane dostupnou mo\u017enos\u0165ou. Po zapnut\u00ed zmen\u0161ovania objemu d\u00e1t je roz\u0161\u00edren\u00e1 de-duplik\u00e1cia dostupn\u00e1, ale predvolene je vypnut\u00e1.<\/i><\/p>\n<h2>Zmen\u0161ovanie objemu d\u00e1t v Unity a kompresia d\u00e1t v SQL Server<\/h2>\n<p>\nVydanie SQL Server 2008 Enterprise Edition bolo prv\u00fdm vydan\u00edm s vlastn\u00fdmi mo\u017enos\u0165ami kompresie d\u00e1t. Pri kompresii na \u00farovni riadkov a str\u00e1n SQL Server 2008 vyu\u017e\u00edva vedomosti o form\u00e1te tabu\u013eky vn\u00fatornej datab\u00e1zy SQL Server, aby zn\u00ed\u017eil priestor, ktor\u00fd objekty datab\u00e1zy zaberaj\u00fa. Zn\u00ed\u017eenie priestoru umo\u017e\u0148uje ulo\u017ei\u0165 viac riadkov na str\u00e1nke a viac str\u00e1nok v buffrovom poole. Ke\u010f\u017ee \u00fadaje, ktor\u00e9 nie s\u00fa ulo\u017een\u00e9 vo form\u00e1te 8k d\u00e1tovej str\u00e1nky, ako napr\u00edklad \u00fadaje mimo riadkov, ako NVARCHAR (MAX), nebud\u00fa pou\u017e\u00edva\u0165 met\u00f3dy kompresie riadkov alebo str\u00e1n, Microsoft predstavil funkcie Transact-SQL COMPRESS a DECOMPRESS.\u00a0<\/p>\n<p>Tieto funkcie pou\u017e\u00edvaj\u00fa tradi\u010dn\u00fd pr\u00edstup k kompresii d\u00e1t (algoritmus GZIP), ktor\u00fd je potrebn\u00e9 vyvola\u0165 pre ka\u017ed\u00fd oddiel \u00fadajov na kompresiu alebo dekompresiu.<\/p>\n<p>Kompresia Unity XT, ktor\u00e1 nie je v\u00fdlu\u010dne pre SQL Server, pou\u017e\u00edva softv\u00e9rov\u00fd algoritmus na anal\u00fdzu a kompresiu d\u00e1t S\u00daS. Od vydania Unity OE 4.1 bola kompresia d\u00e1t Unity dostupn\u00e1 pre blokov\u00e9 \u00falo\u017en\u00e9 objemy a \u00falo\u017eisk\u00e1 d\u00e1t VMFS v poole s flash pam\u00e4\u0165ou. Za\u010d\u00ednaj\u00fac s Unity OE 4.2 je kompresia tie\u017e dostupn\u00e1 pre s\u00faborov\u00e9 syst\u00e9my a \u00falo\u017eisk\u00e1 d\u00e1t NFS v \u00falo\u017en\u00fdch pooloch na flash m\u00e9diu.<\/p>\n<p>V\u00fdber met\u00f3dy kompresie d\u00e1t pre SQL Server z\u00e1vis\u00ed od nieko\u013ek\u00fdch faktorov. Tieto faktory zah\u0155\u0148aj\u00fa typ obsahu datab\u00e1zy, dostupn\u00e9 CPU zdroje \u2014 ako na \u00falo\u017eisku, tak aj na datab\u00e1zov\u00fdch serveroch, a v\u00fdkonnos\u0165 vstupov a v\u00fdstupov potrebn\u00fdch na udr\u017eanie SLA. Vo v\u0161eobecnosti sa o\u010dak\u00e1va \u010fal\u0161ie \u00faspory priestoru pre d\u00e1ta, ktor\u00e9 s\u00fa komprimovan\u00e9 pomocou SQL Server, av\u0161ak d\u00e1ta komprimovan\u00e9 pomocou funkcie kompresie TSQL s pou\u017eit\u00edm algoritmu GZIP pravdepodobne nez\u00edskaj\u00fa v\u00fdznamn\u00e9 dodato\u010dn\u00e9 zn\u00ed\u017eenie objemu od funkci\u00ed kompresie Unity XT, preto\u017ee v\u00e4\u010d\u0161ina v\u00fdhod sa dosahuje flexibiln\u00fdm glob\u00e1lnym algoritmom pou\u017eit\u00fdm ako prv\u00fdm.<\/p>\n<p>Kompresia Unity zabezpe\u010duje \u00fasporu priestoru, ak sa \u00fadaje na \u00falo\u017enom objekte komprimuj\u00fa aspo\u0148 o 25%. Pred aktivovan\u00edm kompresie pre \u00falo\u017en\u00fd objekt ur\u010dte, \u010di obsahuje \u00fadaje, ktor\u00e9 je mo\u017en\u00e9 komprimova\u0165. Neaktivujte kompresiu pre \u00falo\u017en\u00fd objekt, ak to neprinesie \u00faspory kapacity.\u00a0<\/p>\n<p>Pri rozhodovan\u00ed, \u010di pou\u017ei\u0165 zn\u00ed\u017eenie objemu \u00fadajov v Unity, kompresiu na \u00farovni datab\u00e1zy SQL Server alebo oboje, zv\u00e1\u017ete nasleduj\u00face:<\/p>\n<ul>\n<li>\u00dadaje, ktor\u00e9 sa zapisuj\u00fa do syst\u00e9mu Unity, potvrdzuje hostite\u013e po ich ulo\u017een\u00ed do syst\u00e9movej cache. Proces kompresie v\u0161ak neza\u010dne, a\u017e k\u00fdm nebude cache vypr\u00e1zdnen\u00e1.<\/li>\n<\/ul>\n<p><\/p>\n<ul>\n<li>\u00daspora pri kompresii sa dosahuje nielen pre \u00falo\u017en\u00e9 prostriedky Unity XT, ale aj pre okam\u017eit\u00e9 sn\u00edmky a tenk\u00e9 k\u00f3pie prostriedku.<\/li>\n<li>V priebehu kompresie sa nieko\u013eko blokov agreguje pomocou algoritmu vzoriek, aby sa ur\u010dilo, \u010di sa \u00fadaje daj\u00fa skomprimova\u0165. Ak algoritmus vzoriek zist\u00ed, \u017ee je mo\u017en\u00e9 dosiahnu\u0165 len minim\u00e1lnu \u00fasporu, kompresia sa presko\u010d\u00ed a \u00fadaje sa zap\u00ed\u0161u do dostupn\u00e9ho priestoru.<\/li>\n<li>Ke\u010f sa \u00fadaje komprimuj\u00fa pred z\u00e1pisom na m\u00e9dium, objem oper\u00e1ci\u00ed s nimi sa v\u00fdrazne zni\u017euje. Preto kompresia pom\u00e1ha zni\u017eova\u0165 opotrebovanie flash pam\u00e4te t\u00fdm, \u017ee zni\u017euje fyzick\u00fd objem \u00fadajov zapisovan\u00fdch na \u00falo\u017eisko.<\/li>\n<\/ul>\n<p>\n\u010eal\u0161ie inform\u00e1cie o kompresii riadkov a str\u00e1nok v SQL Server pre tabu\u013eky a indexy n\u00e1jdete v <noindex><a rel=\"nofollow\" href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/data-compression\/data-compression\">dokumentoch Microsoft<\/a><\/noindex>.<\/p>\n<p>Nezab\u00fadajte, \u017ee na ak\u00fako\u013evek kompresiu s\u00fa potrebn\u00e9 procesorov\u00e9 zdroje. Pri vysok\u00fdch po\u017eiadavk\u00e1ch na priepustnos\u0165 m\u00f4\u017ee ma\u0165 kompresia v\u00fdznamn\u00fd vplyv na v\u00fdkon. Vysok\u00e9 pomery z\u00e1pisu pracovn\u00fdch z\u00e1\u0165a\u017e\u00ed OLAP tie\u017e m\u00f4\u017eu zni\u017eova\u0165 v\u00fdhody kompresie pre datab\u00e1zu SQL Server.<\/p>\n<p>Odborn\u00edci z Dell EMC presk\u00famali potenci\u00e1lnu \u00fasporu za pou\u017eitia re\u00e1lnych koeficientov zn\u00ed\u017eenia \u00fadajov v poli Unity. Skupina zhroma\u017edila \u00fadaje o virtu\u00e1lnych strojoch VMware, zdie\u013ean\u00ed s\u00faborov, datab\u00e1zach SQL Server, virtu\u00e1lnych strojoch Microsoft Hyper-V a \u010fal\u0161\u00edch.<\/p>\n<p>V\u00fdsledky \u0161t\u00fadie uk\u00e1zali, \u017ee zn\u00ed\u017eenie objemu s\u00faboru denn\u00edka SQL Server je takmer 10-n\u00e1sobne men\u0161ie ako objem \u00fadajov\u00e9ho s\u00faboru:<\/p>\n<ul>\n<li>Objem datab\u00e1zy = 1,49: 1 (32,96%)<\/li>\n<li>Objem logov = 12,9: 1 (92,25%)<\/li>\n<\/ul>\n<p>\nDatab\u00e1za SQL Server bola vybaven\u00e1 dvoma zv\u00e4zkami. S\u00fabory datab\u00e1zy s\u00fa ulo\u017een\u00e9 na jednom zv\u00e4zku a transak\u010dn\u00e9 denn\u00edky na druhom. Pou\u017eitie technol\u00f3gie zmen\u0161ovania d\u00e1t so zv\u00e4zkami datab\u00e1z m\u00f4\u017ee zabezpe\u010di\u0165 \u00fasporu \u00falo\u017en\u00e9ho priestoru; av\u0161ak je potrebn\u00e9 zv\u00e1\u017ei\u0165 vplyv na v\u00fdkon pri rozhodovan\u00ed o tom, \u010di zahrn\u00fa\u0165 deduplik\u00e1ciu na zv\u00e4zkoch datab\u00e1z. Aj ke\u010f m\u00f4\u017ee skuto\u010dn\u00e9 zmen\u0161enie objemu datab\u00e1zy kol\u00edsa\u0165 v z\u00e1vislosti od ulo\u017een\u00fdch d\u00e1t, v\u00fdsledky v\u00fdskumu uk\u00e1zali, \u017ee priestor na ukladanie transak\u010dn\u00fdch denn\u00edkov SQL Server m\u00f4\u017ee <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\">by\u0165 v\u00fdrazne zmen\u0161en\u00fd<\/a><\/noindex>.<\/p>\n<h2>Najlep\u0161ie praktiky na zmen\u0161ovanie objemu d\u00e1t<\/h2>\n<p>\nPred zapnut\u00edm zmen\u0161ovania d\u00e1t na \u00falo\u017enom objekte zv\u00e1\u017ete nasleduj\u00face odpor\u00fa\u010dania:<\/p>\n<ul>\n<li>Pou\u017eite monitoring \u00falo\u017en\u00e9ho syst\u00e9mu, aby ste sa uistili, \u017ee m\u00e1 dostupn\u00e9 zdroje na podporu zmen\u0161ovania objemu d\u00e1t.<\/li>\n<li>Povo\u013ete zmen\u0161ovanie objemu d\u00e1t pre nieko\u013eko \u00falo\u017en\u00fdch objektov s\u00fa\u010dasne. Pred jeho povolen\u00edm na \u010fal\u0161\u00edch \u00falo\u017en\u00fdch objektoch sledujte syst\u00e9m, aby ste sa uistili, \u017ee funguje v odpor\u00fa\u010dan\u00fdch pracovn\u00fdch re\u017eimoch.<\/li>\n<li>V modeloch Unity XT x80F zmen\u0161ovanie objemu d\u00e1t zabezpe\u010d\u00ed \u00fasporu kapacity, ak sa d\u00e1ta v \u00falo\u017enom bloku komprimuj\u00fa aspo\u0148 o 1%.<\/li>\n<\/ul>\n<p>\nZmen\u0161ovanie objemu d\u00e1t na predch\u00e1dzaj\u00facich modeloch Unity x80F, ktor\u00e9 pracovali pod syst\u00e9mom OE 5.0, zabezpe\u010dovalo \u00fasporu, ak boli d\u00e1ta komprimovate\u013en\u00e9 aspo\u0148 o 25%.<\/p>\n<ul>\n<li>Pred zapnut\u00edm zmen\u0161ovania objemu d\u00e1t na \u00falo\u017enom objekte ur\u010dte, \u010di objekt obsahuje komprimovate\u013en\u00e9 d\u00e1ta. Ur\u010dit\u00e9 typy d\u00e1t, ako vide\u00e1, audio, obr\u00e1zky a bin\u00e1rne d\u00e1ta, zvy\u010dajne poskytuj\u00fa mal\u00fd \u00fa\u017eitok z kompresie. Nezap\u00ednajte zmen\u0161ovanie objemu d\u00e1t na \u00falo\u017enom objekte, ak nebude \u00faspora miesta.<\/li>\n<li>Zv\u00e1\u017ete selekt\u00edvne zmen\u0161enie objemu zv\u00e4zku s\u00faborov\u00fdch d\u00e1t, ktor\u00e9 sa zvy\u010dajne dobre komprimuj\u00fa.<\/li>\n<\/ul>\n<p><\/p>\n<h2>Virtualiz\u00e1cia VMware<\/h2>\n<p>\nVMware vSphere je efekt\u00edvna a bezpe\u010dn\u00e1 platforma na virtualiz\u00e1ciu a cloudov\u00e9 prostredie. Hlavn\u00fdmi komponentmi vSphere s\u00fa VMware vCenter Server a hyperv\u00edzor VMware ESXi.<\/p>\n<p>vCenter Server \u2014 unified management platform for vSphere environments. It is characterized by ease of deployment and proactive resource optimization. ESXi is an open-source hypervisor that is installed directly on physical servers. ESXi has direct access to core resources and a small size of 150 MB, which minimizes memory requirements. It provides reliable performance for various application workloads and supports powerful virtual machine configurations \u2014 up to 128 virtual CPUs, 6 TB of RAM, and 120 devices.<\/p>\n<p>For SQL Server to function effectively on modern hardware, the SQL Server Operating System (SQLOS) must 'understand' the hardware structure. With the advent of multi-core and NUMA (Non-Uniform Memory Access) multi-node systems, understanding the relationships between cores, logical and physical processors has become especially important.<\/p>\n<h2>Procesory\u00a0<\/h2>\n<p>\nVirtual CPU (vCPU) is a virtual central processing unit assigned to a virtual machine. The total number of assigned virtual CPUs is calculated as:<\/p>\n<pre><code class=\"plaintext\">Total vCPU = (number of virtual sockets) * (number of virtual cores per socket)<\/code><\/pre>\n<p>\nIf stable performance is important, VMware recommends that the total number of virtual CPUs assigned to all virtual machines does not exceed the total number of physical cores available on the ESXi host, but the number of allocated virtual CPUs can be increased if monitoring shows that unused CPU resources are available.<\/p>\n<p>In systems with Intel Hyper-Threading enabled, the number of logical cores (vCPU) is double the number of physical cores. In this case, do not assign the total number of virtual CPUs.<\/p>\n<p>For lower-level SQL Server workloads, variability in latency has less impact. Thus, these workloads can run on hosts with a higher ratio of virtual CPUs to physical ones. Reasonable CPU load levels can increase the overall system throughput, maximize license savings, and maintain adequate performance.<\/p>\n<p>Intel Hyper-Threading zvy\u010dajne zvy\u0161uje celkov\u00fa priepustnos\u0165 hostite\u013ea o 10\u201330%, \u010do nazna\u010duje pomer virtu\u00e1lnych CPU k fyzick\u00fdm procesorom od 1,1 do 1,3. VMware odpor\u00fa\u010da aktivova\u0165 Hyper-Threading v BIOS-e UEFI, ke\u010f je to mo\u017en\u00e9, aby ESXi mohol vyu\u017ei\u0165 v\u00fdhody tejto technol\u00f3gie. Taktie\u017e VMware odpor\u00fa\u010da vykona\u0165 d\u00f4kladn\u00e9 testovanie a monitorovanie pri pou\u017eit\u00ed Hyper-Threading pre pracovn\u00e9 za\u0165a\u017eenia SQL Server.<\/p>\n<h2>Pam\u00e4\u0165<\/h2>\n<p>\nTakmer v\u0161etky modern\u00e9 servery pou\u017e\u00edvaj\u00fa na spojenie medzi hlavnou pam\u00e4\u0165ou a procesormi architekt\u00faru s nehomog\u00e9nnym pr\u00edstupom k pam\u00e4ti (NUMA). NUMA je hardv\u00e9rov\u00e1 architekt\u00fara pre zdie\u013ean\u00fa pam\u00e4\u0165, ktor\u00e1 implementuje rozdelenie blokov fyzickej pam\u00e4ti medzi fyzick\u00fdmi procesormi. Uzol NUMA je jeden alebo viac soketov CPU spolu s blokom vyhradenej pam\u00e4te.\u00a0<\/p>\n<p>V priebehu posledn\u00e9ho desa\u0165ro\u010dia bola NUMA \u0161iroko diskutovanou t\u00e9mou. Relat\u00edvna zlo\u017eitos\u0165 NUMA je sp\u00f4soben\u00e1 predov\u0161etk\u00fdm implement\u00e1ciami od r\u00f4znych dod\u00e1vate\u013eov. V virtualizovan\u00fdch prostrediach je zlo\u017eitost NUMA tie\u017e definovan\u00e1 po\u010dtom konfigura\u010dn\u00fdch parametrov a \u00farovn\u00ed \u2014 od hardv\u00e9ru cez hyperv\u00edzor po hos\u0165uj\u00faci opera\u010dn\u00fd syst\u00e9m a napokon po aplik\u00e1ciu SQL Server. Dobr\u00e9 pochopenie hardv\u00e9rovej architekt\u00fary NUMA je povinnou po\u017eiadavkou pre ka\u017ed\u00e9ho spr\u00e1vcu datab\u00e1z SQL Server, ktor\u00fd pracuje s virtualizovanou in\u0161tanciou SQL Server.<\/p>\n<p>Na dosiahnutie v\u00e4\u010d\u0161ej efektivity na serveroch s ve\u013ek\u00fdm po\u010dtom jadier Microsoft predstavil SoftNUMA. SoftNUMA umo\u017e\u0148uje rozdeli\u0165 dostupn\u00e9 zdroje CPU v r\u00e1mci jednej NUMA na nieko\u013eko uzlov SoftNUMA. Pod\u013ea VMware je SoftNUMA kompatibiln\u00e1 s topol\u00f3giou virtu\u00e1lnej NUMA (vNUMA) VMware a m\u00f4\u017ee \u010falej optimalizova\u0165 \u0161k\u00e1lovate\u013enos\u0165 a v\u00fdkon datab\u00e1zov\u00e9ho enginu pre v\u00e4\u010d\u0161inu pracovn\u00fdch za\u0165a\u017een\u00ed...<\/p>\n<p>Pri virtualiz\u00e1cii VMware so SQL Serverom pou\u017e\u00edvajte:<\/p>\n<ul>\n<li>Monitorovanie virtu\u00e1lnych strojov na detekciu nedostatku zdrojov pam\u00e4te pre SQL Server Database Engine. Tento probl\u00e9m vedie k zv\u00fd\u0161eniu vstupno-v\u00fdstupn\u00fdch oper\u00e1ci\u00ed a zn\u00ed\u017eeniu v\u00fdkonu.<\/li>\n<\/ul>\n<p><\/p>\n<ul>\n<li>Na zv\u00fd\u0161enie v\u00fdkonu zabra\u0148te konfliktom pam\u00e4te medzi virtu\u00e1lnymi strojmi, a to vyh\u00fdban\u00edm sa nadmern\u00e9mu za\u0165a\u017eeniu pam\u00e4te na \u00farovni hostite\u013ea ESXi.<\/li>\n<li>Zv\u00e1\u017ete mo\u017enos\u0165 kontroly hardv\u00e9rovej alok\u00e1cie fyzickej pam\u00e4te NUMA, aby ste ur\u010dili maxim\u00e1lny objem pam\u00e4te, ktor\u00fd m\u00f4\u017ee by\u0165 pridelen\u00fd virtu\u00e1lnemu stroju v fyzick\u00fdch medziach NUMA.<\/li>\n<li>Ak je dosiahnutie adekv\u00e1tneho v\u00fdkonu hlavn\u00fd cie\u013e, zv\u00e1\u017ete rezervovanie pam\u00e4te, ktor\u00e1 je rovn\u00e1 pridelen\u00e9mu objemu pam\u00e4te. Toto nastavenie parametrov zaru\u010duje, \u017ee virtu\u00e1lny stroj dostane iba fyzick\u00fa pam\u00e4\u0165.<\/li>\n<\/ul>\n<p><\/p>\n<h2>Virtualizovan\u00e9 \u00falo\u017eisko<\/h2>\n<p>\nNastavenie \u00falo\u017eiska vo virtualizovanom prostred\u00ed vy\u017eaduje znalos\u0165 infra\u0161trukt\u00fary SAN. Rovnako ako v pr\u00edpade NUMA, treba rozumie\u0165, ako funguj\u00fa r\u00f4zne \u00farovne vstupu a v\u00fdstupu \u2013 v tomto pr\u00edpade od aplik\u00e1cie vo VM po fyzick\u00e9 \u010d\u00edtanie a z\u00e1pis inform\u00e1ci\u00ed na trval\u00fd d\u00e1tov\u00fd nosi\u010d.<\/p>\n<p>vSphere poskytuje mno\u017estvo mo\u017enost\u00ed pre nastavenie \u00falo\u017eiska, ktor\u00e9 maj\u00fa u\u017eito\u010dn\u00e9 aplik\u00e1cie pri implement\u00e1cii SQL Serveru s array Unity XT. FS VMFS je naj\u0161ir\u0161ie pou\u017e\u00edvanou met\u00f3dou ukladania d\u00e1t v blokov\u00fdch \u00falo\u017en\u00fdch syst\u00e9moch, ako je Unity XT. Array Unity XT je spodn\u00e1 \u00farove\u0148, pozost\u00e1vaj\u00faca z fyzick\u00fdch \u00falo\u017en\u00fdch zariaden\u00ed, ktor\u00e9 s\u00fa vo vSphere predlo\u017een\u00e9 ako logick\u00e9 disky (volume). Volume Unity XT s\u00fa naform\u00e1tovan\u00e9 ako VMFS volume hyperv\u00edzorom ESXi. VMware administr\u00e1tori vytv\u00e1raj\u00fa jeden alebo viac virtu\u00e1lnych diskov (VMDK), ktor\u00e9 s\u00fa predlo\u017een\u00e9 hos\u0165uj\u00facemu opera\u010dn\u00e9mu syst\u00e9mu. RDM umo\u017e\u0148uje virtu\u00e1lnemu stroju priamo sa prip\u00e1ja\u0165 k blokov\u00e9mu \u00falo\u017eisku (cez FC alebo iSCSI) Unity XT bez form\u00e1tovania VMFS. Volume VMFS a RDM m\u00f4\u017eu poskytova\u0165 rovnak\u00fa priepustnos\u0165 transakci\u00ed.\u00a0<\/p>\n<p>Pre NFS \u00falo\u017eisko pre ESXi spolo\u010dnos\u0165 Dell EMC odpor\u00fa\u010da pou\u017e\u00edva\u0165 VMware NFS namiesto be\u017en\u00fdch NFS s\u00faborov\u00fdch syst\u00e9mov. Virtu\u00e1lny stroj be\u017eiaci na SQL Serveri a pou\u017e\u00edvaj\u00faci VMDK v NFS d\u00e1tovom \u00falo\u017eisku nevie o podkladovej vrstve NFS. Hos\u0165uj\u00faci opera\u010dn\u00fd syst\u00e9m vn\u00edma virtu\u00e1lny stroj ako fyzick\u00fd server be\u017eiaci pod Windows Server a SQL Server. Spolo\u010dn\u00e9 disky pre konfigur\u00e1cie in\u0161tancie odolnej vo\u010di poruch\u00e1m v NFS d\u00e1tov\u00fdch \u00falo\u017eisk\u00e1ch nie s\u00fa podporovan\u00e9.<\/p>\n<p>Virtu\u00e1lne objemy VMware vSphere (VVols) pon\u00fakaj\u00fa podrobnej\u0161ie riadenie na \u00farovni virtu\u00e1lnych strojov, nez\u00e1visle od z\u00e1kladn\u00e9ho zobrazenia fyzickej pam\u00e4te (napr\u00edklad objemov alebo s\u00faborov\u00fdch syst\u00e9mov). Replik\u00e1cia na z\u00e1klade po\u013ea s VVols je podporovan\u00e1 od VVol 2.0 (vSphere 6.5). Disk VVol m\u00f4\u017ee by\u0165 pou\u017eit\u00fd namiesto disku RDM na poskytnutie diskov\u00e9ho zdroja in\u0161tancii odolnej vo\u010di zlyhaniu v klastri SQL, po\u010dn\u00fac vSphere 6.7, s podporou trval\u00e9ho rezervovania cez SCSI.<\/p>\n<h2>Virtualizovan\u00e9 siete<\/h2>\n<p>\nSie\u0165 vo virtu\u00e1lnom svete nasleduje rovnak\u00e9 logick\u00e9 koncepty ako v fyzickom svete, ale vyu\u017e\u00edva softv\u00e9r, nie fyzick\u00e9 k\u00e1ble a prep\u00edna\u010de. Vplyv latencie siete na pracovn\u00e9 za\u0165a\u017eenia SQL Servera m\u00f4\u017ee zna\u010dne variabilne ovplyvni\u0165. Monitorovanie v\u00fdkonnostn\u00fdch ukazovate\u013eov siete na existuj\u00facej pracovnej z\u00e1\u0165a\u017ei alebo na dobre realizovanom testovacom syst\u00e9me po\u010das reprezentat\u00edvneho obdobia pom\u00e1ha pri vytv\u00e1ran\u00ed virtu\u00e1lnej siete.<\/p>\n<p>Pri pou\u017e\u00edvan\u00ed virtualiz\u00e1cie VMware so SQL Serverom je potrebn\u00e9 zoh\u013eadni\u0165 nasledovn\u00e9:<\/p>\n<ul>\n<li>Ako \u0161tandardn\u00e9, tak aj distribuovan\u00e9 virtu\u00e1lne prep\u00edna\u010de poskytuj\u00fa funk\u010dnos\u0165 potrebn\u00fa pre SQL Server.<\/li>\n<li>Na logick\u00e9 rozdelenie spr\u00e1vy, vSphere vMotion a sie\u0165ov\u00e9ho \u00falo\u017eiska pou\u017eite tagovanie VLAN a portov\u00e9 skupiny virtu\u00e1lneho prep\u00edna\u010da.<\/li>\n<li>VMware d\u00f4razne odpor\u00fa\u010da povoli\u0165 ve\u013ek\u00e9 r\u00e1mce na virtu\u00e1lnych prep\u00edna\u010doch, kde je povolen\u00fd prenos vSphere vMotion alebo iSCSI.<\/li>\n<li>Celkovo dodr\u017eiavajte sie\u0165ov\u00e9 odpor\u00fa\u010dania pre hos\u0165uj\u00face opera\u010dn\u00e9 syst\u00e9my a hardv\u00e9r.<\/li>\n<\/ul>\n<p><\/p>\n<h2>\u00a0Z\u00e1ver\u00a0<\/h2>\n<p>\nProstredia datab\u00e1z SQL Server sa st\u00e1vaj\u00fa st\u00e1le v\u00e4\u010d\u0161\u00edmi a zlo\u017eitej\u0161\u00edmi. V SQL Server 2019 Microsoft zlep\u0161il z\u00e1kladn\u00e9 funkcie SQL Servera a pridal nov\u00e9, ako podporu pracovn\u00fdch za\u0165a\u017een\u00ed ve\u013ek\u00fdch d\u00e1t pomocou Apache Spark a HDFS. Dell EMC v spolupr\u00e1ci s Microsoftom na\u010falej poskytuje pre prostredie SQL Server potrebn\u00e9 komponenty infra\u0161trukt\u00fary \u2013 servery, \u00falo\u017eisk\u00e1 a siete.\u00a0<\/p>\n<p>Pozorujeme v\u00fdznamn\u00fd n\u00e1rast \u010dasu bezporuchov\u00e9ho chodu a zn\u00ed\u017eenie celkov\u00fdch n\u00e1kladov na vlastn\u00edctvo (TCO), ak odborn\u00edci na \u00falo\u017en\u00e9 syst\u00e9my a datab\u00e1zy spolo\u010dne pracuj\u00fa na vytv\u00e1ran\u00ed infra\u0161trukt\u00farnych rie\u0161en\u00ed pre SQL Server na platform\u00e1ch so zdie\u013ean\u00fdm \u00falo\u017eiskom. Flash array Dell EMC Unity XT je stredne v\u00fdkonn\u00e9 rie\u0161enie vhodn\u00e9 pre v\u00fdvoj\u00e1rov a administr\u00e1torov SQL Server, ktor\u00ed potrebuj\u00fa vysok\u00fd v\u00fdkon a n\u00edzku latenciu. Syst\u00e9m Unity XT All-Flash je navrhnut\u00fd na pr\u00e1cu so v\u0161etk\u00fdmi flash zariadeniami, podporuje dvojprocesorov\u00e9 CPU, dvojkontejnerov\u00e9 konfigur\u00e1cie a optimaliz\u00e1ciu pre viac jadier.<\/p>\n<p>St\u00e1le \u010dastej\u0161ie organiz\u00e1cie virtualizuj\u00fa svoje prostredia SQL Server. Hoci virtualiz\u00e1cia prid\u00e1va do architekt\u00fary \u010fal\u0161iu \u00farove\u0148 n\u00e1vrhu, poskytuje zna\u010dn\u00e9 v\u00fdhody. D\u00fafame, \u017ee v\u00e1m bud\u00fa u\u017eito\u010dn\u00e9 niektor\u00e9 z naj\u010dastej\u0161ie pou\u017e\u00edvan\u00fdch funkci\u00ed a n\u00e1strojov VMware v prostrediach SQL Server, ktor\u00e9 s\u00fa uveden\u00e9 vy\u0161\u0161ie. Odpor\u00fa\u010dame aj odkazy na zdroje pre podrobnej\u0161ie inform\u00e1cie.<\/p>\n<h2>U\u017eito\u010dn\u00e9 odkazy<\/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 pre Ready Solutions<\/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 Storage s 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: Pr\u00edru\u010dka osved\u010den\u00fdch postupov<\/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: Biela kniha o kompresii<\/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: Biela kniha o sn\u00edmkach a tenk\u00fdch klonoch<\/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: Anal\u00fdza zmen\u0161ovania d\u00e1t<\/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: Biela kniha o zmen\u0161ovan\u00ed d\u00e1t<\/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 Unified Storage<\/a><\/noindex> (str\u00e1nka produktu)<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.youtube.com\/watch?v=oJ9T1lJf538\">Preh\u013ead produktu Dell EMC Unity a architekt\u00fara s Kaushikom Ghoshom<\/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\">Program lojalita Dell EMC Future-Proof<\/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\">Blogy SQL Server<\/a><\/noindex><\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.vmware.com\/solutions\/business-critical-apps\/sql-virtualization.html\">Virtualiz\u00e1cia Microsoft SQL na 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\">Navrhovanie Microsoft SQL Server na VMware vSphere \u2013 Pr\u00edru\u010dka osved\u010den\u00fdch postupov<\/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\">Charakterizovanie v\u00fdkonu Microsoft SQL Server na 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\/\">Technick\u00e1 biela kniha o Microsoft SQL Server 2019<br \/>\nBlog SQL Server<\/a><\/noindex><br \/>\n<noindex><a rel=\"nofollow\" href=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/default.aspx\">Microsoft D\u00e1tov\u00e1 platforma<\/a><\/noindex><br \/>\n<noindex><a rel=\"nofollow\" href=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/sql-server-2019\">Predstavujeme 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\">Arch\u00edv ozn\u00e1menia CTP o SQL Server 2019<\/a><\/noindex>\n<\/li>\n<\/ul>\n<p>Zdroj: <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.5 - 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\/sk\/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.5\" \/>\n\t\t<meta property=\"og:locale\" content=\"sk_SK\" \/>\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\/sk\/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 a flash array Dell EMC Unity XT | ProHoster","description":"Dnes v\u00e1s obozn\u00e1mime s vlastnos\u0165ami pou\u017e\u00edvania SQL Server 2019 s \u00falo\u017en\u00fdm syst\u00e9mom Unity XT a poskytneme odpor\u00fa\u010dania na virtualiz\u00e1ciu SQL Server s technol\u00f3giou VMware, vr\u00e1tane nastavenia a spr\u00e1vy.","canonical_url":"https:\/\/prohoster.info\/sk\/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":"sk_SK","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\/sk\/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\/sk\/wp-json\/wp\/v2\/posts\/53529","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/comments?post=53529"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/posts\/53529\/revisions"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/media?parent=53529"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/categories?post=53529"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/tags?post=53529"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}