{"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\/cs\/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 sezn\u00e1m\u00edme s vlastnostmi pou\u017e\u00edv\u00e1n\u00ed SQL Server 2019 s \u00falo\u017ei\u0161t\u011bm Unity XT a tak\u00e9 poskytneme doporu\u010den\u00ed pro virtualizaci SQL Serveru pomoc\u00ed technologie VMware, nastaven\u00ed a spr\u00e1vy z\u00e1kladn\u00edch komponent\u016f infrastruktury 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 roce 2017 publikovaly spole\u010dnosti Dell EMC a VMware v\u00fdsledky pr\u016fzkumu o trendech a evoluci SQL Serveru \u2013 \"Transformace SQL Serveru: sm\u011brem k flexibilit\u011b a odolnosti\" (<noindex><a rel=\"nofollow\" href=\"http:\/\/www.dbta.com\/DBTA-Downloads\/ResearchReports\/SQL-Server-Transformation-Toward-Agility-and-Resiliency-6705.aspx\">Transformace SQL Serveru: Sm\u011brem k flexibilit\u011b a odolnosti<\/a><\/noindex>), ve kter\u00e9m byly vyu\u017eity zku\u0161enosti \u010dlen\u016f Profesion\u00e1ln\u00ed asociace SQL Server (Professional Association of SQL Server, PASS). V\u00fdsledky ukazuj\u00ed, \u017ee prost\u0159ed\u00ed datab\u00e1z\u00ed SQL Server roste jak ve velikosti, tak ve slo\u017eitosti, co\u017e je zp\u016fsobeno rostouc\u00edmi objemy dat a nov\u00fdmi byznys po\u017eadavky. Datab\u00e1ze SQL Server jsou v sou\u010dasnosti nasazeny v mnoha spole\u010dnostech a zaji\u0161\u0165uj\u00ed provoz kritick\u00fdch aplikac\u00ed a \u010dasto tvo\u0159\u00ed z\u00e1klad digit\u00e1ln\u00ed transformace.\u00a0<\/p>\n<p>Od doby, kdy byl tento pr\u016fzkum proveden, Microsoft vydal dal\u0161\u00ed generaci S\u0158BD \u2013 SQL Server 2019. Krom\u011b vylep\u0161en\u00ed z\u00e1kladn\u00edch funkc\u00ed rela\u010dn\u00edho enginu a \u00falo\u017ei\u0161t\u011b dat se objevily nov\u00e9 slu\u017eby a funkce. Nap\u0159\u00edklad SQL Server 2019 zahrnuje podporu pro pracovn\u00ed z\u00e1t\u011b\u017ee velk\u00fdch dat s vyu\u017eit\u00edm Apache Spark a distribuovan\u00e9ho souborov\u00e9ho syst\u00e9mu Hadoop (Hadoop Distributed File System, HDFS).<br \/>\n<noindex><a rel=\"nofollow\" name=\"habracut\"><\/a><\/noindex><\/p>\n<h2>Aliance Dell EMC a Microsoft<\/h2>\n<p>\nDell EMC a Microsoft dlouhodob\u011b spolupracuj\u00ed na v\u00fdvoji \u0159e\u0161en\u00ed pro SQL Server. \u00dasp\u011b\u0161n\u00e9 nasazen\u00ed komplexn\u00ed datab\u00e1zov\u00e9 platformy, jako je Microsoft SQL Server, vy\u017eaduje koordinaci funkc\u00ed softwaru s z\u00e1kladn\u00ed IT infrastrukturou. Tato infrastruktura zahrnuje v\u00fdpo\u010detn\u00ed kapacity procesoru, zdroje pam\u011bti, \u00falo\u017ei\u0161t\u011b a s\u00ed\u0165ov\u00e9 slu\u017eby. Dell EMC nab\u00edz\u00ed infrastrukturu pro platformu SQL Server pro jak\u00fdkoli typ pracovn\u00ed z\u00e1t\u011b\u017ee a aplikac\u00ed.<\/p>\n<p>\u0158ada server\u016f Dell EMC PowerEdge nab\u00edz\u00ed \u0161irokou \u0161k\u00e1lu konfigurac\u00ed procesor\u016f a pam\u011bti. Tyto konfigurace jsou vhodn\u00e9 pro r\u016fzn\u00e9 \u00falohy: od mal\u00fdch firemn\u00edch aplikac\u00ed po nejv\u011bt\u0161\u00ed kriticky d\u016fle\u017eit\u00e9 syst\u00e9my, jako je pl\u00e1nov\u00e1n\u00ed podnikov\u00fdch zdroj\u016f (ERP), datov\u00e9 sklady, pokro\u010dil\u00e1 anal\u00fdza, elektronick\u00fd obchod a dal\u0161\u00ed. \u0158ada pam\u011b\u0165ov\u00fdch za\u0159\u00edzen\u00ed je ur\u010dena pro ukl\u00e1d\u00e1n\u00ed strukturovan\u00fdch a nestrukturovan\u00fdch dat.\u00a0<\/p>\n<p>Z\u00e1kazn\u00edci, kte\u0159\u00ed implementuj\u00ed SQL Server 2019 s infrastrukturou Dell EMC, mohou pracovat se strukturovan\u00fdmi a nestrukturovan\u00fdmi daty pomoc\u00ed SQL Server a Apache Spark. SQL Server tak\u00e9 podporuje kombinace technologi\u00ed klientsk\u00e9ho p\u0159\u00edstupu, meziserverov\u00e9 komunikace a komunikace 'server-sklad'. Koncept Dell EMC je zalo\u017een na dezeragovan\u00e9 architektu\u0159e, kter\u00e1 nab\u00edz\u00ed otev\u0159en\u00fd ekosyst\u00e9m. Organizace si mohou vyb\u00edrat z \u0161irok\u00e9 \u0161k\u00e1ly standardn\u00edch pr\u016fmyslov\u00fdch s\u00ed\u0165ov\u00fdch aplikac\u00ed, opera\u010dn\u00edch syst\u00e9m\u016f a hardwarov\u00fdch platforem. Tento p\u0159\u00edstup poskytuje maxim\u00e1ln\u00ed kontrolu nad technologiemi a architekturami, co\u017e vede k v\u00fdrazn\u00fdm \u00faspor\u00e1m a flexibilit\u011b.<\/p>\n<p>VMware zaji\u0161\u0165uje virtualizaci v\u0161ech kritick\u00fdch komponent infrastruktury, kter\u00e9 SQL Server pot\u0159ebuje k dosa\u017een\u00ed vysok\u00e9ho v\u00fdkonu a konzistence operac\u00ed. Krom\u011b priv\u00e1tn\u00edho cloudu nab\u00edz\u00ed VMware tak\u00e9 hybridn\u00ed modely pro pracovn\u00ed z\u00e1t\u011b\u017ee, kter\u00e9 pokr\u00fdvaj\u00ed priv\u00e1tn\u00ed a ve\u0159ejn\u00e9 cloudov\u00e9 architektury.\u00a0<\/p>\n<p>Mnoho organizac\u00ed se uchyluje k virtualizaci, aby sn\u00ed\u017eilo n\u00e1klady na infrastrukturu, zajistilo vysokou dostupnost a zjednodu\u0161ilo obnovu po hav\u00e1rii. 94 % dotazovan\u00fdch odborn\u00edk\u016f na SQL Server hl\u00e1s\u00ed n\u011bjakou \u00farove\u0148 virtualizace ve sv\u00e9m prost\u0159ed\u00ed. 70 % t\u011bch, kte\u0159\u00ed pou\u017e\u00edvaj\u00ed virtualizaci, zvolili VMware. U 60 % je \u00farove\u0148 virtualizace SQL Server 75 % a v\u00edce. Nav\u00edc v\u00fdsledky pr\u016fzkumu jasn\u011b ukazuj\u00ed, \u017ee vysok\u00e1 dostupnost a obnova po hav\u00e1rii, realizovan\u00e9 na \u00farovni virtualizace, se staly d\u016fle\u017eit\u00fdmi faktory p\u0159i rozhodov\u00e1n\u00ed o virtualizaci datab\u00e1z\u00ed SQL Server.<\/p>\n<h2>Nov\u00e9 funkce SQL Server 2019<\/h2>\n<p>\nPlatforma SQL Server 2019 zahrnuje \u0161irokou \u0161k\u00e1lu technologi\u00ed, funkc\u00ed a slu\u017eeb, kter\u00e9 podporuj\u00ed kritick\u00e9 aplikace, jako je anal\u00fdza, podnikov\u00e9 datab\u00e1ze, business intelligence (BI) a \u0161k\u00e1lovateln\u00e9 zpracov\u00e1n\u00ed transakc\u00ed (OLTP). Platforma SQL Server z\u00edskala schopnosti pro spr\u00e1vu integrace dat, datov\u00fdch sklad\u016f, reportov\u00e1n\u00ed a pokro\u010dil\u00e9 analytiky, funkc\u00ed replikace a spr\u00e1vy polostrukturovan\u00fdch typ\u016f dat. Samoz\u0159ejm\u011b, ne v\u0161ichni z\u00e1kazn\u00edci nebo aplikace pot\u0159ebuj\u00ed v\u0161echny tyto funkce. Krom\u011b toho je v mnoha p\u0159\u00edpadech preferovan\u00e9 odd\u011blovat slu\u017eby SQL Server pomoc\u00ed virtualizace.\u00a0<\/p>\n<p>Dnes jsou podniky \u010dasto odk\u00e1z\u00e1ny na velk\u00e9 objemy dat z \u0161irok\u00e9ho spektra neust\u00e1le se roz\u0161i\u0159uj\u00edc\u00edch datov\u00fdch sad. S pomoc\u00ed SQL Server 2019 m\u016f\u017eete z\u00edskat cenn\u00e9 informace t\u00e9m\u011b\u0159 v re\u00e1ln\u00e9m \u010dase ze v\u0161ech dat. Klastry SQL Server 2019 poskytuj\u00ed plnohodnotn\u00e9 prost\u0159ed\u00ed pro pr\u00e1ci s velk\u00fdmi datov\u00fdmi sadami, v\u010detn\u011b vyu\u017eit\u00ed strojov\u00e9ho u\u010den\u00ed a mo\u017enost\u00ed um\u011bl\u00e9 inteligence. Hlavn\u00ed nov\u00e9 funkce a aktualizace v SQL Server 2019 jsou uvedeny 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\">dokumentu Microsoft<\/a><\/noindex>.<\/p>\n<h2>\u00dalo\u017en\u00fd syst\u00e9m st\u0159edn\u00ed t\u0159\u00eddy Dell EMC Unity XT<\/h2>\n<p>\n\u0158ada \u00falo\u017ei\u0161\u0165 Dell EMC Unity byla uvedena na trh p\u0159ed t\u00e9m\u011b\u0159 t\u0159emi lety a od t\u00e9 doby bylo prod\u00e1no v\u00edce ne\u017e 40 000 syst\u00e9m\u016f. Z\u00e1kazn\u00edci ocenili tento st\u0159edn\u011b velk\u00fd syst\u00e9m za jeho jednoduchost, v\u00fdkon a ekonomi\u010dnost. Platformy st\u0159edn\u00ed t\u0159\u00eddy Dell EMC Unity XT jsou \u0159e\u0161en\u00ed s centr\u00e1ln\u00edm \u00falo\u017ei\u0161t\u011bm, kter\u00e9 poskytuj\u00ed n\u00edzkou latenci, vysokou propustnost a n\u00edzk\u00e9 n\u00e1klady na spr\u00e1vu pro pracovn\u00ed z\u00e1t\u011b\u017ee SQL Server. V\u0161echny syst\u00e9my Unity XT vyu\u017e\u00edvaj\u00ed architekturu se dv\u011bma procesory (storage processors, SP) pro obsluhu vstupu a v\u00fdstupu a prov\u00e1d\u011bn\u00ed operac\u00ed s daty v re\u017eimu active\/active. V Unity XT dual SP je k dosa\u017een\u00ed vysok\u00e9ho v\u00fdkonu a efektivity pou\u017e\u00edv\u00e1no pln\u00e9 intern\u00ed propojen\u00ed SAS 12 Gbit\/s a patentovan\u00e1 v\u00edcej\u00e1drov\u00e1 architektura. Diskov\u00e9 pole umo\u017e\u0148uje zvy\u0161ovat kapacitu \u00falo\u017ei\u0161t\u011b pomoc\u00ed dal\u0161\u00edch polic.<\/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 \/>\nU Dell EMC Unity XT, nov\u00e9 generaci pol\u00ed (hybridn\u00edch a zcela flashov\u00fdch), do\u0161lo k v\u00fdrazn\u00e9mu n\u00e1r\u016fstu v\u00fdkonu, zv\u00fd\u0161en\u00ed efektivity a p\u0159id\u00e1n\u00ed nov\u00fdch funkc\u00ed a slu\u017eeb pro multicloudov\u00e9 prost\u0159ed\u00ed.\u00a0<\/p>\n<p>Architektura Unity XT umo\u017e\u0148uje sou\u010dasn\u00e9 zpracov\u00e1n\u00ed dat, sni\u017eov\u00e1n\u00ed jejich objemu a podporu slu\u017eeb jako je replikace, ani\u017e by to m\u011blo vliv na v\u00fdkon aplikac\u00ed. Ve srovn\u00e1n\u00ed s \u0159e\u0161en\u00edm p\u0159edchoz\u00ed generace se v\u00fdkon \u00falo\u017en\u00e9ho syst\u00e9mu Dell EMC Unity XT zdvojn\u00e1sobil, doba odezvy se zkr\u00e1tila o 75 %. A samoz\u0159ejm\u011b, Dell EMC Unity podporuje standard NVMe.<\/p>\n<p>\u00dalo\u017en\u00e9 syst\u00e9my s NVMe disky vykazuj\u00ed nejlep\u0161\u00ed v\u00fdkon v aplikac\u00edch citliv\u00fdch na zpo\u017ed\u011bn\u00ed. Nap\u0159\u00edklad v aplikac\u00edch jako jsou rozs\u00e1hl\u00e9 datab\u00e1ze zaji\u0161\u0165uje NVMe n\u00edzk\u00e9 zpo\u017ed\u011bn\u00ed a vysok\u00e9 \u0161pi\u010dkov\u00e9 p\u0159enosov\u00e9 rychlosti. Redukce zpo\u017ed\u011bn\u00ed a zv\u00fd\u0161en\u00ed paraleln\u00edho zpracov\u00e1n\u00ed v\u00fdznamn\u011b zvy\u0161uj\u00ed v\u00fdkon operac\u00ed \u010dten\u00ed\/z\u00e1pisu. Nen\u00ed n\u00e1hodou, \u017ee podle progn\u00f3zy IDC budou do roku 2021 flashov\u00e9 syst\u00e9my p\u0159ipojen\u00e9 p\u0159es NVMe a NVMe-oF (NVMe over Fabric) tvo\u0159it p\u0159ibli\u017en\u011b polovinu v\u0161ech p\u0159\u00edjm\u016f z prodeje extern\u00edch \u00falo\u017ei\u0161\u0165 na sv\u011bt\u011b.\u00a0<\/p>\n<p>Ekonomi\u010dnost \u00falo\u017ei\u0161t\u011b zlep\u0161uj\u00ed algoritmy komprese dat. Dell EMC Unity XT m\u016f\u017ee zkracovat objem dat a\u017e p\u011btkr\u00e1t. Dal\u0161\u00edm d\u016fle\u017eit\u00fdm ukazatelem je celkov\u00e1 efektivita syst\u00e9mu. Dell EMC Unity XT pou\u017e\u00edv\u00e1 syst\u00e9movou kapacitu na 85 %. Komprese a deduplikace prob\u00edhaj\u00ed in-line \u2014 na \u00farovni kontrol\u00e9r\u016f. Data jsou uchov\u00e1v\u00e1na v komprimovan\u00e9 podob\u011b. Syst\u00e9m tak\u00e9 automatizuje pr\u00e1ci se snapshoty dat.<\/p>\n<p>Jednoduch\u00e9 flashov\u00e9 syst\u00e9my Unity s unifikovan\u00fdm (blokov\u00fdm a souborov\u00fdm) p\u0159\u00edstupem zaji\u0161\u0165uj\u00ed stabiln\u00ed dobu odezvy, integruj\u00ed se s cloudov\u00fdmi \u00falo\u017en\u00fdmi slu\u017ebami a podporuj\u00ed upgrade bez migrace dat. V z\u00e1kladn\u00ed konfiguraci je tento univerz\u00e1ln\u00ed syst\u00e9m \u00falo\u017ei\u0161t\u011b nainstalov\u00e1n za 30 minut.<\/p>\n<p>Technologie \u00falo\u017ei\u0161t\u011b dat nazvan\u00e1 \u201edynamick\u00e9 pooly\u201c umo\u017e\u0148uje p\u0159echod od statick\u00e9ho k dynamick\u00e9mu roz\u0161i\u0159ov\u00e1n\u00ed pam\u011bti, poskytuje vysokou provozn\u00ed flexibilitu a jednoduchost zvy\u0161ov\u00e1n\u00ed kapacity syst\u00e9mu. Dynamick\u00e9 pooly \u0161et\u0159\u00ed kapacitu a rozpo\u010det, vy\u017eaduj\u00ed m\u00e9n\u011b \u010dasu na rekonstrukci. Zvy\u0161ov\u00e1n\u00ed kapacity a v\u00fdkonu Dell EMC Unity nevy\u017eaduje migraci dat.\u00a0<\/p>\n<p>Mnoho spole\u010dnost\u00ed dnes v kombinaci se svou lok\u00e1ln\u00ed infrastrukturou vyu\u017e\u00edv\u00e1 n\u011bkolik ve\u0159ejn\u00fdch cloudov\u00fdch slu\u017eeb. Dell EMC Unity XT m\u016f\u017ee fungovat jako komponenta cloudov\u00e9ho prost\u0159ed\u00ed Dell Technologies Cloud. Tento \u00falo\u017ei\u0161t\u011b dat lze pou\u017e\u00edvat v ve\u0159ejn\u00e9m cloudu a p\u0159en\u00e1\u0161et data do soukrom\u00e9ho cloudu. Krom\u011b toho je \u00falo\u017ei\u0161t\u011b Dell EMC Unity XT dostupn\u00e9 na modelu \u201ejako slu\u017eba\u201c. Je to jedna z cloudov\u00fdch slu\u017eeb Dell EMC Cloud Storage Services.<br \/>\n\u00a0<br \/>\nCloudov\u00e1 \u00falo\u017ei\u0161t\u011b z\u00edsk\u00e1vaj\u00ed st\u00e1le v\u011bt\u0161\u00ed popularitu, proto\u017ee umo\u017e\u0148uj\u00ed zv\u00fd\u0161it n\u00e1vratnost investic d\u00edky sn\u00ed\u017een\u00ed n\u00e1klad\u016f na infrastrukturu. Slu\u017eby cloudov\u00e9ho \u00falo\u017ei\u0161t\u011b Cloud Storage Services roz\u0161i\u0159uj\u00ed datov\u00e1 centra z\u00e1kazn\u00edk\u016f do cloudu, poskytuj\u00edc\u00ed \u00falo\u017ei\u0161t\u011b Dell EMC (p\u0159\u00edmo p\u0159ipojen\u00e9 k ve\u0159ejn\u00e9mu cloudu) jako slu\u017ebu. Extern\u00ed poskytovatel\u00e9 mohou zajistit vysokorychlostn\u00ed p\u0159ipojen\u00ed (s n\u00edzkou latenc\u00ed) ve\u0159ejn\u00e9ho cloudu p\u0159\u00edmo se syst\u00e9my Dell EMC Unity, PowerMax a Isilon v datov\u00e9m centru z\u00e1kazn\u00edka.<\/p>\n<p>Rodina Unity XT zahrnuje syst\u00e9my Unity XT All-Flash, Unity XT Hybrid, UnityVSA a Unity Cloud Edition.<br \/>\n\u00a0<\/p>\n<h2>Unified hybrid and flash arrays\u00a0<\/h2>\n<p>\nSyst\u00e9my Unity XT Hybrid a Unity XT All-Flash zalo\u017een\u00e9 na procesorech Intel realizuj\u00ed integrovanou architekturu pro blokov\u00fd, souborov\u00fd p\u0159\u00edstup a objemy VMware VVols s podporou protokol\u016f s\u00ed\u0165ov\u00e9ho \u00falo\u017ei\u0161t\u011b (NAS), iSCSI a Fibre Channel (FC). Platformy Unity XT Hybrid a Unity XT All-Flash jsou p\u0159ipraveny pro pou\u017eit\u00ed s NVMe disky.<\/p>\n<p>Hybridn\u00ed syst\u00e9my Unity XT podporuj\u00ed provoz v multicloudov\u00fdch prost\u0159ed\u00edch. Podpora multicloudov\u00fdch prost\u0159ed\u00ed znamen\u00e1 roz\u0161\u00ed\u0159en\u00ed syst\u00e9mu \u00falo\u017ei\u0161t\u011b dat do cloudu nebo nasazen\u00ed v cloudu s flexibiln\u00edmi mo\u017enostmi vyu\u017eit\u00ed zdroj\u016f. Multicloudov\u00e1 \u00falo\u017ei\u0161t\u011b maj\u00ed za c\u00edl zajistit mobilitu, p\u0159enositelnost dat mezi n\u011bkolika cloudov\u00fdmi platformami \u2013 soukrom\u00fdmi a ve\u0159ejn\u00fdmi. To ovliv\u0148uje nejen procesy migrace dat, ale tak\u00e9 organizaci p\u0159\u00edstupu aplikac\u00ed k dat\u016fm v n\u011bkolika ve\u0159ejn\u00fdch cloudech. <\/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 \/>\nTato hybridn\u00ed \u00falo\u017ei\u0161t\u011b nab\u00edzej\u00ed n\u00e1sleduj\u00edc\u00ed mo\u017enosti:<\/p>\n<ul>\n<li>\u0160k\u00e1lovatelnost a\u017e na 16 PB \u201ehrub\u00e9\u201c kapacity.<\/li>\n<li>Vestav\u011bn\u00e9 funkce pro redukci objemu dat pro v\u0161echny flash pooly.<\/li>\n<li>Rychl\u00e1 instalace a nastaven\u00ed (pr\u016fm\u011brn\u011b trv\u00e1 25 minut).<\/li>\n<\/ul>\n<p>\nTechnologie pevn\u00fdch disk\u016f se rychle vyv\u00edjej\u00ed a v n\u00e1sleduj\u00edc\u00edch letech se na trhu objev\u00ed nov\u00e9 revolu\u010dn\u00ed produkty. Mezit\u00edm budou organizace nad\u00e1le nahrazovat tradi\u010dn\u00ed HDD disky pevn\u00fdm diskem za \u00fa\u010delem zlep\u0161en\u00ed v\u00fdkonu, snadnosti spr\u00e1vy a \u00faspory energie. Nov\u00e9 generace flash pam\u011bt\u00ed budou m\u00edt sofistikovan\u011bj\u0161\u00ed prost\u0159edky pro automatizaci ukl\u00e1d\u00e1n\u00ed, integraci s ve\u0159ejn\u00fdm cloudem a integrovanou ochranu dat.\u00a0<\/p>\n<p>Syst\u00e9my Unity XT All-Flash nab\u00edzej\u00ed vysokou rychlost, efektivitu a podporu v\u00edce cloud\u016f. Mezi jejich vlastnosti pat\u0159\u00ed:<\/p>\n<ul>\n<li>Dvojn\u00e1sobn\u00fd v\u00fdkon.<\/li>\n<li>Sn\u00ed\u017een\u00ed objemu dat a\u017e 7:1.<\/li>\n<li>Rychl\u00e1 instalace a nastaven\u00ed (proces trv\u00e1 m\u00e9n\u011b ne\u017e 30 minut).<\/li>\n<\/ul>\n<p><\/p>\n<h2>\u00a0UnityVSA<\/h2>\n<p>\nSyst\u00e9m UnityVSA je softwarov\u011b definovan\u00e1 S\u00daZD pro virtu\u00e1ln\u00ed prost\u0159ed\u00ed VMware ESXi, vyu\u017e\u00edvaj\u00edc\u00ed serverovou, sd\u00edlenou nebo cloudovou kapacitu \u00falo\u017ei\u0161t\u011b. UnityVSA HA, konfigurace se dv\u011bma \u00falo\u017ei\u0161ti UnityVSA, poskytuje dodate\u010dnou odolnost proti poruch\u00e1m. \u00dalo\u017ei\u0161t\u011b UnityVSA nab\u00edz\u00ed:<\/p>\n<ul>\n<li>A\u017e 50 TB kapacity pln\u011b funk\u010dn\u00edho unifikovan\u00e9ho \u00falo\u017ei\u0161t\u011b.<\/li>\n<li>Kompatibilitu se syst\u00e9my a funkcemi Unity XT.<\/li>\n<li>Podporu syst\u00e9m\u016f vysok\u00e9 dostupnosti (UnityVSA HA).<\/li>\n<li>P\u0159ipojen\u00ed jako NAS a iSCSI.<\/li>\n<li>Replikaci dat z dal\u0161\u00edch platforem Unity XT.<\/li>\n<\/ul>\n<p><\/p>\n<h2>Unity Cloud Edition<\/h2>\n<p>\nPro synchronizaci soubor\u016f a operac\u00ed havarijn\u00edho obnoven\u00ed s cloudem rodina Unity XT zahrnuje verzi Unity Cloud Edition, kter\u00e1 poskytuje:<\/p>\n<ul>\n<li>Pln\u011b funk\u010dn\u00ed mo\u017enosti \u00falo\u017ei\u0161t\u011b pomoc\u00ed softwarov\u011b definovan\u00e9 S\u00daZD (SDS) nasazen\u00e9 v cloudu.<\/li>\n<li>Jednoduch\u00e9 nasazen\u00ed blokov\u00e9ho a souborov\u00e9ho \u00falo\u017ei\u0161t\u011b pomoc\u00ed VMware Cloud na AWS.<\/li>\n<li>Podporu havarijn\u00edho obnoven\u00ed, v\u010detn\u011b testov\u00e1n\u00ed a anal\u00fdzy dat.<\/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 pro SQL Server<\/h2>\n<p>\nV zpr\u00e1v\u011b Unisphere Research za rok 2017 \"Transformace SQL Server: na cest\u011b k flexibilit\u011b a odolnosti\" (<noindex><a rel=\"nofollow\" href=\"http:\/\/www.dbta.com\/DBTA-Downloads\/ResearchReports\/SQL-Server-Transformation-Toward-Agility-and-Resiliency-6705.aspx\">Transformace SQL Serveru: Sm\u011brem k flexibilit\u011b a odolnosti<\/a><\/noindex>) 22 % respondent\u016f uvedlo, \u017ee pou\u017e\u00edvaj\u00ed technologii flash \u00falo\u017ei\u0161t\u011b v produkci (16 %) nebo ji pl\u00e1nuj\u00ed pou\u017e\u00edvat (6 %). 30 % pou\u017e\u00edv\u00e1 hybridn\u00ed pole zahrnuj\u00edc\u00ed flash pam\u011b\u0165. 13 % pou\u017e\u00edv\u00e1 flash pole s p\u0159\u00edm\u00fdm p\u0159ipojen\u00edm. 13 % d\u011bl\u00e1 z\u00e1lohy datab\u00e1z\u00ed SQL Server na flash \u00falo\u017ei\u0161t\u011b.<\/p>\n<p>Tak rychl\u00e9 nasazen\u00ed flash \u00falo\u017ei\u0161\u0165 pro pou\u017eit\u00ed se SQL Serverem znamen\u00e1, \u017ee syst\u00e9my Unity XT All-Flash jsou obzvl\u00e1\u0161\u0165 vhodn\u00e9 pro v\u00fdvoj\u00e1\u0159e a administr\u00e1tory SQL Serveru. Syst\u00e9my Unity XT All-Flash poskytuj\u00ed v\u00fdvoj\u00e1\u0159\u016fm a administr\u00e1tor\u016fm SQL Serveru mo\u017enosti a v\u00fdkon, kter\u00e9 p\u0159ekra\u010duj\u00ed to, co nab\u00edzej\u00ed typick\u00e9 s\u00edt\u011b \u00falo\u017ei\u0161\u0165 (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, kter\u00e9 jsou p\u0159ipraveny pro nasazen\u00ed NVMe (pro je\u0161t\u011b vy\u0161\u0161\u00ed v\u00fdkon a n\u00edzkou latenci), maj\u00ed form\u00e1t 2U, podporuj\u00ed dvouj\u00e1drov\u00e9 procesory a dva \u0159adi\u010de v re\u017eimu 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\u011b\u0165 (na procesor)<\/p>\n<p>Max. \u010d\u00edslo disk\u016f<\/p>\n<p>Max. 'hrub\u00e1' 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 lze naj\u00edt v specifikac\u00edch pole (<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>\nMnoho profesion\u00e1l\u016f pracuj\u00edc\u00edch se SQL Serverem v\u00ed, \u017ee v\u0161echna modern\u00ed \u00falo\u017ei\u0161t\u011b nab\u00edzej\u00ed mo\u017enost seskupit disky do v\u011bt\u0161\u00edch jednotek \u00falo\u017ei\u0161t\u011b s pevn\u011b stanovenou \u00farovn\u00ed ochrany RAID. Odd\u011blen\u00e9 skupiny disk\u016f s ochranou RAID jsou tradi\u010dn\u00ed \u00falo\u017en\u00e9 pooly. Zat\u00edmco hybridn\u00ed syst\u00e9my Unity XT podporuj\u00ed pouze tradi\u010dn\u00ed pooly, syst\u00e9my Unity XT All-Flash nab\u00edzej\u00ed tak\u00e9 dynamick\u00e9 \u00falo\u017en\u00e9 pooly. V p\u0159\u00edpad\u011b dynamick\u00fdch \u00falo\u017en\u00fdch pool\u016f se ochrana RAID vyu\u017e\u00edv\u00e1 na extentech disk\u016f \u2013 jednotk\u00e1ch \u00falo\u017ei\u0161t\u011b men\u0161\u00edch ne\u017e cel\u00fd disk. Dynamick\u00e9 pooly poskytuj\u00ed v\u011bt\u0161\u00ed flexibilitu p\u0159i spr\u00e1v\u011b a roz\u0161i\u0159ov\u00e1n\u00ed diskov\u00fdch pool\u016f.\u00a0<\/p>\n<p>Dell EMC poskytuje doporu\u010den\u00ed pro spr\u00e1vu \u00falo\u017en\u00fdch pool\u016f za \u00fa\u010delem dosa\u017een\u00ed maxim\u00e1ln\u00edho v\u00fdkonu p\u0159i minim\u00e1ln\u00ed slo\u017eitosti. Nap\u0159\u00edklad se doporu\u010duje minimalizovat po\u010det \u00falo\u017en\u00fdch pool\u016f Unity XT, aby se sn\u00ed\u017eila slo\u017eitost a zv\u00fd\u0161ila flexibilita. Nicm\u00e9n\u011b nastaven\u00ed dal\u0161\u00edch \u00falo\u017en\u00fdch pool\u016f m\u016f\u017ee b\u00fdt ve n\u011bkter\u00fdch p\u0159\u00edpadech velmi rozumn\u00e9, v\u010detn\u011b situac\u00ed, kdy pot\u0159ebujete:<\/p>\n<ul>\n<li>Podporovat jednotliv\u00e9 pracovn\u00ed z\u00e1t\u011b\u017ee s r\u016fzn\u00fdmi profily vstupu\/v\u00fdstupu.<\/li>\n<li>Vy\u010dlenit prost\u0159edky pro dosa\u017een\u00ed ur\u010dit\u00fdch v\u00fdkonnostn\u00edch parametr\u016f.<\/li>\n<li>Vy\u010dle\u0148ovat jednotliv\u00e9 prost\u0159edky pro v\u00edce n\u00e1jemn\u00edky.<\/li>\n<li>Vytv\u00e1\u0159et men\u0161\u00ed dom\u00e9ny pro ochranu proti selh\u00e1n\u00ed<\/li>\n<\/ul>\n<p><\/p>\n<h2>\u00dalo\u017en\u00e9 jednotky (LUN)<\/h2>\n<p>\nJak naj\u00edt kompromis mezi spr\u00e1vou a flexibilitou p\u0159i volb\u011b po\u010dtu svazk\u016f v poli? Pro maxim\u00e1ln\u00ed flexibilitu v Unity se SQL Server doporu\u010duje vytv\u00e1\u0159et svazky pro ka\u017ed\u00fd soubor datab\u00e1ze. V praxi v\u011bt\u0161ina organizac\u00ed pou\u017e\u00edv\u00e1 v\u00edce\u00farov\u0148ov\u00fd p\u0159\u00edstup, kdy kriticky d\u016fle\u017eit\u00e9 datab\u00e1ze z\u00edsk\u00e1vaj\u00ed maxim\u00e1ln\u00ed flexibilitu, zat\u00edmco soubory m\u00e9n\u011b d\u016fle\u017eit\u00fdch datab\u00e1z\u00ed jsou seskupeny do men\u0161\u00edho po\u010dtu velk\u00fdch svazk\u016f. Doporu\u010dujeme prozkoumat v\u0161echny po\u017eadavky na datab\u00e1ze a jak\u00e9koli souvisej\u00edc\u00ed aplikace, proto\u017ee technologie ochrany dat a monitorov\u00e1n\u00ed z\u00e1vis\u00ed na izolaci a um\u00edst\u011bn\u00ed soubor\u016f.<\/p>\n<p>Spr\u00e1va mnoha svazk\u016f m\u016f\u017ee b\u00fdt obt\u00ed\u017en\u00e1, zvl\u00e1\u0161t\u011b ve virtu\u00e1ln\u00edch prost\u0159ed\u00edch. Virtualizovan\u00e1 prost\u0159ed\u00ed SQL Server jsou dobr\u00fdm p\u0159\u00edkladem, kdy m\u016f\u017ee d\u00e1vat smysl um\u00edstit n\u011bkolik typ\u016f soubor\u016f na jeden svazek. Spr\u00e1vce datab\u00e1ze nebo spr\u00e1vce \u00falo\u017ei\u0161t\u011b (nebo oba) by p\u0159i ur\u010dov\u00e1n\u00ed po\u010dtu vytv\u00e1\u0159en\u00fdch svazk\u016f m\u011bli zvolit spr\u00e1vnou rovnov\u00e1hu mezi flexibilitou a snadnou \u00fadr\u017ebou.<\/p>\n<h2>\u00dalo\u017en\u00fd prostor pro soubory<\/h2>\n<p>\nServery NAS umis\u0165uj\u00ed souborov\u00e9 syst\u00e9my na syst\u00e9m \u00falo\u017ei\u0161t\u011b Unity XT. K souborov\u00fdm syst\u00e9m\u016fm lze p\u0159istupovat prost\u0159ednictv\u00edm protokol\u016f SMB nebo NFS, a d\u00edky v\u00edceprotokolov\u00e9mu souborov\u00e9mu syst\u00e9mu lze vyu\u017e\u00edvat oba protokoly sou\u010dasn\u011b. Pro p\u0159ipojen\u00ed hostitele k SMB, NFS a v\u00edceprotokolov\u00fdm souborov\u00fdm syst\u00e9m\u016fm, jako\u017e i ke sklad\u016fm dat VMware NFS a virtu\u00e1ln\u00edm svazk\u016fm VMware, servery NAS pou\u017e\u00edvaj\u00ed virtu\u00e1ln\u00ed rozhran\u00ed. Souborov\u00e9 syst\u00e9my a virtu\u00e1ln\u00ed rozhran\u00ed jsou v r\u00e1mci jednoho serveru NAS izolov\u00e1ny, co\u017e umo\u017e\u0148uje vyu\u017e\u00edvat pro multitenancy v\u00edce server\u016f NAS. Servery NAS se automaticky p\u0159ep\u00ednaj\u00ed p\u0159i selh\u00e1n\u00ed, pokud dojde k poru\u0161e procesoru \u00falo\u017ei\u0161t\u011b. Souvisej\u00edc\u00ed souborov\u00e9 syst\u00e9my se tak\u00e9 p\u0159i selh\u00e1n\u00ed p\u0159ep\u00ednaj\u00ed.<\/p>\n<p>SQL Server 2012 (11.x) a nov\u011bj\u0161\u00ed verze podporuj\u00ed protokol Server Message Block (SMB) 3.0, kter\u00fd umo\u017e\u0148uje sd\u00edlen\u00ed s\u00ed\u0165ov\u00e9ho souboru pro ukl\u00e1d\u00e1n\u00ed. Jak pro samostatnou instalaci, tak pro vysoce dostupn\u00fd cluster m\u016f\u017eete nainstalovat syst\u00e9mov\u00e9 datab\u00e1ze (master, model, msdb a tempdb) a u\u017eivatelsk\u00e9 datab\u00e1ze Database Engine s mo\u017enost\u00ed ukl\u00e1d\u00e1n\u00ed SMB. Pou\u017eit\u00ed \u00falo\u017ei\u0161t\u011b SMB je dobrou volbou p\u0159i pou\u017e\u00edv\u00e1n\u00ed skupin vysok\u00e9 dostupnosti Always On Availability Groups, proto\u017ee pro sd\u00edlen\u00fd souborov\u00fd prost\u0159edek je zapot\u0159eb\u00ed p\u0159\u00edstup k vysoce dostupn\u00e9mu s\u00ed\u0165ov\u00e9mu prost\u0159edku.<\/p>\n<p>Vytv\u00e1\u0159en\u00ed sd\u00edlen\u00fdch souborov\u00fdch prost\u0159edk\u016f SMB pro nasazen\u00ed SQL Server s \u00falo\u017ei\u0161t\u011bm Unity XT je jednoduch\u00fd t\u0159\u00edkrokov\u00fd proces: je t\u0159eba vytvo\u0159it server NAS, souborov\u00fd syst\u00e9m a sd\u00edlen\u00fd prost\u0159edek SMB. Software Dell EMC Unisphere Storage Management obsahuje nastavovac\u00ed utilitu, kter\u00e1 v\u00e1m pom\u016f\u017ee tento proces uskute\u010dnit. P\u0159i um\u00edst\u011bn\u00ed pracovn\u00edch zat\u00ed\u017een\u00ed SQL Server na sd\u00edlen\u00fdch souborov\u00fdch prost\u0159edc\u00edch SMB v\u0161ak nezapom\u00ednejte na n\u011bkter\u00e9 d\u016fle\u017eit\u00e9 \u00favahy, kter\u00e9 se nemus\u00ed nutn\u011b vztahovat na pou\u017e\u00edv\u00e1n\u00ed sd\u00edlen\u00fdch souborov\u00fdch prost\u0159edk\u016f SMB. Microsoft sestavil seznam instala\u010dn\u00edch a bezpe\u010dnostn\u00edch ot\u00e1zek spolu se zn\u00e1m\u00fdmi probl\u00e9my; podrobnosti naleznete v \u010d\u00e1sti \"Instalace SQL Server s \u00falo\u017ei\u0161t\u011bm soubor\u016f SMB\" 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\">dokumentech Microsoft<\/a><\/noindex>.<\/p>\n<h2>Sn\u00edmky dat<\/h2>\n<p>\nData se stala nejd\u016fle\u017eit\u011bj\u0161\u00edm zdrojem firem a dnes kriticky d\u016fle\u017eit\u00e9 prost\u0159ed\u00ed vy\u017eaduj\u00ed nejen z\u00e1lohov\u00e1n\u00ed. Aplikace mus\u00ed b\u00fdt st\u00e1le online, s nep\u0159etr\u017eit\u00fdmi operacemi a aktualizacemi. Vy\u017eaduj\u00ed tak\u00e9 vysok\u00fd v\u00fdkon a dostupnost dat prost\u0159ednictv\u00edm mo\u017enost\u00ed, jako je m\u00edstn\u00ed replikace moment\u00e1ln\u00edch sn\u00edmk\u016f a vzd\u00e1len\u00e1 replikace.<\/p>\n<p>\u00dalo\u017en\u00fd syst\u00e9m Unity XT nab\u00edz\u00ed mo\u017enosti vytv\u00e1\u0159en\u00ed moment\u00e1ln\u00edch sn\u00edmk\u016f pro bloky a soubory, p\u0159i\u010dem\u017e pou\u017e\u00edvaj\u00ed sd\u00edlen\u00e9 pracovn\u00ed postupy, operace a architekturu. Metodologie sn\u00edmk\u016f Unity poskytuje jednoduch\u00fd a efektivn\u00ed zp\u016fsob ochrany dat. Sn\u00edmky usnad\u0148uj\u00ed obnovu dat \u2014 m\u016f\u017eete se vr\u00e1tit k d\u0159\u00edv\u011bj\u0161\u00edmu sn\u00edmku nebo si m\u016f\u017eete z kop\u00edrovat vybran\u00e1 data z p\u0159edchoz\u00edho sn\u00edmku. V n\u00e1sleduj\u00edc\u00ed tabulce jsou uvedeny doby uchov\u00e1v\u00e1n\u00ed sn\u00edmk\u016f pro syst\u00e9my Unity XT.<\/p>\n<h2>M\u00edstn\u00ed a vzd\u00e1len\u00e9 ukl\u00e1d\u00e1n\u00ed sn\u00edmk\u016f dat<\/h2>\n<p><\/p>\n<p>Typ sn\u00edmku<\/p>\n<p>CLI<br \/>\nUI<br \/>\nREST<\/p>\n<p>Manu\u00e1ln\u011b\u00a0<\/p>\n<p>Podle pl\u00e1nu\u00a0<\/p>\n<p>Manu\u00e1ln\u011b\u00a0<\/p>\n<p>Podle pl\u00e1nu\u00a0<\/p>\n<p>Manu\u00e1ln\u011b\u00a0<\/p>\n<p>Podle pl\u00e1nu\u00a0<\/p>\n<p>M\u00edstn\u00ed\u00a0<\/p>\n<p>1 rok\u00a0<\/p>\n<p>1 rok<\/p>\n<p>5 let\u00a0<\/p>\n<p>4 t\u00fddny<\/p>\n<p>100 let<\/p>\n<p>Bez omezen\u00ed<\/p>\n<p>Vzd\u00e1len\u00fd\u00a0<\/p>\n<p>5 let<\/p>\n<p>255 t\u00fddn\u016f\u00a0<\/p>\n<p>5 let<\/p>\n<p>255 t\u00fddn\u016f<\/p>\n<p>5 let<\/p>\n<p>255 t\u00fddn\u016f<\/p>\n<p>Momentky nejsou p\u0159\u00edmou n\u00e1hradou za jin\u00e9 metody ochrany dat, jako je z\u00e1lohov\u00e1n\u00ed. Mohou pouze doplnit tradi\u010dn\u00ed z\u00e1lohov\u00e1n\u00ed jako prvn\u00ed linii ochrany pro sc\u00e9n\u00e1\u0159e s n\u00edzk\u00fdm RTO.<\/p>\n<p>Funkce moment\u00e1ln\u00edch sn\u00edmk\u016f Dell EMC Unity zahrnuje redukci objemu dat a pokro\u010dilou deduplikaci. Momentky tak\u00e9 vyu\u017e\u00edvaj\u00ed \u00faspory m\u00edsta dosa\u017een\u00e9 na zdrojov\u00e9m \u00falo\u017ei\u0161ti. Kdy\u017e vytvo\u0159\u00edte sn\u00edmek \u00falo\u017en\u00e9ho zdroje s podporou funkc\u00ed redukce objemu dat, data na zdroji mohou b\u00fdt komprimov\u00e1na nebo deduplikov\u00e1na.<\/p>\n<p>Uve\u010fme n\u011bkolik pozn\u00e1mek t\u00fdkaj\u00edc\u00edch se obnoven\u00ed datab\u00e1ze p\u0159i pou\u017eit\u00ed sn\u00edmk\u016f s datab\u00e1zemi SQL Server:<\/p>\n<ul>\n<li>V\u0161echny komponenty datab\u00e1ze SQL Server by m\u011bly b\u00fdt chr\u00e1n\u011bny jako datov\u00e1 sada. Kdy\u017e jsou soubory dat a protokolu na r\u016fzn\u00fdch LUN, tyto LUN by m\u011bly b\u00fdt sou\u010d\u00e1st\u00ed konzistentn\u00ed skupiny. Konzistentn\u00ed skupina zaji\u0161\u0165uje, \u017ee moment\u00e1ln\u00ed sn\u00edmek bude proveden sou\u010dasn\u011b na v\u0161ech LUN ve skupin\u011b. Kdy\u017e jsou soubory dat a protokolu na n\u011bkolika sd\u00edlen\u00fdch souborov\u00fdch zdroj\u00edch SMB, sd\u00edlen\u00e9 zdroje by m\u011bly b\u00fdt v jednom souborov\u00e9m syst\u00e9mu.<\/li>\n<li>P\u0159i obnov\u011b datab\u00e1ze SQL Server ze sn\u00edmku na z\u00e1klad\u011b blok\u016f, pokud by m\u011bl instance SQL Server z\u016fstat p\u0159ipojen\u00fd, pou\u017eijte p\u0159ipojen\u00ed k hostiteli Unisphere. Pro obnovu na z\u00e1klad\u011b soubor\u016f se vytvo\u0159\u00ed dodate\u010dn\u00fd sd\u00edlen\u00fd zdroj SMB s pou\u017eit\u00edm sn\u00edmku jako zdroje. Po p\u0159ipojen\u00ed svazk\u016f lze datab\u00e1zi p\u0159ipojit pod jin\u00fdm n\u00e1zvem nebo nahradit st\u00e1vaj\u00edc\u00ed datab\u00e1zi obnovenou.<\/li>\n<\/ul>\n<p><\/p>\n<ul>\n<li>P\u0159i prov\u00e1d\u011bn\u00ed obnovy pomoc\u00ed metody obnovy moment\u00e1ln\u00edch sn\u00edmk\u016f Snapshot Restore v Unisphere p\u0159epn\u011bte instanci SQL Server do offline re\u017eimu. SQL Server nev\u00ed o operac\u00edch obnovy. P\u0159epnut\u00ed instance do offline re\u017eimu zaji\u0161\u0165uje, \u017ee svazky nebudou po\u0161kozeny p\u0159i operac\u00edch z\u00e1pisu do datab\u00e1ze p\u0159ed obnovou. Jakmile bude instance restartov\u00e1na, havarijn\u00ed obnova SQL Serveru p\u0159ivede datab\u00e1ze do konzistentn\u00edho stavu.<\/li>\n<li>Povolte okam\u017eit\u00e9 sn\u00edmky pro v\u00edce \u00falo\u017ei\u0161\u0165 sou\u010dasn\u011b a p\u0159ed aktivac\u00ed dal\u0161\u00edch sn\u00edmk\u016f se ujist\u011bte, \u017ee je syst\u00e9m v doporu\u010den\u00fdch pracovn\u00edch re\u017eimech.<\/li>\n<\/ul>\n<p><\/p>\n<h2>Automatizace a pl\u00e1nov\u00e1n\u00ed sn\u00edmk\u016f<\/h2>\n<p>\nOkam\u017eit\u00e9 sn\u00edmky v Unity XT lze automatizovat. V syst\u00e9mu pro spr\u00e1vu \u00falo\u017ei\u0161\u0165 Unisphere jsou k dispozici n\u00e1sleduj\u00edc\u00ed v\u00fdchoz\u00ed mo\u017enosti sn\u00edmk\u016f: ochrana podle v\u00fdchoz\u00edho nastaven\u00ed, ochrana s krat\u0161\u00edmi dobami uchov\u00e1v\u00e1n\u00ed a ochrana s del\u0161\u00edmi dobami uchov\u00e1v\u00e1n\u00ed. Ka\u017ed\u00e1 mo\u017enost vytv\u00e1\u0159\u00ed denn\u00ed sn\u00edmky a uchov\u00e1v\u00e1 je po r\u016fzn\u00fdch \u010dasov\u00fdch obdob\u00edch.<\/p>\n<p>Lze zvolit jednu (nebo ob\u011b) z mo\u017enost\u00ed pl\u00e1nov\u00e1n\u00ed \u2013 ka\u017ed\u00e9 x hodin (od 1 do 24) a denn\u011b\/t\u00fddn\u011b. Denn\u00ed\/t\u00fddenn\u00ed pl\u00e1nov\u00e1n\u00ed okam\u017eit\u00fdch sn\u00edmk\u016f umo\u017e\u0148uje specifikovat konkr\u00e9tn\u00ed \u010das a dny pro vytv\u00e1\u0159en\u00ed okam\u017eit\u00fdch sn\u00edmk\u016f. Pro ka\u017edou zvolenou mo\u017enost je t\u0159eba nastavit politiku uchov\u00e1v\u00e1n\u00ed, kter\u00e1 m\u016f\u017ee b\u00fdt nakonfigurov\u00e1na na automatick\u00e9 odstran\u011bn\u00ed z\u00e1sobn\u00edku nebo do\u010dasn\u00e9 uchov\u00e1v\u00e1n\u00ed.<\/p>\n<p>Dal\u0161\u00ed informace o sn\u00edmk\u00e1ch Unity \u2013 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\">dokumentaci k Dell EMC Unity<\/a><\/noindex>.\u00a0<\/p>\n<h2>Ten\u010d\u00edc\u00ed klony<\/h2>\n<p>\nTen\u010d\u00edc\u00ed klon je dostupn\u00e1 v re\u017eimu \u010dten\u00ed\/z\u00e1pisu kopie tenk\u00e9ho blokov\u00e9ho \u00falo\u017ei\u0161t\u011b, jako je svazek, konzistentn\u00ed skupina nebo datastore VMware VMFS, kter\u00e1 sd\u00edl\u00ed bloky s rodi\u010dovsk\u00fdm zdrojem. Ten\u010d\u00edc\u00ed klony jsou skv\u011bl\u00fd zp\u016fsob, jak rychle a kompaktn\u011b p\u0159edstavit kopie datab\u00e1ze SQL Server, co\u017e nelze dos\u00e1hnout tradi\u010dn\u00edmi n\u00e1stroji SQL Server. Jakmile je ten\u010d\u00edc\u00ed klon p\u0159edstaven hostiteli, lze svazky p\u0159ev\u00e9st do provozn\u00edho re\u017eimu (online) a datab\u00e1ze bude p\u0159ipojena pomoc\u00ed metody p\u0159ipojen\u00ed datab\u00e1ze v SQL Server.<\/p>\n<p>P\u0159i pou\u017e\u00edv\u00e1n\u00ed funkce aktualizace s tenk\u00fdmi klony deaktivujte (p\u0159eve\u010fte do offline re\u017eimu) v\u0161echny datab\u00e1ze, kter\u00e9 se nach\u00e1zej\u00ed na tenk\u00e9m klonu. To je t\u0159eba prov\u00e9st p\u0159ed operac\u00ed aktualizace. Pokud datab\u00e1ze nebudou p\u0159evedeny do offline re\u017eimu p\u0159ed proveden\u00edm aktualizace, mohlo by to v\u00e9st k chyb\u00e1m nesouladu dat nebo nespr\u00e1vn\u00fdm v\u00fdsledk\u016fm dat v SQL Server.<\/p>\n<h2>Replikace dat<\/h2>\n<p>\nReplika\u010dn\u00ed funkce je software, kter\u00fd synchronizuje data s vzd\u00e1len\u00fdm syst\u00e9mem na stejn\u00e9m objektu nebo na jin\u00e9m m\u00edst\u011b. Parametry replikace a konfigurace Unity umo\u017e\u0148uj\u00ed vybrat efektivn\u00ed zp\u016fsob spln\u011bn\u00ed po\u017eadavk\u016f RTO\/RPO pro datab\u00e1ze SQL Server, p\u0159i\u010dem\u017e zachov\u00e1vaj\u00ed rovnov\u00e1hu mezi v\u00fdkonem a propustnost\u00ed.<\/p>\n<p>P\u0159i pou\u017eit\u00ed replikace Dell EMC Unity k ochran\u011b datab\u00e1z\u00ed SQL Server na v\u00edce svazc\u00edch by m\u011bly b\u00fdt v\u0161echny data a svazky protokol\u016f datab\u00e1ze omezeny na jednu konzistentn\u00ed skupinu nebo souborov\u00fd syst\u00e9m. Pot\u00e9 se replikace nastav\u00ed ve skupin\u011b nebo souborov\u00e9m syst\u00e9mu a m\u016f\u017ee zahrnovat svazky nebo sd\u00edlen\u00e9 prost\u0159edky v\u00edce datab\u00e1z\u00ed. Datab\u00e1ze, kter\u00e9 vy\u017eaduj\u00ed r\u016fzn\u00e9 parametry replikace, by m\u011bly b\u00fdt um\u00edst\u011bny na samostatn\u00fdch LUN, konzistentn\u00edch skupin\u00e1ch nebo souborov\u00fdch syst\u00e9mech.<\/p>\n<p>Ten\u010d\u00ed klony jsou kompatibiln\u00ed jak se synchronn\u00ed, tak s asynchronn\u00ed replikac\u00ed. Kdy\u017e je tenk\u00fd klon replikov\u00e1n na c\u00edlov\u00e9 m\u00edsto, st\u00e1v\u00e1 se \u00faplnou kopi\u00ed svazku, konzistentn\u00ed skupiny nebo \u00falo\u017ei\u0161t\u011b VMFS. Po replikaci je tenk\u00fd klon zcela nez\u00e1visl\u00fdm svazkem se sv\u00fdmi vlastn\u00edmi nastaven\u00edmi. <\/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 replikace tenk\u00e9ho klonu mezi p\u016fvodn\u00edm a c\u00edlov\u00fdm syst\u00e9mem.<\/i><\/p>\n<p>Replikace datab\u00e1ze tempdb nen\u00ed nutn\u00e1, proto\u017ee soubor se p\u0159estavuje p\u0159i restartov\u00e1n\u00ed SQL Serveru, a proto metadata neodpov\u00eddaj\u00ed metod\u011b jin\u00fdch instanc\u00ed SQL Serveru. Pe\u010dliv\u00fd v\u00fdb\u011br svazk\u016f pro replikaci a obsahu t\u011bchto svazk\u016f odstra\u0148uje ne\u017e\u00e1douc\u00ed provoz replikace.<\/p>\n<h2>Integrovan\u00e9 \u0159\u00edzen\u00ed kop\u00edrov\u00e1n\u00ed dat Microsoft SQL Server<\/h2>\n<p>\nV\u011bt\u0161ina modern\u00edch produkt\u016f pro ukl\u00e1d\u00e1n\u00ed (v\u010detn\u011b v\u0161ech produkt\u016f Dell EMC) m\u016f\u017ee vytv\u00e1\u0159et \"s konzistentn\u00edm opera\u010dn\u00edm syst\u00e9mem\" kopie soubor\u016f jak\u00e9hokoli typu t\u00edmto zp\u016fsobem:<\/p>\n<ul>\n<li>Konzistentn\u00edm po\u0159ad\u00edm z\u00e1pisu opera\u010dn\u00edm syst\u00e9mem na v\u0161ech \u00farovn\u00edch \u2014 od hostitele po \u00falo\u017en\u00e9 za\u0159\u00edzen\u00ed.<\/li>\n<li>Skupinov\u00e1n\u00edm svazk\u016f, aby pro n\u011bkolik soubor\u016f na r\u016fzn\u00fdch svazc\u00edch byl zachov\u00e1n po\u0159\u00e1dek z\u00e1pisu.<\/li>\n<\/ul>\n<p>\nS \u0161irok\u00fdm roz\u0161\u00ed\u0159en\u00edm \u0161k\u00e1lovateln\u00fdch \u00falo\u017en\u00fdch za\u0159\u00edzen\u00ed v Microsoft vyvinuli API pro poskytovatele \u00falo\u017ei\u0161\u0165. Toto API umo\u017e\u0148uje poskytovatel\u016fm \u00falo\u017ei\u0161\u0165 koordinovat sv\u00e9 akce se softwarem datab\u00e1z\u00ed SQL Server pro vytv\u00e1\u0159en\u00ed \u201ekonzistentn\u00edch s aplikac\u00ed kopi\u00ed\u201c pomoc\u00ed slu\u017eby st\u00ednov\u00e9ho kop\u00edrov\u00e1n\u00ed objem\u016f (VSS). Tyto kopie simuluj\u00ed interakci SQL Serveru a opera\u010dn\u00edho syst\u00e9mu b\u011bhem pl\u00e1novan\u00e9 a vypnut\u00ed SQL Serveru. V\u0161echny z\u00e1znamov\u00e9 vyrovn\u00e1vac\u00ed pam\u011bti jsou vypr\u00e1zdn\u011bny a transakce jsou pozastaveny, dokud nejsou v\u0161echny disky aktualizov\u00e1ny a konzistentn\u00ed v ur\u010dit\u00e9m \u010dasov\u00e9m okam\u017eiku, kter\u00fd je zaznamen\u00e1n v protokolu SQL.<\/p>\n<p>Software Dell EMC AppSync, integrovan\u00fd s snapshoty Unity XT, zjednodu\u0161uje a automatizuje proces vytv\u00e1\u0159en\u00ed, pou\u017e\u00edv\u00e1n\u00ed a spr\u00e1vy konzistentn\u00edch s aplikac\u00ed kopi\u00ed pracovn\u00edch dat. Tento software je ur\u010den pro pou\u017eit\u00ed ve sc\u00e9n\u00e1\u0159\u00edch spr\u00e1vy kopi\u00ed pro obnovu datab\u00e1z\u00ed a jejich op\u011btovn\u00e9 pou\u017eit\u00ed.\u00a0<\/p>\n<p>Software AppSync automaticky detekuje datab\u00e1ze aplikac\u00ed, analyzuje strukturu datab\u00e1ze a zobrazuje strukturu soubor\u016f p\u0159es \u00farovn\u011b hardwaru nebo virtualizace do z\u00e1kladn\u00edho \u00falo\u017ei\u0161t\u011b Unity XT. Organizuje v\u0161echny pot\u0159ebn\u00e9 \u00fakony, od vytv\u00e1\u0159en\u00ed a ov\u011b\u0159ov\u00e1n\u00ed kopie po mont\u00e1\u017e snapshot\u016f na c\u00edlov\u00e9m hostiteli a spu\u0161t\u011bn\u00ed nebo obnovu datab\u00e1ze. AppSync podporuje a zjednodu\u0161uje pracovn\u00ed toky SQL Serveru, kter\u00e9 zahrnuj\u00ed aktualizaci a obnovu pracovn\u00ed datab\u00e1ze.<\/p>\n<h2>Sn\u00ed\u017een\u00ed objemu dat a roz\u0161\u00ed\u0159en\u00e1 deduplikace<\/h2>\n<p>\nRodina syst\u00e9m\u016f \u00falo\u017ei\u0161\u0165 dat Dell EMC Unity nab\u00edz\u00ed multifunk\u010dn\u00ed a snadno pou\u017eiteln\u00e9 slu\u017eby pro sni\u017eov\u00e1n\u00ed objemu dat. \u00daspora se dosahuje nejen na nastaven\u00fdch prim\u00e1rn\u00edch \u00falo\u017en\u00fdch zdroj\u00edch, ale tak\u00e9 na snapshoty a tenk\u00fdch clonech t\u011bchto zdroj\u016f. Snapshoty a tenk\u00e9 clony zd\u011bd\u00ed nastaven\u00ed sni\u017eov\u00e1n\u00ed objemu dat p\u016fvodn\u00edho \u00falo\u017ei\u0161t\u011b, co\u017e zvy\u0161uje \u00fasporu kapacity.<\/p>\n<p>Funkce zmen\u0161en\u00ed objemu dat zahrnuje akce deduplikace, komprese a detekce nulov\u00fdch blok\u016f, co\u017e potenci\u00e1ln\u011b zvy\u0161uje objem u\u017eite\u010dn\u00e9ho \u00falo\u017en\u00e9ho prostoru pro u\u017eivatelsk\u00e9 objekty a intern\u00ed pou\u017eit\u00ed. Funkce zmen\u0161en\u00ed objemu dat Unity XT nahrazuje funkci komprese v Unity OE 4.3 a nov\u011bj\u0161\u00edch verz\u00edch. Komprese je algoritmus zmen\u0161en\u00ed dat, kter\u00fd m\u016f\u017ee sn\u00ed\u017eit fyzick\u00e9 rozlo\u017een\u00ed kapacity pot\u0159ebn\u00e9 pro uchov\u00e1n\u00ed datov\u00e9 sady.<\/p>\n<p>Syst\u00e9my Unity XT tak\u00e9 poskytuj\u00ed roz\u0161\u00ed\u0159enou funkci deduplikace, kterou lze aktivovat, pokud je povoleno zmen\u0161en\u00ed objemu dat. Roz\u0161\u00ed\u0159en\u00e1 deduplikace sni\u017euje kapacitu pot\u0159ebnou pro u\u017eivatelsk\u00e1 data, uchov\u00e1vaj\u00edc\u00ed pouze mal\u00e9 mno\u017estv\u00ed kopi\u00ed (\u010dasto jen jednu kopii) blok\u016f dat Unity. Oblast deduplikace je jeden LUN. M\u011bjte to na pam\u011bti p\u0159i v\u00fdb\u011bru \u00falo\u017en\u00e9ho sch\u00e9matu. Men\u0161\u00ed po\u010det LUN vede k lep\u0161\u00ed deduplikaci, ale v\u011bt\u0161\u00ed po\u010det LUN zaji\u0161\u0165uje vy\u0161\u0161\u00ed v\u00fdkon.\u00a0<\/p>\n<p>\u00daspora kapacity d\u00edky roz\u0161\u00ed\u0159en\u00e9 deduplikaci m\u016f\u017ee p\u0159in\u00e9st nejv\u011bt\u0161\u00ed n\u00e1vratnost v v\u011bt\u0161in\u011b prost\u0159ed\u00ed, ale tak\u00e9 vy\u017eaduje vyu\u017eit\u00ed zdroj\u016f procesor\u016f syst\u00e9mu Unity. Ve verzi OE 5.0 roz\u0161\u00ed\u0159en\u00e1 deduplikace, pokud je aktivov\u00e1na, deduplikuje jak\u00fdkoli blok (komprimovan\u00fd nebo nekomprimovan\u00fd). Dal\u0161\u00ed informace naleznete v <noindex><a rel=\"nofollow\" href=\"https:\/\/www.emc.com\/collateral\/white-papers\/h15571-dell-emc-unity-compression.pdf\">dokumentaci Dell EMC<\/a><\/noindex>.<\/p>\n<p>V n\u00e1sleduj\u00edc\u00ed tabulce jsou uvedeny podporovan\u00e9 konfigurace pro zmen\u0161en\u00ed objemu dat a roz\u0161\u00ed\u0159enou deduplikaci:<\/p>\n<h2>Zmen\u0161en\u00ed objemu dat v Unity (v\u0161echny modely) a roz\u0161\u00ed\u0159en\u00e1 podpora deduplikace<\/h2>\n<p><\/p>\n<p>Verze Unity OE\u00a0<\/p>\n<p>Technologie\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\u0161en\u00ed objemu dat\u00a0<\/p>\n<p>Pool flash pam\u011bti \u2013 tradi\u010dn\u00ed nebo 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\u0161en\u00ed objemu dat\u00a0<\/p>\n<p>300, 400, 500, 600, 300F, 400F, 500F, 600F, 350F, 450F, 550F, 650F\u00a0<\/p>\n<p>Zmen\u0161en\u00ed objemu dat a roz\u0161\u00ed\u0159en\u00e1 deduplikace*<\/p>\n<p>450F, 550F, 650F\u00a0<\/p>\n<p>5\u00a0<br \/>\n\u00a0<\/p>\n<p>Zmen\u0161en\u00ed objemu dat\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>Sn\u00ed\u017een\u00ed objemu dat a roz\u0161\u00ed\u0159en\u00e1 deduplikace<\/p>\n<p>450F, 550F, 650F, 380, 480, 680, 880, 380F, 480F, 680F, 880F<\/p>\n<p><i> * Zmen\u0161en\u00ed objemu dat je ve v\u00fdchoz\u00edm nastaven\u00ed vypnuto a mus\u00ed b\u00fdt povoleno, ne\u017e se stane roz\u0161\u00ed\u0159en\u00e1 deduplikace dostupnou volbou. Po zapnut\u00ed zmen\u0161en\u00ed objemu dat je roz\u0161\u00ed\u0159en\u00e1 deduplikace dostupn\u00e1, ale ve v\u00fdchoz\u00edm nastaven\u00ed je vypnuta.<\/i><\/p>\n<h2>Zmen\u0161en\u00ed objemu dat v Unity a komprese dat v SQL Server<\/h2>\n<p>\nVerze SQL Server 2008 Enterprise Edition byla prvn\u00edm vyd\u00e1n\u00edm s vlastn\u00edmi schopnostmi komprese dat. P\u0159i kompresi na \u00farovni \u0159\u00e1dk\u016f a str\u00e1nek SQL Server 2008 vyu\u017e\u00edv\u00e1 znalosti form\u00e1tu tabulky intern\u00ed datab\u00e1ze SQL Server k redukci prostoru, kter\u00fd objekty datab\u00e1ze zab\u00edraj\u00ed. Sn\u00ed\u017een\u00ed prostoru umo\u017e\u0148uje ulo\u017eit v\u00edce \u0159\u00e1dk\u016f na str\u00e1nce a v\u00edce str\u00e1nek v bufferov\u00e9m poolu. Jeliko\u017e data, kter\u00e1 nejsou ulo\u017eena ve form\u00e1tu str\u00e1nek o velikosti 8k, jako nap\u0159\u00edklad data mimo \u0159\u00e1dky, jako je NVARCHAR (MAX), nebudou vyu\u017e\u00edvat metody komprese \u0159\u00e1dk\u016f nebo str\u00e1nek, Microsoft uvedl funkce Transact-SQL COMPRESS a DECOMPRESS.\u00a0<\/p>\n<p>Tyto funkce vyu\u017e\u00edvaj\u00ed tradi\u010dn\u00ed p\u0159\u00edstup k kompresi dat (algoritmus GZIP), kter\u00fd je pot\u0159eba vyvolat pro ka\u017edou \u010d\u00e1st dat pro kompresi nebo dekompresi.<\/p>\n<p>Kompresn\u00ed technologie Unity XT, kter\u00e1 nen\u00ed v\u00fdhradn\u011b ur\u010dena pro SQL Server, pou\u017e\u00edv\u00e1 softwarov\u00fd algoritmus ke anal\u00fdze a kompresi dat \u00falo\u017ei\u0161t\u011b. Od vyd\u00e1n\u00ed Unity OE 4.1 byla komprese dat Unity dostupn\u00e1 pro svazky blokov\u00fdch \u00falo\u017ei\u0161\u0165 a \u00falo\u017ei\u0161t\u011b dat VMFS v poolu s flash pam\u011bt\u00ed. Od Unity OE 4.2 je komprese tak\u00e9 k dispozici pro souborov\u00e9 syst\u00e9my a \u00falo\u017ei\u0161t\u011b dat NFS v poolu \u00falo\u017ei\u0161\u0165 na flash za\u0159\u00edzen\u00edch.<\/p>\n<p>V\u00fdb\u011br metody komprese dat pro SQL Server z\u00e1vis\u00ed na n\u011bkolika faktorech. K t\u011bmto faktor\u016fm pat\u0159\u00ed typ obsahu datab\u00e1ze, dostupn\u00e9 zdroje CPU \u2014 jak na \u00falo\u017ei\u0161t\u00edch, tak na serverech datab\u00e1ze, a tak\u00e9 zdroje vstupu a v\u00fdstupu pot\u0159ebn\u00e9 k udr\u017een\u00ed SLA. Obecn\u011b lze o\u010dek\u00e1vat dodate\u010dn\u00e9 \u00faspory m\u00edsta pro data, kter\u00e1 jsou komprimov\u00e1na prost\u0159edky SQL Server, av\u0161ak data komprimovan\u00e1 pomoc\u00ed funkce TSQL s vyu\u017eit\u00edm algoritmu GZIP pravd\u011bpodobn\u011b nedos\u00e1hnou v\u00fdznamn\u00e9ho dodate\u010dn\u00e9ho zkr\u00e1cen\u00ed objemu pomoc\u00ed funkc\u00ed komprese Unity XT, proto\u017ee v\u011bt\u0161inu v\u00fdhod p\u0159in\u00e1\u0161\u00ed prvn\u00ed aplikovan\u00fd univerz\u00e1ln\u00ed algoritmus.<\/p>\n<p>Kompresn\u00ed technologie Unity zaji\u0161\u0165uje \u00fasporu m\u00edsta, pokud jsou data na objektu \u00falo\u017ei\u0161t\u011b komprimov\u00e1na alespo\u0148 o 25 %. Ne\u017e zapnete kompresi pro objekt \u00falo\u017ei\u0161t\u011b, zjist\u011bte, zda obsahuje data, kter\u00e1 lze komprimovat. Nezap\u00ednejte kompresi pro objekt \u00falo\u017ei\u0161t\u011b, pokud to nep\u0159inese \u00fasporu kapacity.\u00a0<\/p>\n<p>P\u0159i rozhodov\u00e1n\u00ed, zda pou\u017e\u00edt zmen\u0161en\u00ed objemu dat Unity, kompresi na \u00farovni datab\u00e1ze SQL Server nebo oboj\u00ed, vezm\u011bte v \u00favahu n\u00e1sleduj\u00edc\u00ed:<\/p>\n<ul>\n<li>Data, kter\u00e1 jsou zaznamen\u00e1na v syst\u00e9mu Unity, jsou potvrzena hostitelem po jejich ulo\u017een\u00ed do syst\u00e9mov\u00e9 cache. Proces komprese v\u0161ak nen\u00ed zah\u00e1jen, dokud nen\u00ed cache vy\u010di\u0161t\u011bna.<\/li>\n<\/ul>\n<p><\/p>\n<ul>\n<li>\u00daspora z komprese se dosahuje nejen pro \u00falo\u017ei\u0161t\u011b Unity XT, ale tak\u00e9 pro snapshoty a tenk\u00e9 klony zdroje.<\/li>\n<li>B\u011bhem procesu komprese se n\u011bkolik blok\u016f agreguje pomoc\u00ed v\u00fdb\u011brov\u00e9ho algoritmu, aby se ur\u010dilo, zda mohou b\u00fdt data komprimov\u00e1na. Pokud v\u00fdb\u011brov\u00fd algoritmus zjist\u00ed, \u017ee lze dos\u00e1hnout pouze minim\u00e1ln\u00ed \u00faspory, komprese se p\u0159esko\u010d\u00ed a data se zap\u00ed\u0161\u00ed do poolu.<\/li>\n<li>Kdy\u017e se data komprimuj\u00ed p\u0159ed z\u00e1pisem na m\u00e9dium, objem operac\u00ed s nimi se v\u00fdrazn\u011b sni\u017euje. Komprese tedy pom\u00e1h\u00e1 sn\u00ed\u017eit opot\u0159eben\u00ed flash pam\u011bti t\u00edm, \u017ee zmen\u0161uje fyzick\u00fd objem dat zapisovan\u00fdch na \u00falo\u017ei\u0161t\u011b.<\/li>\n<\/ul>\n<p>\nDal\u0161\u00ed informace o kompresi \u0159\u00e1dk\u016f a str\u00e1nek v SQL Serveru pro tabulky a indexy najdete v <noindex><a rel=\"nofollow\" href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/data-compression\/data-compression\">dokumentech Microsoft<\/a><\/noindex>.<\/p>\n<p>Nezapom\u00ednejte, \u017ee pro jakoukoli kompresi jsou pot\u0159eba procesorov\u00e9 zdroje. P\u0159i vysok\u00fdch po\u017eadavc\u00edch na propustnost m\u016f\u017ee komprese m\u00edt znateln\u00fd dopad na v\u00fdkon. Vysok\u00e9 pom\u011bry z\u00e1pisu pracovn\u00edch z\u00e1t\u011b\u017e\u00ed OLAP tak\u00e9 mohou sn\u00ed\u017eit v\u00fdhody komprese pro datab\u00e1zi SQL Server.<\/p>\n<p>Experti Dell EMC prozkoumali potenci\u00e1ln\u00ed \u00fasporu p\u0159i pou\u017e\u00edv\u00e1n\u00ed skute\u010dn\u00fdch pom\u011br\u016f zmen\u0161en\u00ed dat v syst\u00e9mu Unity. Skupina shrom\u00e1\u017edila data o virtu\u00e1ln\u00edch stroj\u00edch VMware, sd\u00edlen\u00ed soubor\u016f, datab\u00e1z\u00edch SQL Server, virtu\u00e1ln\u00edch stroj\u00edch Microsoft Hyper-V atd.<\/p>\n<p>V\u00fdsledky studie uk\u00e1zaly, \u017ee zmen\u0161en\u00ed objemu souboru protokolu SQL Server je t\u00e9m\u011b\u0159 10kr\u00e1t men\u0161\u00ed ne\u017e souboru dat:<\/p>\n<ul>\n<li>Objem datab\u00e1ze = 1,49: 1 (32,96%)<\/li>\n<li>Objem protokol\u016f = 12,9: 1 (92,25%)<\/li>\n<\/ul>\n<p>\nDatab\u00e1ze SQL Server byla vybavena dv\u011bma svazky. Soubory datab\u00e1ze jsou ulo\u017eeny na jednom svazku, zat\u00edmco transak\u010dn\u00ed protokoly na druh\u00e9m. Pou\u017eit\u00ed technologie zmen\u0161ov\u00e1n\u00ed dat u datab\u00e1zov\u00fdch svazk\u016f m\u016f\u017ee p\u0159in\u00e9st \u00fasporu \u00falo\u017en\u00e9ho prostoru; je v\u0161ak t\u0159eba zohlednit dopad na v\u00fdkon p\u0159i rozhodov\u00e1n\u00ed, zda zahrnout deduplika\u010dn\u00ed funkce na datab\u00e1zov\u00e9 svazky. A\u010dkoli skute\u010dn\u00e9 zmen\u0161en\u00ed objemu datab\u00e1ze m\u016f\u017ee kol\u00edsat v z\u00e1vislosti na ukl\u00e1dan\u00fdch datech, v\u00fdsledky v\u00fdzkumu uk\u00e1zaly, \u017ee prostor pro ukl\u00e1d\u00e1n\u00ed SQL Server transak\u010dn\u00edch protokol\u016f m\u016f\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\">b\u00fdt v\u00fdrazn\u011b sn\u00ed\u017een<\/a><\/noindex>.<\/p>\n<h2>Nejlep\u0161\u00ed postupy pro zmen\u0161ov\u00e1n\u00ed objemu dat<\/h2>\n<p>\nP\u0159ed zapnut\u00edm zmen\u0161ov\u00e1n\u00ed dat na \u00falo\u017ei\u0161ti zva\u017ete n\u00e1sleduj\u00edc\u00ed doporu\u010den\u00ed:<\/p>\n<ul>\n<li>Pou\u017e\u00edvejte monitorovac\u00ed syst\u00e9m \u00falo\u017ei\u0161t\u011b, abyste se ujistili, \u017ee m\u00e1 dostate\u010dn\u00e9 zdroje na podporu zmen\u0161ov\u00e1n\u00ed objemu dat.<\/li>\n<li>Povolte zmen\u0161ov\u00e1n\u00ed objemu dat pro v\u00edce \u00falo\u017ei\u0161\u0165 sou\u010dasn\u011b. P\u0159ed jeho zapnut\u00edm na dal\u0161\u00edch \u00falo\u017ei\u0161t\u00edch sledujte syst\u00e9m, abyste se ujistili, \u017ee je v doporu\u010den\u00fdch pracovn\u00edch re\u017eimech.<\/li>\n<li>V modelech Unity XT x80F zmen\u0161en\u00ed objemu dat zajist\u00ed \u00fasporu kapacity, pokud jsou data ve svazku \u00falo\u017ei\u0161t\u011b komprimov\u00e1na alespo\u0148 o 1%.<\/li>\n<\/ul>\n<p>\nZmen\u0161en\u00ed objemu dat u p\u0159edchoz\u00edch model\u016f Unity x80F b\u011b\u017e\u00edc\u00edch pod OE 5.0 zaji\u0161\u0165ovalo \u00fasporu, pokud byla data komprimovateln\u00e1 alespo\u0148 o 25%.<\/p>\n<ul>\n<li>P\u0159ed zapnut\u00edm zmen\u0161ov\u00e1n\u00ed objemu dat na \u00falo\u017ei\u0161ti ur\u010dete, zda objekt obsahuje komprimovateln\u00e1 data. Ur\u010dit\u00e9 typy dat, jako jsou video, audio, obr\u00e1zky a bin\u00e1rn\u00ed data, obvykle p\u0159in\u00e1\u0161ej\u00ed mal\u00fd u\u017eitek z komprese. Nezap\u00ednejte zmen\u0161en\u00ed objemu dat na \u00falo\u017ei\u0161ti, pokud nedojde k \u00faspo\u0159e m\u00edsta.<\/li>\n<li>Zva\u017ete mo\u017enost selektivn\u00edho zmen\u0161en\u00ed objemu souborov\u00e9ho svazku, kter\u00fd je obvykle dob\u0159e komprimovateln\u00fd.<\/li>\n<\/ul>\n<p><\/p>\n<h2>Virtualizace VMware<\/h2>\n<p>\nVMware vSphere je efektivn\u00ed a bezpe\u010dn\u00e1 platforma pro virtualizaci a cloudov\u00e9 prost\u0159ed\u00ed. Hlavn\u00edmi komponenty vSphere jsou VMware vCenter Server a hypervisor VMware ESXi.<\/p>\n<p>vCenter Server \u2014 unifikovan\u00e1 platforma pro spr\u00e1vu prost\u0159ed\u00ed vSphere. Vyzna\u010duje se jednoduchost\u00ed nasazen\u00ed a proaktivn\u00ed optimalizac\u00ed zdroj\u016f. ESXi je hypervisor s otev\u0159en\u00fdm zdrojov\u00fdm k\u00f3dem, kter\u00fd je nainstalov\u00e1n p\u0159\u00edmo na fyzick\u00e9 servery. ESXi m\u00e1 p\u0159\u00edm\u00fd p\u0159\u00edstup k z\u00e1kladn\u00edm zdroj\u016fm a malou velikost 150 MB, co\u017e minimalizuje po\u017eadavky na pam\u011b\u0165. Zaji\u0161\u0165uje spolehliv\u00fd v\u00fdkon pro r\u016fzn\u00e9 pracovn\u00ed z\u00e1t\u011b\u017ee aplikac\u00ed a podporuje v\u00fdkonn\u00e9 konfigurace virtu\u00e1ln\u00edch stroj\u016f \u2013 a\u017e 128 virtu\u00e1ln\u00edch CPU, 6 TB RAM a 120 za\u0159\u00edzen\u00ed.<\/p>\n<p>Aby SQL Server efektivn\u011b pracoval na modern\u00edm hardwaru, opera\u010dn\u00ed syst\u00e9m SQL Server (SQLOS) mus\u00ed \"ch\u00e1pat\" strukturu hardwaru. S p\u0159\u00edchodem multij\u00e1drov\u00fdch a v\u00edcerozlov\u00fdch syst\u00e9m\u016f s nehomogenn\u00edm p\u0159\u00edstupem k pam\u011bti (NUMA) se stalo zvl\u00e1\u0161\u0165 d\u016fle\u017eit\u00e9 porozum\u011bt vztah\u016fm mezi j\u00e1dry, logick\u00fdmi a fyzick\u00fdmi procesory.<\/p>\n<h2>Procesory\u00a0<\/h2>\n<p>\nVirtu\u00e1ln\u00ed procesor (vCPU) je virtu\u00e1ln\u00ed centr\u00e1ln\u00ed procesor p\u0159id\u011blen\u00fd virtu\u00e1ln\u00edmu stroji. Celkov\u00fd po\u010det p\u0159id\u011blen\u00fdch virtu\u00e1ln\u00edch CPU se po\u010d\u00edt\u00e1 takto:<\/p>\n<pre><code class=\"plaintext\">Celkov\u00e9 vCPU = (po\u010det virtu\u00e1ln\u00edch soket\u016f) * (po\u010det virtu\u00e1ln\u00edch jader na soket)<\/code><\/pre>\n<p>\nPokud je d\u016fle\u017eit\u00fd stabiln\u00ed v\u00fdkon, VMware doporu\u010duje, aby celkov\u00fd po\u010det virtu\u00e1ln\u00edch CPU p\u0159id\u011blen\u00fdch v\u0161em virtu\u00e1ln\u00edm stroj\u016fm nep\u0159esahoval celkov\u00fd po\u010det fyzick\u00fdch jader dostupn\u00fdch na hostiteli ESXi, ale je mo\u017en\u00e9 zv\u00fd\u0161it po\u010det p\u0159id\u011blen\u00fdch virtu\u00e1ln\u00edch CPU, pokud monitorov\u00e1n\u00ed ukazuje, \u017ee jsou k dispozici nevyu\u017eit\u00e9 CPU zdroje.<\/p>\n<p>V syst\u00e9mech se zapnutou technologi\u00ed Intel Hyper-Threading je po\u010det logick\u00fdch jader (vCPU) dvakr\u00e1t vy\u0161\u0161\u00ed ne\u017e po\u010det fyzick\u00fdch jader. V takov\u00e9m p\u0159\u00edpad\u011b nep\u0159i\u0159azujte celkov\u00fd po\u010det virtu\u00e1ln\u00edch CPU.<\/p>\n<p>Na pracovn\u00ed zat\u00ed\u017een\u00ed SQL Server na ni\u017e\u0161\u00ed \u00farovni m\u00e9n\u011b p\u016fsob\u00ed prom\u011bnlivost latence. Tyto pracovn\u00ed zat\u00ed\u017een\u00ed tedy mohou b\u00fdt provozov\u00e1ny na hostitel\u00edch s vy\u0161\u0161\u00edm pom\u011brem virtu\u00e1ln\u00edch CPU k fyzick\u00fdm. Rozumn\u00e9 \u00farovn\u011b zat\u00ed\u017een\u00ed CPU mohou zv\u00fd\u0161it celkovou propustnost syst\u00e9mu, maxim\u00e1ln\u011b u\u0161et\u0159it licence a zachovat adekv\u00e1tn\u00ed v\u00fdkon.<\/p>\n<p>Intel Hyper-Threading obvykle zvy\u0161uje celkovou propustnost hostitele o 10\u201330 %, co\u017e nazna\u010duje pom\u011br virtu\u00e1ln\u00edch CPU k fyzick\u00fdm procesor\u016fm od 1,1 do 1,3. VMware doporu\u010duje aktivovat Hyper-Threading v BIOSu UEFI, pokud je to mo\u017en\u00e9, aby ESXi mohl vyu\u017e\u00edvat v\u00fdhody t\u00e9to technologie. Tak\u00e9 VMware doporu\u010duje prov\u00e1d\u011bt pe\u010dliv\u00e9 testov\u00e1n\u00ed a monitorov\u00e1n\u00ed p\u0159i pou\u017e\u00edv\u00e1n\u00ed Hyper-Threading pro pracovn\u00ed z\u00e1t\u011b\u017ee SQL Server.<\/p>\n<h2>Pam\u011b\u0165<\/h2>\n<p>\nT\u00e9m\u011b\u0159 v\u0161echny modern\u00ed servery pou\u017e\u00edvaj\u00ed pro komunikaci mezi hlavn\u00ed pam\u011bt\u00ed a procesory architekturu s nehomogenn\u00edm p\u0159\u00edstupem k pam\u011bti (NUMA). NUMA je hardwarov\u00e1 architektura pro sd\u00edlenou pam\u011b\u0165, kter\u00e1 realizuje odd\u011blen\u00e9 bloky fyzick\u00e9 pam\u011bti mezi fyzick\u00fdmi procesory. Uzlem NUMA je jeden nebo n\u011bkolik socket\u016f CPU spolu s blokem vyhrazen\u00e9 pam\u011bti.\u00a0<\/p>\n<p>V pr\u016fb\u011bhu posledn\u00edho desetilet\u00ed byla NUMA \u0161iroce diskutovan\u00fdm t\u00e9matem. Relativn\u00ed slo\u017eitost NUMA je zp\u016fsobena \u010d\u00e1ste\u010dn\u011b implementacemi od r\u016fzn\u00fdch dodavatel\u016f. V virtualizovan\u00fdch prost\u0159ed\u00edch slo\u017eitost NUMA tak\u00e9 ur\u010duje po\u010det konfigura\u010dn\u00edch parametr\u016f a \u00farovn\u00ed \u2014 od hardwaru p\u0159es hypervizor a\u017e po hostitelsk\u00fd opera\u010dn\u00ed syst\u00e9m a nakonec aplikaci SQL Server. Dobr\u00fd p\u0159ehled o hardwarov\u00e9 architektu\u0159e NUMA je nezbytn\u00fdm po\u017eadavkem pro ka\u017ed\u00e9ho administr\u00e1tora datab\u00e1ze SQL Server, kter\u00fd pracuje s virtualizovan\u00fdm instanc\u00ed SQL Server.<\/p>\n<p>Pro dosa\u017een\u00ed v\u011bt\u0161\u00ed efektivity na serverech s velk\u00fdm po\u010dtem jader p\u0159edstavila spole\u010dnost Microsoft SoftNUMA. Software SoftNUMA umo\u017e\u0148uje rozd\u011blovat dostupn\u00e9 zdroje CPU v r\u00e1mci jedn\u00e9 NUMA na n\u011bkolik uzl\u016f SoftNUMA. Podle spole\u010dnosti VMware je SoftNUMA kompatibiln\u00ed s topologi\u00ed virtu\u00e1ln\u00ed NUMA (vNUMA) VMware a m\u016f\u017ee d\u00e1le optimalizovat \u0161k\u00e1lovatelnost a v\u00fdkon datab\u00e1zov\u00e9ho enginu pro v\u011bt\u0161inu pracovn\u00edch z\u00e1t\u011b\u017e\u00ed\u2026<\/p>\n<p>P\u0159i virtualizaci VMware se SQL Serverem pou\u017e\u00edvejte:<\/p>\n<ul>\n<li>Monitorov\u00e1n\u00ed virtu\u00e1ln\u00edch stroj\u016f k odhalen\u00ed nedostatku pam\u011b\u0165ov\u00fdch zdroj\u016f pro SQL Server Database Engine. Tento probl\u00e9m vede ke zv\u00fd\u0161en\u00ed operac\u00ed vstupu a v\u00fdstupu a sn\u00ed\u017een\u00ed v\u00fdkonu.<\/li>\n<\/ul>\n<p><\/p>\n<ul>\n<li>Pro zv\u00fd\u0161en\u00ed v\u00fdkonu zabra\u0148te konflikt\u016fm v pam\u011bti mezi virtu\u00e1ln\u00edmi stroji t\u00edm, \u017ee se vyhnete nadm\u011brn\u00e9mu zat\u00ed\u017een\u00ed pam\u011bti na \u00farovni hostitele ESXi.<\/li>\n<li>Zva\u017ete kontrolu hardwarov\u00e9ho p\u0159id\u011blen\u00ed fyzick\u00e9 pam\u011bti NUMA, abyste zjistili maxim\u00e1ln\u00ed mno\u017estv\u00ed pam\u011bti, kter\u00e9 m\u016f\u017ee b\u00fdt p\u0159id\u011bleno virtu\u00e1ln\u00edmu stroji v fyzick\u00fdch mez\u00edch NUMA.<\/li>\n<li>Pokud je dosa\u017een\u00ed adekv\u00e1tn\u00edho v\u00fdkonu hlavn\u00edm c\u00edlem, zva\u017ete rezervaci pam\u011bti, kter\u00e1 odpov\u00edd\u00e1 p\u0159id\u011blen\u00e9 pam\u011bti. Toto nastaven\u00ed parametr\u016f zaru\u010duje, \u017ee virtu\u00e1ln\u00ed stroj z\u00edsk\u00e1v\u00e1 pouze fyzickou pam\u011b\u0165.<\/li>\n<\/ul>\n<p><\/p>\n<h2>Virtualizovan\u00e9 \u00falo\u017ei\u0161t\u011b<\/h2>\n<p>\nNastaven\u00ed \u00falo\u017ei\u0161t\u011b ve virtualizovan\u00e9m prost\u0159ed\u00ed vy\u017eaduje znalost infrastruktury SAN. Stejn\u011b jako u NUMA je t\u0159eba rozum\u011bt fungov\u00e1n\u00ed r\u016fzn\u00fdch \u00farovn\u00ed vstupn\u011b-v\u00fdstupn\u00edch operac\u00ed \u2014 v tomto p\u0159\u00edpad\u011b od aplikace ve VM p\u0159es fyzick\u00e9 \u010dten\u00ed a z\u00e1pis informac\u00ed na trval\u00e9m \u00falo\u017ei\u0161ti.<\/p>\n<p>vSphere poskytuje \u0159adu mo\u017enost\u00ed pro nastaven\u00ed \u00falo\u017ei\u0161t\u011b, kter\u00e9 maj\u00ed u\u017eite\u010dn\u00e9 aplikace p\u0159i implementaci SQL Serveru s polem Unity XT. FS VMFS je nejpou\u017e\u00edvan\u011bj\u0161\u00ed metodou ukl\u00e1d\u00e1n\u00ed dat v blokov\u00fdch \u00falo\u017ei\u0161t\u00edch, jako je Unity XT. Pole Unity XT je spodn\u00ed \u00farove\u0148 slo\u017een\u00e1 z fyzick\u00fdch disk\u016f, kter\u00e9 vSphere p\u0159edstavuje jako logick\u00e9 disky (svazky). Svazky Unity XT jsou form\u00e1tov\u00e1ny jako svazky VMFS hypervizorem ESXi. Spr\u00e1vci VMware vytv\u00e1\u0159ej\u00ed jeden nebo v\u00edce virtu\u00e1ln\u00edch disk\u016f (VMDK), kter\u00e9 jsou prezentov\u00e1ny hostitelsk\u00e9mu opera\u010dn\u00edmu syst\u00e9mu. RDM umo\u017e\u0148uje virtu\u00e1ln\u00edmu stroji p\u0159\u00edmo p\u0159istupovat k blokov\u00e9mu \u00falo\u017ei\u0161ti (p\u0159es FC nebo iSCSI) Unity XT bez form\u00e1tov\u00e1n\u00ed VMFS. Svazky VMFS a RDM mohou poskytovat stejnou propustnost transakc\u00ed.\u00a0<\/p>\n<p>Pro \u00falo\u017ei\u0161t\u011b zalo\u017een\u00e9 na NFS pro ESXi doporu\u010duje Dell EMC pou\u017e\u00edvat VMware NFS m\u00edsto obecn\u00fdch souborov\u00fdch syst\u00e9m\u016f NFS. Virtu\u00e1ln\u00ed stroj b\u011b\u017e\u00edc\u00ed na SQL Serveru a pou\u017e\u00edvaj\u00edc\u00ed VMDK v \u00falo\u017ei\u0161t\u011b dat NFS nen\u00ed informov\u00e1n o spodn\u00ed vrstv\u011b NFS. Hostitelsk\u00fd opera\u010dn\u00ed syst\u00e9m vid\u00ed virtu\u00e1ln\u00ed stroj jako fyzick\u00fd server b\u011b\u017e\u00edc\u00ed pod Windows Serverem a SQL Serverem. Sd\u00edlen\u00e9 disky pro konfigurace instance odoln\u00e9 v\u016f\u010di v\u00fdpadku v \u00falo\u017ei\u0161t\u00edch dat NFS nejsou podporov\u00e1ny.<\/p>\n<p>Virtu\u00e1ln\u00ed objemy VMware vSphere (VVols) nab\u00edzej\u00ed jemn\u011bj\u0161\u00ed spr\u00e1vu na \u00farovni virtu\u00e1ln\u00edho stroje, nez\u00e1visle na z\u00e1kladn\u00edm zobrazen\u00ed fyzick\u00e9 pam\u011bti (nap\u0159\u00edklad objem\u016f nebo souborov\u00fdch syst\u00e9m\u016f). Replikace zalo\u017een\u00e1 na poli s VVols je podporov\u00e1na od VVol 2.0 (vSphere 6.5). Disk VVol lze pou\u017e\u00edvat m\u00edsto disku RDM pro poskytov\u00e1n\u00ed diskov\u00fdch zdroj\u016f instanci odoln\u00e9ho clusteru SQL, po\u010d\u00ednaje vSphere 6.7, s podporou trval\u00e9ho rezervov\u00e1n\u00ed pomoc\u00ed SCSI.<\/p>\n<h2>Virtualizovan\u00e9 s\u00edt\u011b<\/h2>\n<p>\nS\u00ed\u0165 ve virtu\u00e1ln\u00edm sv\u011bt\u011b sleduje ty sam\u00e9 logick\u00e9 koncepty jako ve fyzick\u00e9m sv\u011bt\u011b, ale pou\u017e\u00edv\u00e1 software m\u00edsto fyzick\u00fdch kabel\u016f a p\u0159ep\u00edna\u010d\u016f. Vliv latence s\u00edt\u011b na pracovn\u00ed z\u00e1t\u011b\u017ee SQL Serveru m\u016f\u017ee b\u00fdt zna\u010dn\u011b odli\u0161n\u00fd. Monitorov\u00e1n\u00ed ukazatel\u016f v\u00fdkonu s\u00edt\u011b na st\u00e1vaj\u00edc\u00ed pracovn\u00ed z\u00e1t\u011b\u017ei nebo dob\u0159e realizovan\u00e9m testovac\u00edm syst\u00e9mu v pr\u016fb\u011bhu reprezentativn\u00edho obdob\u00ed pom\u00e1h\u00e1 p\u0159i vytv\u00e1\u0159en\u00ed virtu\u00e1ln\u00ed s\u00edt\u011b.<\/p>\n<p>P\u0159i pou\u017e\u00edv\u00e1n\u00ed virtualizace VMware se SQL Serverem je t\u0159eba vz\u00edt v \u00favahu n\u00e1sleduj\u00edc\u00ed:<\/p>\n<ul>\n<li>Jak standardn\u00ed, tak distribuovan\u00e9 virtu\u00e1ln\u00ed p\u0159ep\u00edna\u010de poskytuj\u00ed pot\u0159ebn\u00e9 funkce pro SQL Server.<\/li>\n<li>Pro logick\u00e9 odd\u011blen\u00ed provozu spr\u00e1vy, vSphere vMotion a s\u00ed\u0165ov\u00e9ho \u00falo\u017ei\u0161t\u011b pou\u017e\u00edvejte ozna\u010dov\u00e1n\u00ed VLAN a skupiny port\u016f virtu\u00e1ln\u00edho p\u0159ep\u00edna\u010de.<\/li>\n<li>VMware d\u016frazn\u011b doporu\u010duje povolit velk\u00e9 r\u00e1mce na virtu\u00e1ln\u00edch p\u0159ep\u00edna\u010d\u00edch, kde je povolen provoz vSphere vMotion nebo iSCSI.<\/li>\n<li>Obecn\u011b dodr\u017eujte s\u00ed\u0165ov\u00e1 doporu\u010den\u00ed pro hostitelsk\u00e9 opera\u010dn\u00ed syst\u00e9my a hardware.<\/li>\n<\/ul>\n<p><\/p>\n<h2>\u00a0Z\u00e1v\u011br\u00a0<\/h2>\n<p>\nProst\u0159ed\u00ed datab\u00e1z\u00ed SQL Server se st\u00e1vaj\u00ed st\u00e1le v\u00edce rozs\u00e1hl\u00fdmi a slo\u017eit\u00fdmi. V SQL Server 2019 Microsoft vylep\u0161il z\u00e1kladn\u00ed funkce SQL Serveru a p\u0159idal nov\u00e9, jako je podpora pracovn\u00edch z\u00e1t\u011b\u017e\u00ed velk\u00fdch dat prost\u0159ednictv\u00edm Apache Spark a HDFS. Dell EMC ve spolupr\u00e1ci s Microsoftem nad\u00e1le poskytuje pro prost\u0159ed\u00ed SQL Server pot\u0159ebn\u00e9 komponenty infrastruktury \u2013 servery, \u00falo\u017ei\u0161t\u011b a s\u00edt\u011b.\u00a0<\/p>\n<p>Pozorujeme v\u00fdznamn\u00e9 zv\u00fd\u0161en\u00ed \u010dasu bezporuchovosti a sn\u00ed\u017een\u00ed celkov\u00fdch n\u00e1klad\u016f na vlastnictv\u00ed (TCO), pokud odborn\u00edci na ukl\u00e1d\u00e1n\u00ed dat a datab\u00e1ze spolupracuj\u00ed na vytv\u00e1\u0159en\u00ed infrastrukturn\u00edch \u0159e\u0161en\u00ed pro SQL Server na platform\u00e1ch s sd\u00edlen\u00fdm ulo\u017een\u00edm. Flashov\u00e9 pole Dell EMC Unity XT je st\u0159edn\u011bdob\u00e9 \u0159e\u0161en\u00ed vhodn\u00e9 pro v\u00fdvoj\u00e1\u0159e a administr\u00e1tory SQL Serveru, kte\u0159\u00ed pot\u0159ebuj\u00ed vysok\u00fd v\u00fdkon a n\u00edzkou latenci. Syst\u00e9m Unity XT All-Flash, ur\u010den\u00fd pro pr\u00e1ci se v\u0161emi flashov\u00fdmi dysky, podporuje dvoupodla\u017en\u00ed CPU, dvou\u0159\u00eddic\u00ed konfigurace a v\u00edcej\u00e1drovou optimalizaci.<\/p>\n<p>St\u00e1le \u010dast\u011bji organizace virtualizuj\u00ed sv\u00e1 prost\u0159ed\u00ed SQL Server. A\u010dkoli virtualizace p\u0159id\u00e1v\u00e1 do architektury dal\u0161\u00ed \u00farove\u0148 n\u00e1vrhu, poskytuje v\u00fdznamn\u00e9 v\u00fdhody. Douf\u00e1me, \u017ee v\u00e1m budou u\u017eite\u010dn\u00e9 n\u011bkter\u00e9 z nej\u010dast\u011bji pou\u017e\u00edvan\u00fdch funkc\u00ed a n\u00e1stroj\u016f VMware v prost\u0159ed\u00edch SQL Server, uveden\u00fdch v\u00fd\u0161e. Tak\u00e9 doporu\u010dujeme odkazy na zdroje pro podrobn\u011bj\u0161\u00ed informace.<\/p>\n<h2>U\u017eite\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 for 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 with 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: Best Practices Guide<\/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: Compression White Paper<\/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: Snapshots and Thin Clones White Paper<\/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: Data Reduction Analysis<\/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: Data Reduction White Paper<\/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> (product page)<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.youtube.com\/watch?v=oJ9T1lJf538\">Dell EMC Unity Product Overview and Architecture with 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 Future-Proof Loyalty Program<\/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 Blogs<\/a><\/noindex><\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.vmware.com\/solutions\/business-critical-apps\/sql-virtualization.html\">Virtualizing Microsoft SQL on 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\">Architecting Microsoft SQL Server On VMware vSphere\u2014Best Practices Guide<\/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\">Performance Characterization of Microsoft SQL Server on 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 technical white paper<br \/>\nSQL Server Blog<\/a><\/noindex><br \/>\n<noindex><a rel=\"nofollow\" href=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/default.aspx\">Microsoft Data Platform<\/a><\/noindex><br \/>\n<noindex><a rel=\"nofollow\" href=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/sql-server-2019\">Introducing 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 announcement archive<\/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.3 - 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\/cs\/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.3\" \/>\n\t\t<meta property=\"og:locale\" content=\"cs_CZ\" \/>\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\/cs\/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 flashov\u00e9 pole Dell EMC Unity XT | ProHoster","description":"Dnes v\u00e1s sezn\u00e1m\u00edme se zvl\u00e1\u0161tnostmi pou\u017e\u00edv\u00e1n\u00ed SQL Server 2019 se syst\u00e9mem ukl\u00e1d\u00e1n\u00ed Unity XT a poskytneme doporu\u010den\u00ed pro virtualizaci SQL Server pomoc\u00ed technologie VMware, nastaven\u00ed a spr\u00e1vy.","canonical_url":"https:\/\/prohoster.info\/cs\/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":"cs_CZ","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\/cs\/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\/cs\/wp-json\/wp\/v2\/posts\/53529","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/comments?post=53529"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/posts\/53529\/revisions"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/media?parent=53529"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/categories?post=53529"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/tags?post=53529"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}