{"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\/sq\/blog\/administrirovanie\/microsoft-sql-server-2019-i-flesh-massivy-dell-emc-unity-xt","title":{"rendered":"Microsoft SQL Server 2019 dhe sistemet e ruajtjes Dell EMC Unity XT","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p>Sot\u00ebm do t'ju njoftojm\u00eb me ve\u00e7orit\u00eb e p\u00ebrdorimit t\u00eb SQL Server 2019 me sistemin e ruajtjes Unity XT, si dhe do t'ju japim rekomandime p\u00ebr virtualizimin e SQL Server me teknologjin\u00eb VMware, p\u00ebr konfigurimin dhe menaxhimin e komponenteve baz\u00eb t\u00eb infrastruktur\u00ebs 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 dhe sistemet e ruajtjes Dell EMC Unity XT\" src=\"\/wp-content\/uploads\/2019\/12\/fe6c5fbfbfb8883ce3bcd215bff0f477.jpg\" style=\"display:block;margin: 0 auto;\" \/><\/a><\/noindex><br \/>\nN\u00eb vitin 2017, Dell EMC dhe VMware publikuan rezultatet e nj\u00eb ankete mbi tendencat dhe evolucionin e SQL Server - \"Transformimi i SQL Server: n\u00eb rrug\u00ebn drejt fleksibilitetit dhe q\u00ebndrueshm\u00ebris\u00eb\" (<noindex><a rel=\"nofollow\" href=\"http:\/\/www.dbta.com\/DBTA-Downloads\/ResearchReports\/SQL-Server-Transformation-Toward-Agility-and-Resiliency-6705.aspx\">Transformation of SQL Server: Toward Agility and Resiliency<\/a><\/noindex>), n\u00eb t\u00eb cil\u00ebn u p\u00ebrdor experiencia e komunitetit t\u00eb an\u00ebtar\u00ebve t\u00eb Asosacionit Profesional t\u00eb SQL Server (Professional Association of SQL Server, PASS). Rezultatet tregojn\u00eb se mjediset e bazave t\u00eb t\u00eb dh\u00ebnave SQL Server po rriten si n\u00eb madh\u00ebsi ashtu edhe n\u00eb kompleksitet, t\u00eb shkaktuara nga volumi n\u00eb rritje t\u00eb t\u00eb dh\u00ebnave dhe k\u00ebrkesat e reja t\u00eb biznesit. Baza e t\u00eb dh\u00ebnave SQL Server tani \u00ebsht\u00eb vendosur n\u00eb shum\u00eb kompani, duke siguruar funksionimin e aplikacioneve kritike dhe shpesh sh\u00ebrben si baza e transformimit digjital.\u00a0<\/p>\n<p>Q\u00eb nga zhvillimi i k\u00ebsaj ankete, Microsoft ka l\u00ebshuar brezin e ri t\u00eb DBMS - SQL Server 2019. P\u00ebrve\u00e7 p\u00ebrmir\u00ebsimeve n\u00eb funksionet kryesore t\u00eb motorit relational dhe sistemit t\u00eb ruajtjes, jan\u00eb shtuar sh\u00ebrbime dhe funksione t\u00eb reja. P\u00ebr shembull, SQL Server 2019 p\u00ebrfshin mb\u00ebshtetje p\u00ebr ngarkesat e pun\u00ebs p\u00ebr t\u00eb dh\u00ebnat e m\u00ebdha duke p\u00ebrdorur Apache Spark dhe sistemin e skedar\u00ebve t\u00eb shp\u00ebrndar\u00eb Hadoop (Hadoop Distributed File System, HDFS).<br \/>\n<noindex><a rel=\"nofollow\" name=\"habracut\"><\/a><\/noindex><\/p>\n<h2>Aleanca Dell EMC dhe Microsoft<\/h2>\n<p>\nDell EMC dhe Microsoft prej koh\u00ebsh kan\u00eb bashk\u00ebpunuar n\u00eb zhvillimin e zgjidhjeve p\u00ebr SQL Server. Zbatimi i suksessh\u00ebm i nj\u00eb platforme t\u00eb plot\u00eb t\u00eb baz\u00ebs s\u00eb t\u00eb dh\u00ebnave, si Microsoft SQL Server, k\u00ebrkon koordinimin e funksioneve t\u00eb softuerit me infrastruktur\u00ebn IT baz\u00eb. Kjo infrastruktur\u00eb p\u00ebrfshin fuqin\u00eb kompjuterike t\u00eb procesor\u00ebve, burimet e memories, sistemet e ruajtjes dhe sh\u00ebrbimet rrjetore. Dell EMC ofron infrastruktur\u00ebn p\u00ebr platform\u00ebn SQL Server p\u00ebr \u00e7do lloj ngarkese pune dhe aplikacionesh.<\/p>\n<p>Linia e server\u00ebve Dell EMC PowerEdge ofron shum\u00eb konfiguracione t\u00eb procesor\u00ebve dhe memories. K\u00ebto konfiguracione jan\u00eb t\u00eb p\u00ebrshtatshme p\u00ebr nj\u00eb gam\u00eb t\u00eb gjer\u00eb ngarkesash: nga aplikacionet e vogla t\u00eb korporatave deri te sistemet kritike m\u00eb t\u00eb m\u00ebdha, si planifikimi i burimeve t\u00eb nd\u00ebrmarrjes (ERP), magazinat e t\u00eb dh\u00ebnave, analiza e avancuar, tregtia elektronike etj. Linja e SDS \u00ebsht\u00eb projektuar p\u00ebr ruajtjen e t\u00eb dh\u00ebnave t\u00eb strukturuara dhe t\u00eb pa-strukturuara.\u00a0<\/p>\n<p>Klient\u00ebt q\u00eb zbatojn\u00eb SQL Server 2019 me infrastruktur\u00ebn Dell EMC, mund t\u00eb punojn\u00eb me t\u00eb dh\u00ebna t\u00eb strukturuara dhe t\u00eb pa-strukturuara duke p\u00ebrdorur SQL Server dhe Apache Spark. SQL Server gjithashtu mb\u00ebshtet kombinime teknologjish t\u00eb qasjes p\u00ebr klient\u00ebt, komunikimeve nd\u00ebrserver dhe komunikimeve \"server-ruajtje\". Koncepti Dell EMC bazohet n\u00eb nj\u00eb model t\u00eb dezigreguar q\u00eb ofron nj\u00eb ekosistem t\u00eb hapur. Organizatat mund t\u00eb zgjedhin nga nj\u00eb gam\u00eb t\u00eb gjer\u00eb aplikacionesh rrjetore standarde t\u00eb industris\u00eb, sisteme operative dhe platforma harduerike. Ky qasje ofron maksimumin e kontrollit mbi teknologjit\u00eb dhe arkitekturat, duke \u00e7uar n\u00eb nj\u00eb kursim t\u00eb duksh\u00ebm dhe fleksibilitet.<\/p>\n<p>VMware siguron virtualizimin e t\u00eb gjith\u00eb komponenteve t\u00eb r\u00ebnd\u00ebsishme t\u00eb infrastruktur\u00ebs q\u00eb nevojiten nga SQL Server p\u00ebr t\u00eb arritur performanc\u00eb t\u00eb lart\u00eb dhe q\u00ebndrushm\u00ebri t\u00eb operacioneve. P\u00ebrve\u00e7 cloud-it privat, p\u00ebr ngarkesat e pun\u00ebs VMware gjithashtu ofron modele hibride q\u00eb mbulojn\u00eb arkitekturat e cloudeve private dhe publike.\u00a0<\/p>\n<p>Shum\u00eb organizata zot\u00ebrojn\u00eb virtualizimin p\u00ebr t\u00eb ulur kostot e infrastruktur\u00ebs, p\u00ebr t\u00eb siguruar nj\u00eb disponueshm\u00ebri t\u00eb lart\u00eb dhe p\u00ebr t\u00eb leht\u00ebsuar rikuperimin nga fatkeq\u00ebsit\u00eb. 94% e ekspert\u00ebve t\u00eb SQL Server raportojn\u00eb nj\u00eb nivel t\u00eb caktuar t\u00eb virtualizimit n\u00eb mjedisin e tyre. 70% e atyre q\u00eb p\u00ebrdorin virtualizimin kan\u00eb zgjedhur VMware. 60% e nivelit t\u00eb virtualizimit t\u00eb SQL Server p\u00ebrb\u00ebn 75% dhe m\u00eb shum\u00eb. P\u00ebr m\u00eb tep\u00ebr, rezultatet e anket\u00ebs \u00ebsht\u00eb bind\u00ebse se disponueshm\u00ebria e lart\u00eb dhe rikuperimi nga fatkeq\u00ebsit\u00eb, t\u00eb realizuara n\u00eb nivelin e virtualizimit, jan\u00eb faktor\u00eb t\u00eb r\u00ebnd\u00ebsish\u00ebm n\u00eb vendimin p\u00ebr virtualizimin e bazave t\u00eb t\u00eb dh\u00ebnave SQL Server.<\/p>\n<h2>Ve\u00e7orit\u00eb e reja t\u00eb SQL Server 2019<\/h2>\n<p>\nPlatforma e baz\u00ebs s\u00eb t\u00eb dh\u00ebnave SQL Server 2019 p\u00ebrfshin nj\u00eb gam\u00eb t\u00eb gjer\u00eb teknologjish, ve\u00e7orish dhe sh\u00ebrbimesh q\u00eb mb\u00ebshtesin aplikacionet kritike, si analiza, bazat e t\u00eb dh\u00ebnave t\u00eb nd\u00ebrmarrjeve, analiza e biznesit (BI) dhe p\u00ebrpunimi i transaksioneve t\u00eb shkall\u00ebzuar (OLTP). Platforma SQL Server ka fituar mund\u00ebsit\u00eb p\u00ebr menaxhimin e integrimit t\u00eb t\u00eb dh\u00ebnave, magazinimin e t\u00eb dh\u00ebnave, raportimin dhe analiz\u00ebn e avancuar, funksionet e replikimit dhe menaxhimin e tipeve t\u00eb t\u00eb dh\u00ebnave t\u00eb gjys\u00ebm-strukturuara. Sigurisht, jo t\u00eb gjith\u00eb klient\u00ebt ose aplikacionet kan\u00eb nevoj\u00eb p\u00ebr t\u00eb gjitha k\u00ebto funksione. P\u00ebr m\u00eb tep\u00ebr, n\u00eb shum\u00eb raste preferohet t\u00eb ndahen sh\u00ebrbimet SQL Server me an\u00eb t\u00eb virtualizimit.\u00a0<\/p>\n<p>Sot\u00ebrbimet shpesh her\u00eb u k\u00ebrkojn\u00eb bizneseve t\u00eb mb\u00ebshteten n\u00eb sasi t\u00eb m\u00ebdha t\u00eb dh\u00ebnash nga nj\u00eb gam\u00eb t\u00eb gjer\u00eb sets t\u00eb t\u00eb dh\u00ebnave q\u00eb rriten vazhdimisht. Me SQL Server 2019, mund t\u00eb merrni informacione t\u00eb vlefshme n\u00eb koh\u00eb reale nga t\u00eb gjitha t\u00eb dh\u00ebnat. Klastrat SQL Server 2019 ofrojn\u00eb nj\u00eb ambient t\u00eb plot\u00eb p\u00ebr punimin me sets t\u00eb m\u00ebdha t\u00eb t\u00eb dh\u00ebnave, duke p\u00ebrfshir\u00eb p\u00ebrdorimin e m\u00ebsimit t\u00eb makinave dhe mund\u00ebsive t\u00eb inteligjenc\u00ebs artificiale. Funksionet kryesore t\u00eb reja dhe p\u00ebrmir\u00ebsimet n\u00eb SQL Server 2019 jan\u00eb listuar n\u00eb <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\">dokumentin Microsoft<\/a><\/noindex>.<\/p>\n<h2>Sistemi i ruajtjes s\u00eb mesme Dell EMC Unity XT<\/h2>\n<p>\nSeria e sistemeve Dell EMC Unity u paraqit gati tre vjet m\u00eb par\u00eb, dhe q\u00eb at\u00ebher\u00eb jan\u00eb shitur m\u00eb shum\u00eb se 40,000 sisteme. Klient\u00ebt e kan\u00eb vler\u00ebsuar k\u00ebt\u00eb sistem t\u00eb klasit t\u00eb mes\u00ebm p\u00ebr thjesht\u00ebsin\u00eb, performanc\u00ebn dhe efikasitetin e tij. Platformat e mesme Dell EMC Unity XT jan\u00eb zgjidhje me ruajtje t\u00eb p\u00ebrbashk\u00ebt q\u00eb ofrojn\u00eb vonesa t\u00eb ul\u00ebta, kapacitet t\u00eb lart\u00eb kalimi dhe kostot e ulta t\u00eb menaxhimit p\u00ebr ngarkesat e pun\u00ebs SQL Server. T\u00eb gjitha sistemet Unity XT p\u00ebrdorin nj\u00eb arkitektur\u00eb me dy procesor\u00eb (storage processors, SP) p\u00ebr t\u00eb mb\u00ebshtetur inputin dhe outputin dhe p\u00ebr t\u00eb kryer operacione me t\u00eb dh\u00ebna n\u00eb m\u00ebnyr\u00eb aktive\/t\u00eb aktivizuar. N\u00eb Unity XT, dual SP p\u00ebrdorin lidhje t\u00eb plota SAS 12 Gb\/s dhe nj\u00eb arkitektur\u00eb me shum\u00eb b\u00ebrthama t\u00eb patentuar p\u00ebr t\u00eb siguruar performanc\u00eb t\u00eb lart\u00eb dhe efikasitet. Array-t disk p\u00ebrshtatin kapacitetin e ruajtjes me ndihm\u00ebn e raft\u00ebve shtes\u00eb.<\/p>\n<p><img decoding=\"async\" alt=\"Microsoft SQL Server 2019 dhe sistemet e ruajtjes Dell EMC Unity XT\" src=\"\/wp-content\/uploads\/2019\/12\/d39fe24c2a392656402201d8957714bc.jpg\" style=\"display:block;margin: 0 auto;\" \/><br \/>\nN\u00eb Dell EMC Unity XT, brezi i ri i array-ve (hibrid\u00eb dhe t\u00ebr\u00ebsisht t\u00eb nd\u00ebrtuara mbi memori flash), ka rritur ndjesh\u00ebm performanc\u00ebn, ka p\u00ebrmir\u00ebsuar efikasitetin dhe ka shtuar mund\u00ebsi dhe sh\u00ebrbime t\u00eb reja p\u00ebr ambientet multi-cloud.\u00a0<\/p>\n<p>Arkitektura Unity XT lejon p\u00ebrpunimin e t\u00eb dh\u00ebnave n\u00eb m\u00ebnyr\u00eb t\u00eb nj\u00ebkohshme, reduktimin e volumit t\u00eb tyre dhe mb\u00ebshtetje t\u00eb sh\u00ebrbimeve si replikimi pa e kompromentuar performanc\u00ebn e aplikacioneve. Krahasuar me zgjidhjen e brezit t\u00eb kaluar, performanca e sistemit t\u00eb ruajtjes Dell EMC Unity XT \u00ebsht\u00eb dyfishuar, nd\u00ebrsa koha e p\u00ebrgjigjes \u00ebsht\u00eb reduktuar me 75%. Dhe natyrisht, Dell EMC Unity mb\u00ebshtet standardin NVMe.<\/p>\n<p>Sistemet e ruajtjes me disqe NVMe tregojn\u00eb cil\u00ebsit\u00eb e tyre m\u00eb t\u00eb mira n\u00eb aplikacione q\u00eb jan\u00eb t\u00eb ndjeshme ndaj vonesave. P\u00ebr shembull, n\u00eb aplikacione si bazat e dh\u00ebnash masive, NVMe ofron vonesa t\u00eb ul\u00ebta dhe shpejt\u00ebsi t\u00eb lart\u00eb transmetimi. Reduktimi i vonesave dhe rritja e paralelizmit rrisin ndjesh\u00ebm performanc\u00ebn e operacioneve t\u00eb leximit\/shkrimit. Nuk \u00ebsht\u00eb rast\u00ebsi q\u00eb sipas parashikimit t\u00eb IDC, deri n\u00eb vitin 2021, arrays flash t\u00eb lidhura me NVMe dhe NVMe-oF (NVMe over Fabric) do t\u00eb p\u00ebrb\u00ebjn\u00eb rreth gjysm\u00ebn e t\u00eb ardhurave nga shitjet e sistemeve t\u00eb jashtme t\u00eb ruajtjes n\u00eb bot\u00eb.\u00a0<\/p>\n<p>Kostot e ruajtjes p\u00ebrmir\u00ebsohen nga algoritmet e kompresimit t\u00eb t\u00eb dh\u00ebnave. Dell EMC Unity XT mund t\u00eb reduktoj\u00eb volumet e t\u00eb dh\u00ebnave deri n\u00eb pes\u00eb her\u00eb. Nj\u00eb tregues tjet\u00ebr i r\u00ebnd\u00ebsish\u00ebm \u00ebsht\u00eb efikasiteti i p\u00ebrgjithsh\u00ebm i sistemit. Dell EMC Unity XT p\u00ebrdor kapacitetin e sistemit n\u00eb 85%. Kompresimi dhe deduplication realizohen n\u00eb m\u00ebnyr\u00eb inline \u2014 n\u00eb nivelin e kontrolleve. T\u00eb dh\u00ebnat ruhen n\u00eb form\u00eb t\u00eb kompresuar. Sistemi gjithashtu automatizon menaxhimin e skedar\u00ebve t\u00eb t\u00eb dh\u00ebnave.<\/p>\n<p>Array-t flash me p\u00ebrdorim t\u00eb thjesht\u00eb Unity me akses t\u00eb unifikuar (block dhe file) ofrojn\u00eb koh\u00eb t\u00eb q\u00ebndrueshme p\u00ebrgjigjeje, integrohen me sh\u00ebrbimet e ruajtjes n\u00eb re dhe mb\u00ebshtesin p\u00ebrmir\u00ebsimin pa migrimin e t\u00eb dh\u00ebnave. N\u00eb konfigurimin baz\u00eb, ky sistem universal i ruajtjes instalohet brenda 30 minutash.<\/p>\n<p>Tehnologjia e ruajtjes s\u00eb t\u00eb dh\u00ebnave e quajtur 'pula dinamike' lejon kalimin nga rritja statike n\u00eb dinamike t\u00eb memorie, duke ofruar fleksibilitet t\u00eb lart\u00eb dhe thjesht\u00ebsi n\u00eb rritjen e kapacitetit t\u00eb sistemit. Pulat dinamike ruajn\u00eb kapacitetin dhe buxhetin, dhe k\u00ebrkojn\u00eb m\u00eb pak koh\u00eb p\u00ebr t'u rind\u00ebrtuar. Rritja e kapacitetit dhe performanc\u00ebs s\u00eb Dell EMC Unity nuk k\u00ebrkon migrimin e t\u00eb dh\u00ebnave.\u00a0<\/p>\n<p>Shum\u00eb kompani sot, n\u00eb kombinim me infrastruktur\u00ebn e tyre lokale, p\u00ebrdorin disa sh\u00ebrbime publike n\u00eb re. Dell EMC Unity XT mund t\u00eb funksionoj\u00eb si nj\u00eb komponent i ambientit t\u00eb re Dell Technologies Cloud. Ky sistem ruajtjeje mund t\u00eb p\u00ebrdoret n\u00eb re publike dhe t\u00eb transferoj\u00eb t\u00eb dh\u00ebnat n\u00eb re private. P\u00ebr m\u00eb tep\u00ebr, sistemi i ruajtjes Dell EMC Unity XT \u00ebsht\u00eb n\u00eb dispozit\u00eb sipas modelit 'si sh\u00ebrbim'. Ky \u00ebsht\u00eb nj\u00eb nga sh\u00ebrbimet e ruajtjes n\u00eb re t\u00eb Dell EMC Cloud Storage Services.<br \/>\n\u00a0<br \/>\nStorage n\u00eb cloud po b\u00ebhet gjithnj\u00eb e m\u00eb i popullarizuar, pasi ndihmon n\u00eb rritjen e kthimit mbi investimine p\u00ebrmes uljes s\u00eb kostove t\u00eb infrastruktur\u00ebs. Sh\u00ebrbimet e ruajtjes n\u00eb cloud, Cloud Storage Services, zgjasin qendrat e t\u00eb dh\u00ebnave t\u00eb klient\u00ebve n\u00eb cloud, duke ofruar ruajtje Dell EMC (t\u00eb lidhur drejtp\u00ebrdrejt me burimet e cloud-it publik) si nj\u00eb sh\u00ebrbim. Ofruesit e tjer\u00eb mund t\u00eb sigurojn\u00eb lidhje me shpejt\u00ebsi t\u00eb lart\u00eb (me vonesa t\u00eb ul\u00ebta) me cloud-in publik direkt me sistemet Dell EMC Unity, PowerMax dhe Isilon n\u00eb Qendrat e t\u00eb Dh\u00ebnave t\u00eb klientit.<\/p>\n<p>Familja Unity XT p\u00ebrfshin sistemet Unity XT All-Flash, Unity XT Hybrid, UnityVSA dhe Unity Cloud Edition.<br \/>\n\u00a0<\/p>\n<h2>Sistemet hibrid dhe flash t\u00eb unifikuar\u00a0<\/h2>\n<p>\nSistemet e ruajtjes Unity XT Hybrid dhe Unity XT All-Flash, t\u00eb bazuara n\u00eb procesor\u00ebt Intel, realizojn\u00eb nj\u00eb arkitektur\u00eb t\u00eb integruar p\u00ebr qasje bllok, skedar dhe VMware VVols me mb\u00ebshtetje p\u00ebr protokollet e ruajtjes n\u00eb rrjet (NAS), iSCSI dhe Fibre Channel (FC). Platformat Unity XT Hybrid dhe Unity XT All-Flash jan\u00eb t\u00eb gatshme p\u00ebr p\u00ebrdorimin e disqeve NVMe.<\/p>\n<p>Sistemet hibrid Unity XT mb\u00ebshtesin funksionimin n\u00eb mjedise multi-cloud. Mb\u00ebshtetjeja p\u00ebr mjediset multi-cloud do t\u00eb thot\u00eb zgjerimin e sistemit t\u00eb ruajtjes n\u00eb cloud ose shp\u00ebrndarjen n\u00eb cloud me mund\u00ebsi fleksibile p\u00ebr p\u00ebrdorimin e burimeve. Ruajtjet multi-cloud kan\u00eb p\u00ebr q\u00ebllim t\u00eb ofrojn\u00eb mobilitet dhe portabilitet t\u00eb t\u00eb dh\u00ebnave n\u00eb mes t\u00eb disa platformave cloud \u2013 private dhe publike. Kjo ndikon jo vet\u00ebm n\u00eb proceset e transferimit t\u00eb t\u00eb dh\u00ebnave, por edhe n\u00eb organizimin e aksesit t\u00eb aplikacioneve n\u00eb t\u00eb dh\u00ebnat n\u00eb disa cloud-e publike. <\/p>\n<p><img decoding=\"async\" alt=\"Microsoft SQL Server 2019 dhe sistemet e ruajtjes Dell EMC Unity XT\" src=\"\/wp-content\/uploads\/2019\/12\/d61d5fa31b94676109c89338070dbf0b.jpg\" style=\"display:block;margin: 0 auto;\" \/><br \/>\nK\u00ebto sisteme hibride ofrojn\u00eb mund\u00ebsit\u00eb e m\u00ebposhtme:<\/p>\n<ul>\n<li>Shkall\u00ebzueshm\u00ebria deri n\u00eb 16 PB kapacitet \"t\u00eb pap\u00ebrpunuar\".<\/li>\n<li>Funksione t\u00eb integruara p\u00ebr reduktimin e rregullt t\u00eb volumit p\u00ebr t\u00eb gjith\u00eb grupet e flash.<\/li>\n<li>Instalimi dhe konfigurimi i shpejt\u00eb (mesatarisht zgjat 25 minuta).<\/li>\n<\/ul>\n<p>\nTeknologjit\u00eb e disqeve t\u00eb ngurt\u00eb po p\u00ebrmir\u00ebsohen me shpejt\u00ebsi, dhe n\u00eb vitet e ardhshme n\u00eb treg do t\u00eb shfaqen produkte revolucionar\u00eb t\u00eb rinj. Nd\u00ebrkoh\u00eb, organizatat do t\u00eb vazhdojn\u00eb t\u00eb z\u00ebvend\u00ebsojn\u00eb disqet tradicionale HDD me disqe t\u00eb ngurt\u00eb p\u00ebr t\u00eb rritur performanc\u00ebn, leht\u00ebsin\u00eb e menaxhimit dhe kursimin e energjis\u00eb. Brezat e rinj t\u00eb grupeve flash do t\u00eb dallohen nga mjetet m\u00eb t\u00eb p\u00ebrparuara p\u00ebr automatizimin e ruajtjes, integrimin me cloud-in publik dhe mbrojtjen e integruar t\u00eb t\u00eb dh\u00ebnave.\u00a0<\/p>\n<p>Sistemet Unity XT All-Flash ofrojn\u00eb shpejt\u00ebsi t\u00eb lart\u00eb, efikasitet dhe mb\u00ebshtetje p\u00ebr m\u00eb shum\u00eb se nj\u00eb cloud. Caracteristikat e tyre:<\/p>\n<ul>\n<li>Dyfishimi i performanc\u00ebs.<\/li>\n<li>Reduktimi i volumit t\u00eb t\u00eb dh\u00ebnave deri n\u00eb 7: 1.<\/li>\n<li>Instalimi dhe konfigurimi i shpejt\u00eb (procesi merr m\u00eb pak se 30 minuta).<\/li>\n<\/ul>\n<p><\/p>\n<h2>\u00a0UnityVSA<\/h2>\n<p>\nSistemi UnityVSA \u00ebsht\u00eb nj\u00eb ruajt\u00ebs i programuar p\u00ebr ambientet virtuale VMware ESXi, duke p\u00ebrdorur kapacitetin e ruajtjes s\u00eb server\u00ebve, t\u00eb p\u00ebrbashk\u00ebt ose cloud. UnityVSA HA, konfigurimi me dy ruajt\u00ebsit UnityVSA, ofron q\u00ebndrueshm\u00ebri t\u00eb shtuar. Ruajtja UnityVSA ofron:<\/p>\n<ul>\n<li>Derisa 50 TB kapaciteti t\u00eb jet\u00eb ruajtje unike dhe funksionale.<\/li>\n<li>P\u00ebrputhshm\u00ebri me sistemet dhe funksionet e Unity XT.<\/li>\n<li>Mb\u00ebshtetje p\u00ebr sistemet me disponueshm\u00ebri t\u00eb lart\u00eb (UnityVSA HA).<\/li>\n<li>Konektimi si NAS dhe iSCSI.<\/li>\n<li>Replikimi i t\u00eb dh\u00ebnave nga platforma t\u00eb tjera Unity XT.<\/li>\n<\/ul>\n<p><\/p>\n<h2>Unity Cloud Edition<\/h2>\n<p>\nP\u00ebr sinkronizimin e skedareve dhe operacioneve t\u00eb rikuperimit t\u00eb fatkeq\u00ebsive me cloud, familja Unity XT p\u00ebrfshin versionin Unity Cloud Edition, q\u00eb ofron:<\/p>\n<ul>\n<li>Funksione t\u00eb plota t\u00eb ruajtjes duke p\u00ebrdorur ruajt\u00ebsin e programuar (SDS), t\u00eb shp\u00ebrndara n\u00eb cloud.<\/li>\n<li>D\u00ebrgim i thjesht\u00eb i ruajtjes bllok dhe skedar\u00ebve duke p\u00ebrdorur VMware Cloud n\u00eb AWS.<\/li>\n<li>Mb\u00ebshtetje p\u00ebr rikuperimin nga fatkeq\u00ebsit\u00eb, duke p\u00ebrfshir\u00eb testimin dhe analiz\u00ebn e t\u00eb dh\u00ebnave.<\/li>\n<\/ul>\n<p>\n<img decoding=\"async\" alt=\"Microsoft SQL Server 2019 dhe sistemet e ruajtjes 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 p\u00ebr SQL Server<\/h2>\n<p>\nN\u00eb raportin Unisphere Research t\u00eb vitit 2017 \"Transformimi i SQL Server: n\u00eb rrug\u00ebn drejt fleksibilitetit dhe q\u00ebndrueshm\u00ebris\u00eb\" (<noindex><a rel=\"nofollow\" href=\"http:\/\/www.dbta.com\/DBTA-Downloads\/ResearchReports\/SQL-Server-Transformation-Toward-Agility-and-Resiliency-6705.aspx\">Transformation of SQL Server: Toward Agility and Resiliency<\/a><\/noindex>) 22% e p\u00ebrgjegj\u00ebsve raportuan se ata p\u00ebrdorin teknologjin\u00eb e ruajtjes flash n\u00eb prodhim (16%) ose planifikojn\u00eb ta b\u00ebjn\u00eb k\u00ebt\u00eb (6%). 30% aplikojn\u00eb grupe hibride q\u00eb p\u00ebrfshijn\u00eb memorie flash. 13% p\u00ebrdorin grupe flash me lidhje t\u00eb drejtp\u00ebrdrejt\u00eb. 13% b\u00ebjn\u00eb kopje rezerv\u00eb t\u00eb bazave t\u00eb t\u00eb dh\u00ebnave SQL Server n\u00eb ruajtjen flash.<\/p>\n<p>Ky zbatim i shpejt\u00eb i ruajtjeve flash p\u00ebr p\u00ebrdorim me SQL Server tregon se grupet Unity XT All-Flash jan\u00eb ve\u00e7an\u00ebrisht t\u00eb mira p\u00ebr zhvilluesit dhe administrator\u00ebt e SQL Server. Sistemet Unity XT All-Flash ofrojn\u00eb zhvilluesve dhe administrator\u00ebve t\u00eb SQL Server mund\u00ebsi dhe performanc\u00eb q\u00eb kalojn\u00eb at\u00eb q\u00eb ofrojn\u00eb rrjetet tipike t\u00eb ruajtjes s\u00eb t\u00eb dh\u00ebnave (SAN).<\/p>\n<p><img decoding=\"async\" alt=\"Microsoft SQL Server 2019 dhe sistemet e ruajtjes Dell EMC Unity XT\" src=\"\/wp-content\/uploads\/2019\/12\/7236f0c77513950c58d26dc5e86b20d5.jpg\" style=\"display:block;margin: 0 auto;\" \/><br \/>\nSistemet Unity XT All-Flash, t\u00eb gatshme p\u00ebr vendosjen e NVMe (p\u00ebr nj\u00eb performanc\u00eb edhe m\u00eb t\u00eb lart\u00eb dhe vones\u00eb t\u00eb ul\u00ebt), kan\u00eb form\u00eb 2U, mb\u00ebshtesin procesor\u00eb me dy b\u00ebrthama, dy kontrollues n\u00eb modin aktiv\/aktiv.<\/p>\n<p><b>Modelet Unity XT All-Flash<\/b><\/p>\n<p>Unity XT\u00a0<\/p>\n<p>Procesor\u00ebt\u00a0<\/p>\n<p>Memorja (p\u00ebr procesor)<\/p>\n<p>Numri maksimal i disqeve<\/p>\n<p>Kapaciteti maksimal \"t\u00eb pap\u00ebrpunuar\" (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>Detajet e mund t\u00eb gjenden n\u00eb specifikimet e grupeve (<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\">Fleushin e Specifikimeve t\u00eb Seris\u00eb Dell EMC Unity XT Storage<\/a><\/noindex>).<\/p>\n<h2>Grupet e Ruajtjes s\u00eb T\u00eb Dh\u00ebnave<\/h2>\n<p>\nShum\u00eb profesionist\u00eb q\u00eb punojn\u00eb me SQL Server e din\u00eb se t\u00eb gjitha grumbujt modern\u00eb t\u00eb ruajtjes ofrojn\u00eb mund\u00ebsin\u00eb p\u00ebr t\u00eb grupuar disqet n\u00eb nj\u00ebsi m\u00eb t\u00eb m\u00ebdha ruajtjeje me nj\u00eb nivel t\u00eb rregullt mbrojtjeje RAID. Grupe t\u00eb ve\u00e7anta disqesh me mbrojtje RAID jan\u00eb grupet tradicionale t\u00eb ruajtjes. Nd\u00ebrsa sistemet hibride Unity XT mb\u00ebshtesin vet\u00ebm grupet tradicionale, grumbujt Unity XT All-Flash ofrojn\u00eb gjithashtu grupe dinamike ruajtjeje. N\u00eb rastin e grupeve dinamike t\u00eb ruajtjes, mbrojtja RAID zbatohet mbi shtrirjet e disqeve \u2013 nj\u00ebsi ruajtjeje m\u00eb t\u00eb vogla se nj\u00eb disk i plot\u00eb. Grupet dinamike ofrojn\u00eb fleksibilitet m\u00eb t\u00eb madh n\u00eb menaxhimin dhe zgjerimin e grupeve t\u00eb disqeve.\u00a0<\/p>\n<p>Dell EMC ofron rekomandime p\u00ebr menaxhimin e grupeve t\u00eb ruajtjes p\u00ebr t\u00eb arritur performanc\u00ebn maksimale me kompleksitet minimal. P\u00ebr shembull, rekomandohet t\u00eb minimizohet numri i grupeve t\u00eb ruajtjes Unity XT p\u00ebr t\u00eb ulur kompleksitetin dhe p\u00ebr t\u00eb rritur fleksibilitetin. Megjithat\u00eb, vendosja e grupeve t\u00eb tjera t\u00eb ruajtjes mund t\u00eb jet\u00eb shum\u00eb e arsyeshme n\u00eb disa raste, duke p\u00ebrfshir\u00eb kur ju nevojitet:<\/p>\n<ul>\n<li>T\u00eb mbani ngarkesa t\u00eb ve\u00e7anta me profile t\u00eb ndryshme hyrjeje\/daljeje.<\/li>\n<li>T\u00eb alokoni burime p\u00ebr t\u00eb arritur parametra t\u00eb ve\u00e7ant\u00eb t\u00eb performanc\u00ebs.<\/li>\n<li>T\u00eb alokoni burime t\u00eb ve\u00e7anta p\u00ebr shum\u00eb-n\u00ebntosje.<\/li>\n<li>T\u00eb krijoni domene m\u00eb t\u00eb vogla p\u00ebr mbrojtje nga d\u00ebshtimi<\/li>\n<\/ul>\n<p><\/p>\n<h2>V\u00ebllimet e ruajtjes (LUN)<\/h2>\n<p>\nSi t\u00eb gjeni kompromisin midis menaxhimit dhe fleksibilitetit kur zgjidhni numrin e v\u00ebllimeve n\u00eb grumbull? P\u00ebr fleksibilitet maksimal n\u00eb Unity me SQL Server rekomandohet t\u00eb krijoni v\u00ebllime p\u00ebr secil\u00ebn sked\u00eb t\u00eb baz\u00ebs s\u00eb t\u00eb dh\u00ebnave. N\u00eb praktik\u00eb, shumica e organizatave p\u00ebrdorin nj\u00eb qasje t\u00eb shum\u00eb-niveleve, ku bazat e t\u00eb dh\u00ebnave kritike marrin fleksibilitet maksimale, nd\u00ebrsa skedat e bazave t\u00eb t\u00eb dh\u00ebnave m\u00eb pak t\u00eb r\u00ebnd\u00ebsishme grupohen n\u00eb nj\u00eb num\u00ebr m\u00eb t\u00eb vog\u00ebl v\u00ebllimesh t\u00eb m\u00ebdha. Rekomandojm\u00eb t\u00eb shqyrtoni t\u00eb gjitha k\u00ebrkesat p\u00ebr bazat e t\u00eb dh\u00ebnave dhe \u00e7do aplikacion t\u00eb lidhur, pasi teknologjit\u00eb e mbrojtjes s\u00eb t\u00eb dh\u00ebnave dhe monitorimit varen nga izolimi dhe vendosja e skedave.<\/p>\n<p>Menaxhimi me shum\u00eb v\u00ebllime shpesh \u00ebsht\u00eb i v\u00ebshtir\u00eb, ve\u00e7an\u00ebrisht n\u00eb mjedise virtuale. Mjediset virtuale SQL Server jan\u00eb nj\u00eb shembull i mir\u00eb se kur ka kuptim t\u00eb vendosni disa tipe skedash n\u00eb nj\u00eb v\u00ebllim. Administrator\u00ebt e baz\u00ebs s\u00eb t\u00eb dh\u00ebnave ose administrator\u00ebt e ruajtjes (ose t\u00eb dy) kur p\u00ebrcaktojn\u00eb numrin e v\u00ebllimeve q\u00eb krijojn\u00eb duhet t\u00eb gjejn\u00eb balansin e duhur midis fleksibilitetit dhe leht\u00ebsis\u00eb s\u00eb mir\u00ebmbajtjes.<\/p>\n<h2>Ruajtja e skedar\u00ebve<\/h2>\n<p>\nServer\u00ebt NAS vendosin sisteme t\u00eb skedar\u00ebve n\u00eb sistemin e ruajtjes Unity XT. Sistemet e skedar\u00ebve mund t\u00eb aksesohen p\u00ebrmes protokolleve SMB ose NFS, dhe fal\u00eb sistemit t\u00eb skedar\u00ebve me shum\u00eb protokolle, mund t\u00eb p\u00ebrdoren t\u00eb dyja protokollet n\u00eb t\u00eb nj\u00ebjt\u00ebn koh\u00eb. P\u00ebr t\u00eb lidhur hostin me skedat SMB, NFS dhe sistemet e skedar\u00ebve me shum\u00eb protokolle, si dhe me burimet e ruajtjes VMware NFS dhe v\u00ebllimet virtuale VMware, server\u00ebt NAS p\u00ebrdorin nd\u00ebrfaqe virtuale. Sistemet e skedar\u00ebve dhe nd\u00ebrfaqet virtuale jan\u00eb t\u00eb izoluar brenda nj\u00eb serveri NAS, duke lejuar p\u00ebrdorimin e disa server\u00ebve NAS p\u00ebr shum\u00eb-n\u00ebntosje. Server\u00ebt NAS kalojn\u00eb automatikisht n\u00eb rast d\u00ebshtimi, n\u00ebse procesori i ruajtjes d\u00ebshton. Sistemet e skedar\u00ebve t\u00eb lidhura gjithashtu kalojn\u00eb n\u00eb rast d\u00ebshtimi.<\/p>\n<p>SQL Server 2012 (11.x) dhe versionet m\u00eb t\u00eb vona mb\u00ebshtesin protokollin Server Message Block (SMB) 3.0, q\u00eb mund\u00ebson ndarjen e skedar\u00ebve t\u00eb rrjetit p\u00ebr ruajtje. Si p\u00ebr instalimin autonom, ashtu edhe p\u00ebr klasterin e q\u00ebndruesh\u00ebm mund t\u00eb vendosni bazat e t\u00eb dh\u00ebnave sistemore (master, model, msdb dhe tempdb) dhe bazat e t\u00eb dh\u00ebnave t\u00eb p\u00ebrdoruesve t\u00eb Motorit t\u00eb t\u00eb Dh\u00ebnave me opsionin e ruajtjes SMB. P\u00ebrdorimi i ruajtjes SMB \u00ebsht\u00eb nj\u00eb mund\u00ebsi e mir\u00eb kur p\u00ebrdorni grupe t\u00eb larta t\u00eb disponueshm\u00ebris\u00eb Always On Availability Groups, pasi p\u00ebr nj\u00eb burim t\u00eb p\u00ebrbashk\u00ebt t\u00eb skedar\u00ebve k\u00ebrkohet qasje n\u00eb nj\u00eb burim rrjeti me disponueshm\u00ebri t\u00eb lart\u00eb.<\/p>\n<p>Krijimi i burimeve t\u00eb p\u00ebrbashk\u00ebta SMB p\u00ebr implementimin e SQL Server me ruajtjen Unity XT \u00ebsht\u00eb nj\u00eb proces i thjesht\u00eb n\u00eb tre hapa: duhet t\u00eb krijoni nj\u00eb server NAS, nj\u00eb sistem skedar\u00ebsh dhe nj\u00eb burim t\u00eb p\u00ebrbashk\u00ebt SMB. Software Dell EMC Unisphere Storage Management p\u00ebrfshin nj\u00eb asistent konfigurimi q\u00eb do t'ju ndihmoj\u00eb t\u00eb p\u00ebrfundoni k\u00ebt\u00eb proces. Megjithat\u00eb, kur vendosni ngarkesa pune SQL Server mbi burime t\u00eb p\u00ebrbashk\u00ebta SMB, mos harroni disa konsiderata t\u00eb r\u00ebnd\u00ebsishme q\u00eb nuk lidhen domosdoshm\u00ebrisht me p\u00ebrdorimin e burimeve t\u00eb p\u00ebrbashk\u00ebta SMB. Microsoft ka hartuar nj\u00eb list\u00eb pyetjesh p\u00ebr instalimin dhe sigurin\u00eb s\u00eb bashku me problemet aktuale t\u00eb njohura; detajet gjeni n\u00eb seksionin 'Instalimi i SQL Server me ruajtjen e skedar\u00ebve SMB' n\u00eb <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\">dokumentet Microsoft<\/a><\/noindex>.<\/p>\n<h2>Snapshot-e t\u00eb t\u00eb dh\u00ebnave<\/h2>\n<p>\nT\u00eb dh\u00ebnat jan\u00eb b\u00ebr\u00eb burimi m\u00eb i r\u00ebnd\u00ebsish\u00ebm p\u00ebr kompanit\u00eb, dhe mjediset kritike sot k\u00ebrkojn\u00eb jo vet\u00ebm rezervimin. Aplikacionet duhet t\u00eb jen\u00eb gjithmon\u00eb online, duke siguruar operacione dhe p\u00ebrdit\u00ebsime t\u00eb pa nd\u00ebrprera. Ato gjithashtu k\u00ebrkojn\u00eb performanc\u00eb dhe disponueshm\u00ebri t\u00eb lart\u00eb t\u00eb t\u00eb dh\u00ebnave p\u00ebrmes opsioneve t\u00eb tilla si replikimi lokal i snapshot-eve dhe replikimi i larg\u00ebt.<\/p>\n<p>Rafti i ruajtjes Unity XT ofron mund\u00ebsi p\u00ebr krijimin e snapshot-eve p\u00ebr blloqe dhe skedar\u00eb, dhe ato p\u00ebrdorin procese, operacione dhe arkitektur\u00eb t\u00eb p\u00ebrbashk\u00ebt. Metodologjia e snapshot-eve Unity ofron nj\u00eb m\u00ebnyr\u00eb t\u00eb thjesht\u00eb dhe efikase p\u00ebr mbrojtjen e t\u00eb dh\u00ebnave. Snapshot-et leht\u00ebsojn\u00eb rikuperimin e t\u00eb dh\u00ebnave \u2013 mund t\u00eb riktheheni n\u00eb nj\u00eb snapshot m\u00eb t\u00eb hersh\u00ebm, ose mund t\u00eb kopjoni t\u00eb dh\u00ebna t\u00eb zgjedhura nga nj\u00eb snapshot t\u00eb m\u00ebparsh\u00ebm. N\u00eb tabel\u00ebn e m\u00ebposhtme jepen afatet e ruajtjes s\u00eb snapshot-eve p\u00ebr sistemet Unity XT.<\/p>\n<h2>Ruajtja lokale dhe e larg\u00ebt e snapshot-eve t\u00eb t\u00eb dh\u00ebnave<\/h2>\n<p><\/p>\n<p>Typi i snapshot-it<\/p>\n<p>CLI<br \/>\nUI<br \/>\nREST<\/p>\n<p>Dora dor\u00ebs\u00a0<\/p>\n<p>Sipas orarit\u00a0<\/p>\n<p>Dora dor\u00ebs\u00a0<\/p>\n<p>Sipas orarit\u00a0<\/p>\n<p>Dora dor\u00ebs\u00a0<\/p>\n<p>Sipas orarit\u00a0<\/p>\n<p>Lokale\u00a0<\/p>\n<p>1 vit\u00a0<\/p>\n<p>1 vit<\/p>\n<p>5 vjet\u00a0<\/p>\n<p>4 jav\u00eb<\/p>\n<p>100 vjet<\/p>\n<p>Pa kufizime<\/p>\n<p>T\u00eb larg\u00ebta\u00a0<\/p>\n<p>5 vjet<\/p>\n<p>255 jav\u00eb\u00a0<\/p>\n<p>5 vjet<\/p>\n<p>255 jav\u00eb<\/p>\n<p>5 vjet<\/p>\n<p>255 jav\u00eb<\/p>\n<p>Snapshot-et nuk jan\u00eb nj\u00eb z\u00ebvend\u00ebsim i drejtp\u00ebrdrejt\u00eb p\u00ebr metoda t\u00eb tjera mbrojtjeje t\u00eb t\u00eb dh\u00ebnave, si\u00e7 \u00ebsht\u00eb kopjimi. Ato mund t\u00eb jen\u00eb vet\u00ebm nj\u00eb shtes\u00eb p\u00ebr kopjimin tradicional si nj\u00eb lini e par\u00eb mbrojt\u00ebse p\u00ebr skenar\u00eb me RTO t\u00eb vog\u00ebl.<\/p>\n<p>Funksioni i snapshot-eve t\u00eb Dell EMC Unity p\u00ebrfshin reduktimin e volumit t\u00eb t\u00eb dh\u00ebnave dhe deduplication t\u00eb avancuar. Snapshot-et gjithashtu p\u00ebrfitojn\u00eb nga kursimi i hap\u00ebsir\u00ebs q\u00eb arrihet n\u00eb burimin origjinal t\u00eb ruajtjes. Kur krijoni nj\u00eb snapshot t\u00eb nj\u00eb burimi ruajtjeje q\u00eb mb\u00ebshtet funksionet e reduktimit t\u00eb volumit t\u00eb t\u00eb dh\u00ebnave, t\u00eb dh\u00ebnat n\u00eb burim mund t\u00eb kompresohen ose deduplicohen.<\/p>\n<p>Ja disa v\u00ebrejtje n\u00eb lidhje me rikuperimin e baz\u00ebs s\u00eb t\u00eb dh\u00ebnave kur p\u00ebrdoren snapshot-et me bazat e t\u00eb dh\u00ebnave SQL Server:<\/p>\n<ul>\n<li>T\u00eb gjitha komponent\u00ebt e baz\u00ebs s\u00eb t\u00eb dh\u00ebnave SQL Server duhet t\u00eb mbrohen si nj\u00eb grup t\u00eb dh\u00ebnash. Kur skedar\u00ebt e t\u00eb dh\u00ebnave dhe regjistrat jan\u00eb n\u00eb LUN t\u00eb ndryshme, k\u00ebto LUN duhet t\u00eb b\u00ebhen pjes\u00eb e nj\u00eb grupi konsistent. Grupi konsistent siguron q\u00eb snapshot-i do t\u00eb b\u00ebhet nj\u00ebkoh\u00ebsisht n\u00eb t\u00eb gjitha LUN n\u00eb grup. Kur skedar\u00ebt e t\u00eb dh\u00ebnave dhe regjistrat jan\u00eb n\u00eb disa burime t\u00eb p\u00ebrbashk\u00ebta SMB, burimet duhet t\u00eb jen\u00eb n\u00eb t\u00eb nj\u00ebjtin sistem skedar\u00ebsh.<\/li>\n<li>Kur rikuperoni nj\u00eb baz\u00eb t\u00eb dh\u00ebnash SQL Server nga nj\u00eb snapshot blloqesh, n\u00ebse instanca e SQL Server duhet t\u00eb mbetet e lidhur, p\u00ebrdorni lidhjen me host-in Unisphere. P\u00ebr rikuperimin e bazave t\u00eb t\u00eb dh\u00ebnave krijohet nj\u00eb burim t\u00eb p\u00ebrbashk\u00ebt SMB t\u00eb ri, duke p\u00ebrdorur snapshot-in si burim. Pasi t\u00eb lidhen vollet, baza e t\u00eb dh\u00ebnave mund t\u00eb lidhet me nj\u00eb em\u00ebr t\u00eb ri ose t\u00eb z\u00ebvend\u00ebsoj\u00eb baz\u00ebn ekzistuese t\u00eb dh\u00ebnash t\u00eb rikuperuar.<\/li>\n<\/ul>\n<p><\/p>\n<ul>\n<li>Kur kryeni rikuperimin me metod\u00ebn e rikuperimit t\u00eb snapshot-eve Snapshot Restore n\u00eb Unisphere, kaloni instanc\u00ebn e SQL Server n\u00eb modin offline. SQL Server nuk \u00ebsht\u00eb i informuar p\u00ebr operacionet e rikuperimit. Kalimi i instanc\u00ebs n\u00eb modin offline garanton q\u00eb vollet t\u00eb mos d\u00ebmtohen nga operacionet e shkrimit n\u00eb baz\u00ebn e t\u00eb dh\u00ebnave para rikuperimit. Pasi instanca t\u00eb rindezhet, rikuperimi i fatkeq\u00ebsis\u00eb i SQL Server do t\u00eb sjell\u00eb bazat e t\u00eb dh\u00ebnave n\u00eb nj\u00eb gjendje konsistente.<\/li>\n<li>Lejoni snapshot-et p\u00ebr disa objekte ruajtjeje nj\u00ebkoh\u00ebsisht, dhe pastaj, p\u00ebrpara se t\u00eb aktivizoni snapshot-e t\u00eb tjera, sigurohuni q\u00eb sistemi t\u00eb jet\u00eb n\u00eb modet e rekomanduara gjat\u00eb monitorimit.<\/li>\n<\/ul>\n<p><\/p>\n<h2>Automatizimi dhe planifikimi i snapshot-eve<\/h2>\n<p>\nSnapshot-et n\u00eb Unity XT mund t\u00eb automatizohen. N\u00eb sistemin e menaxhimit t\u00eb ruajtjes Unisphere jan\u00eb t\u00eb disponueshme k\u00ebto mund\u00ebsi snapshot-i si parazgjedhje: mbrojtje parazgjedhje, mbrojtje me nj\u00eb periudh\u00eb m\u00eb t\u00eb shkurt\u00ebr ruajtjeje dhe mbrojtje me nj\u00eb periudh\u00eb m\u00eb t\u00eb gjat\u00eb ruajtjeje. \u00c7do opsion krijon snapshot-e t\u00eb p\u00ebrditshme dhe i ruan ato p\u00ebr periudha t\u00eb ndryshme kohe.<\/p>\n<p>Mund t\u00eb zgjidhni nj\u00eb (ose t\u00eb dy) opsione planifikimi \u2014 \u00e7do x or\u00eb (nga 1 deri n\u00eb 24) dhe \u00e7do dit\u00eb \/ \u00e7do jav\u00eb. Planifikimi i p\u00ebrditsh\u00ebm \/ javora i kopjeve lejon p\u00ebrcaktimin e nj\u00eb kohe dhe dit\u00ebsh specifike p\u00ebr krijimin e kopjeve. P\u00ebr \u00e7do opsion t\u00eb zgjedhur, duhet t\u00eb vendosni nj\u00eb politik\u00eb ruajtjeje, e cila mund t\u00eb konfigurohet p\u00ebr t\u00eb fshir\u00eb automatikisht grumbullin ose p\u00ebr ruajtje t\u00eb p\u00ebrkohshme.<\/p>\n<p>Informacione shtes\u00eb rreth kopjeve t\u00eb Unity \u2013 n\u00eb <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\">dokumentacionin e Dell EMC Unity<\/a><\/noindex>.\u00a0<\/p>\n<h2>Kloni t\u00eb holl\u00eb<\/h2>\n<p>\nKloni i holl\u00eb \u00ebsht\u00eb nj\u00eb kopje e lexueshme\/shkruese e nj\u00eb burimi t\u00eb holl\u00eb t\u00eb magazinimit, p\u00ebr shembull nj\u00eb volum, nj\u00eb grup koherent ose nj\u00eb magazin\u00eb t\u00eb dh\u00ebnash VMware VMFS, e cila ndan blloqet me burimin prind. Klon\u00ebt e holl\u00eb jan\u00eb nj\u00eb m\u00ebnyr\u00eb e shk\u00eblqyer p\u00ebr t\u00eb krijuar shpejt dhe kompakt kopje t\u00eb baz\u00ebs s\u00eb t\u00eb dh\u00ebnave SQL Server, t\u00eb cilat nuk mund t\u00eb arrijn\u00eb me mjetet tradicionale t\u00eb SQL Server. Pasi kloni i holl\u00eb t\u00eb paraqitet n\u00eb host, volumet mund t\u00eb kalojn\u00eb n\u00eb modin e operimit (online), dhe baza e t\u00eb dh\u00ebnave do t\u00eb lidhet duke p\u00ebrdorur metod\u00ebn e bashkimit t\u00eb DB-s\u00eb n\u00eb SQL Server.<\/p>\n<p>Kur p\u00ebrdorni funksionin e azhurnimit me klon\u00ebt e holl\u00eb, \u00e7aktivizoni (kaloni n\u00eb offline) t\u00eb gjitha bazat e t\u00eb dh\u00ebnave q\u00eb ndodhen n\u00eb klonin e holl\u00eb. Kjo duhet b\u00ebr\u00eb para operacionit t\u00eb azhurnimit. N\u00ebse nuk i kaloni bazat e t\u00eb dh\u00ebnave n\u00eb modalitetin offline para ekzekutimit t\u00eb azhurnimit, kjo mund t\u00eb \u00e7oj\u00eb n\u00eb gabime t\u00eb p\u00ebrputhshm\u00ebris\u00eb s\u00eb t\u00eb dh\u00ebnave ose rezultate t\u00eb gabuara t\u00eb t\u00eb dh\u00ebnave n\u00eb SQL Server.<\/p>\n<h2>Replikimi i t\u00eb dh\u00ebnave<\/h2>\n<p>\nReplikimi \u00ebsht\u00eb nj\u00eb funksion programor q\u00eb sinkronizon t\u00eb dh\u00ebnat me nj\u00eb sistem t\u00eb larg\u00ebt mbi t\u00eb nj\u00ebjtin objekt ose n\u00eb nj\u00eb vend tjet\u00ebr. Opsionet e replikimit dhe konfigurimit t\u00eb Unity lejojn\u00eb zgjedhjen e nj\u00eb m\u00ebnyre efektive p\u00ebr t\u00eb p\u00ebrmbushur k\u00ebrkesat RTO\/RPO p\u00ebr bazat e t\u00eb dh\u00ebnave SQL Server, duke ruajtur nj\u00eb balanc\u00eb midis performanc\u00ebs dhe bandwidth-it.<\/p>\n<p>Kur p\u00ebrdorni replikimin Dell EMC Unity p\u00ebr t\u00eb mbrojtur bazat e t\u00eb dh\u00ebnave SQL Server mbi disa volume, duhet t\u00eb kufizoni t\u00eb gjitha t\u00eb dh\u00ebnat dhe volumet e regjistrit t\u00eb baz\u00ebs s\u00eb t\u00eb dh\u00ebnave n\u00eb nj\u00eb grup koherent t\u00eb vet\u00ebm ose n\u00eb nj\u00eb sistem skedar\u00ebsh. Pastaj, replikimi konfigurohet n\u00eb grupin ose sistemin e skedar\u00ebve dhe mund t\u00eb p\u00ebrfshij\u00eb volume ose burime t\u00eb zakonshme t\u00eb disa bazave t\u00eb t\u00eb dh\u00ebnave. Bazat e t\u00eb dh\u00ebnave q\u00eb k\u00ebrkojn\u00eb opsione t\u00eb ndryshme replikimi duhet t\u00eb jen\u00eb n\u00eb LUN t\u00eb ve\u00e7anta, grupe koherente ose sisteme skedar\u00ebsh.<\/p>\n<p>Klon\u00ebt e holl\u00eb jan\u00eb t\u00eb pajtuesh\u00ebm si me replikimin sinqon, ashtu edhe me at\u00eb asinkron. Kur kloni i holl\u00eb replikon n\u00eb destinacion, ai b\u00ebhet nj\u00eb kopje e plot\u00eb e volumit, grupit koherent ose magazin\u00ebs VMFS. Pasi t\u00eb ket\u00eb p\u00ebrfunduar replikimi, kloni i holl\u00eb \u00ebsht\u00eb nj\u00eb volum krejt\u00ebsisht i pavarur me cil\u00ebsimet e tij. <\/p>\n<p><img decoding=\"async\" alt=\"Microsoft SQL Server 2019 dhe sistemet e ruajtjes Dell EMC Unity XT\" src=\"\/wp-content\/uploads\/2019\/12\/58d0ecdba09abdd75de974e87d84188c.jpg\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<i>Procesi i replikimit t\u00eb klonit t\u00eb holl\u00eb midis sistemeve burimore dhe ato q\u00ebllimore.<\/i><\/p>\n<p>Replikimi i baz\u00ebs s\u00eb t\u00eb dh\u00ebnave tempdb nuk k\u00ebrkohet, pasi skedari rikonstruktohet me rinisjen e SQL Server, prandaj metadata nuk p\u00ebrputhet me metod\u00ebn e instancave t\u00eb tjera t\u00eb SQL Server. Zgjedhja e kujdesshme e volumeve p\u00ebr replikim dhe p\u00ebrmbajtjes s\u00eb k\u00ebtyre volumesh eliminon trafikun e panevojsh\u00ebm t\u00eb replikimit.<\/p>\n<h2>Menaxhimi i integruar i kopj\u00ebve t\u00eb t\u00eb dh\u00ebnave Microsoft SQL Server<\/h2>\n<p>\nShumica e produkteve moderne t\u00eb magazinimit (duke p\u00ebrfshir\u00eb t\u00eb gjitha produktet e Dell EMC) mund t\u00eb krijojn\u00eb kopje \u00abt\u00eb koherente me sistemin operativ\u00bb t\u00eb skedar\u00ebve t\u00eb \u00e7do lloji duke:<\/p>\n<ul>\n<li>Duke ruajtur nj\u00eb rend t\u00eb koherenc\u00ebs n\u00eb shkruar t\u00eb sistemit operativ n\u00eb t\u00eb gjitha nivelet \u2014 nga hosti deri te disku.<\/li>\n<li>Duke grupuar volumet, n\u00eb m\u00ebnyr\u00eb q\u00eb p\u00ebr disa skedare n\u00eb volume t\u00eb ndryshme t\u00eb ruhet rendi i shkruar.<\/li>\n<\/ul>\n<p>\nMe p\u00ebrhapjen e pajisjeve magazinuese t\u00eb shkall\u00ebzuara, Microsoft ka zhvilluar API p\u00ebr ofruesit e SHT. Ky API lejon ofruesit e magazin\u00ebs t\u00eb koordinojn\u00eb veprimet e tyre me softuerin e bazave t\u00eb t\u00eb dh\u00ebnave SQL Server p\u00ebr t\u00eb krijuar \u00abkopje t\u00eb koherente me aplikacionin\u00bb me ndihm\u00ebn e sh\u00ebrbimit t\u00eb kopjimeve t\u00eb volumit (VSS). K\u00ebto kopje imitojn\u00eb bashk\u00ebveprimin e SQL Server dhe sistemit operativ gjat\u00eb ndalimit dhe p\u00ebrfundimit t\u00eb pun\u00ebs s\u00eb SQL Server. T\u00eb gjitha buferat e shkruar fshihen, dhe transaksionet pezullohen derisa t\u00eb gjitha disk\u00ebt t\u00eb azhurnohen dhe koordinohen p\u00ebr nj\u00eb moment t\u00eb caktuar n\u00eb koh\u00eb, i cili regjistrohet n\u00eb regjistrin e SQL.<\/p>\n<p>Software Dell EMC AppSync, i integruar me kopjet e Unity XT, thjeshton dhe automatizon procesin e krijimit, p\u00ebrdorimit dhe menaxhimit t\u00eb kopjeve t\u00eb koherente me aplikacionin t\u00eb t\u00eb dh\u00ebnave t\u00eb pun\u00ebs. Ky softuer \u00ebsht\u00eb i destinuar p\u00ebr t'u p\u00ebrdorur n\u00eb skenaret e menaxhimit t\u00eb kopj\u00ebve p\u00ebr rikuperimin e bazave t\u00eb t\u00eb dh\u00ebnave dhe ri-p\u00ebrdorimin e tyre.\u00a0<\/p>\n<p>Softveri AppSync automatski prepoznaje baze podataka aplikacija, prou\u010dava strukturu baze podataka i prikazuje strukturu datoteka kroz nivoe hardverske ili virtualizacione infrastrukture u osnovno skladi\u0161te Unity XT. Organizuje sve potrebne radnje, od kreiranja i verifikacije kopija do montiranja trenutnih snimaka na ciljnim hostovima i pokretanja ili oporavka baze podataka. AppSync podr\u017eava i pojednostavljuje radne tokove SQL Server-a, koji uklju\u010duju a\u017euriranje i oporavak radne baze podataka.<\/p>\n<h2>Smanjenje zapremine podataka i napredna deduplikacija<\/h2>\n<p>\nPorodica sistema za skladi\u0161tenje podataka Dell EMC Unity nudi multifunkcionalne i jednostavne usluge smanjenja zapremine podataka. U\u0161teda se ostvaruje ne samo na postavljenim primarnim resursima skladi\u0161tenja, ve\u0107 i na snimcima i tankim klonovima tih resursa. Trenutni snimci i tanki klonovi nasle\u0111uju konfiguraciju smanjenja zapremine podataka izvorne skladi\u0161ne jedinice, \u010dime se pove\u0107ava u\u0161teda prostora.<\/p>\n<p>Funkcija smanjenja zapremine podataka uklju\u010duje procese deduplikacije, kompresije i otkrivanja nultih blokova, \u0161to potencijalno pove\u0107ava koli\u010dinu korisnog skladi\u0161nog prostora za korisni\u010dke objekte i unutra\u0161nju upotrebu. Funkcija smanjenja zapremine podataka Unity XT zamenjuje funkciju kompresije u Unity OE 4.3 i novijim verzijama. Kompresija je algoritam smanjenja podataka koji mo\u017ee smanjiti fizi\u010dku raspodelu kapaciteta potrebnog za skladi\u0161tenje skupa podataka.<\/p>\n<p>Sistemi Unity XT tako\u0111e pru\u017eaju naprednu funkciju deduplikacije, koja se mo\u017ee uklju\u010diti ako je omogu\u0107eno smanjenje zapremine podataka. Napredna deduplikacija smanjuje potrebni kapacitet za korisni\u010dke podatke, \u010duvaju\u0107i samo mali broj kopija (naj\u010de\u0161\u0107e jednu) blokova podataka Unity. Oblast deduplikacije je jedan LUN. Uzmite to u obzir prilikom odabira skladi\u0161ne sheme. Manji broj LUN-ova dovodi do bolje deduplikacije, dok ve\u0107i broj LUN-ova obezbe\u0111uje pove\u0107anu performansu.\u00a0<\/p>\n<p>U\u0161teda kapaciteta zahvaljuju\u0107i naprednoj deduplikaciji mo\u017ee doneti najve\u0107i povratak u ve\u0107ini sredina, ali tako\u0111e zahteva kori\u0161\u0107enje resursa procesora skladi\u0161nog sistema Unity. U OE 5.0, ako je omogu\u0107ena, napredna deduplikacija deduplikuje bilo koji blok (kompresovan ili nekompresovan). Dodatne informacije potra\u017eite u <noindex><a rel=\"nofollow\" href=\"https:\/\/www.emc.com\/collateral\/white-papers\/h15571-dell-emc-unity-compression.pdf\">dokumentaciji Dell EMC<\/a><\/noindex>.<\/p>\n<p>U slede\u0107oj tabeli su prikazane podr\u017eane konfiguracije za smanjenje zapremine podataka i naprednu deduplikaciju:<\/p>\n<h2>Smanjenje podataka u Unity (sve modele) i napredna podr\u0161ka deduplikaciji<\/h2>\n<p><\/p>\n<p>Verzija Unity OE\u00a0<\/p>\n<p>Teknologjia\u00a0<\/p>\n<p>Podr\u017eani tip skladi\u0161nog prostora\u00a0<\/p>\n<p>Podr\u017eani modeli<\/p>\n<p>4.3 \/ 4.4\u00a0<\/p>\n<p>Smanjenje zapremine podataka\u00a0<\/p>\n<p>Flash pool \u2014 tradicionalni ili dinami\u010dki\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>Smanjenje zapremine podataka\u00a0<\/p>\n<p>300, 400, 500, 600, 300F, 400F, 500F, 600F, 350F, 450F, 550F, 650F\u00a0<\/p>\n<p>Smanjenje podataka i napredna deduplikacija*<\/p>\n<p>450F, 550F, 650F\u00a0<\/p>\n<p>5\u00a0<br \/>\n\u00a0<\/p>\n<p>Smanjenje zapremine podataka\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>Smanjenje zapremine podataka i napredna deduplikacija<\/p>\n<p>450F, 550F, 650F, 380, 480, 680, 880, 380F, 480F, 680F, 880F<\/p>\n<p><i> * Smanjenje zapremine podataka je po default-u isklju\u010deno i treba ga uklju\u010diti pre nego \u0161to napredna deduplikacija postane dostupna kao opcija. Nakon uklju\u010divanja smanjenja zapremine podataka, napredna deduplikacija \u0107e biti dostupna, ali je po default-u isklju\u010dena.<\/i><\/p>\n<h2>Smanjenje zapremine podataka u Unity i kompresija podataka u SQL Server-u<\/h2>\n<p>\nIzdanje SQL Server 2008 Enterprise Edition je bilo prvo izdanje sa sopstvenim mogu\u0107nostima kompresije podataka. Kada se primenjuje kompresija na nivou redova i stranica, SQL Server 2008 koristi znanje o formatu tabele unutra\u0161nje baze podataka SQL Server-a kako bi smanjio prostor koji zauzimaju objekti baze podataka. Smanjenje prostora omogu\u0107ava da se vi\u0161e redova smesti na stranicu i vi\u0161e stranica u burserskom bazenu. Po\u0161to podaci koji nisu sa\u010duvani u formatu stranice podataka od 8k, kao \u0161to su podaci izvan redova, poput NVARCHAR (MAX), ne koriste metode kompresije redova ili stranica, Microsoft je uveo funkcije Transact-SQL COMPRESS i DECOMPRESS.\u00a0<\/p>\n<p>Ove funkcije koriste tradicionalni pristup kompresiji podataka (GZIP algoritam), koji se mora pozvati za svaki deo podataka za kompresiju ili raspakivanje.<\/p>\n<p>Kompresija Unity XT, koja nije isklju\u010divo vezana za SQL Server, koristi softverski algoritam za analizu i kompresiju podataka skladi\u0161ta. Od objavljivanja Unity OE 4.1, kompresija podataka Unity je bila dostupna za volumene blokovskog skladi\u0161ta i skladi\u0161nih podataka VMFS u flash pool-u. Po\u010dev\u0161i od Unity OE 4.2, kompresija je tako\u0111e dostupna za fajl sistem i skladi\u0161ne podatke NFS u skladi\u0161nim pool-ima na flash ure\u0111ajima.<\/p>\n<p>Zgjedhja e metod\u00ebs s\u00eb kompresimit t\u00eb t\u00eb dh\u00ebnave p\u00ebr SQL Server varet nga disa faktor\u00eb. K\u00ebta faktor\u00eb p\u00ebrfshijn\u00eb llojin e p\u00ebrmbajtjes s\u00eb baz\u00ebs s\u00eb t\u00eb dh\u00ebnave, burimet e disponueshme t\u00eb CPU - si n\u00eb ruajtje ashtu edhe n\u00eb serverat e baz\u00ebs s\u00eb t\u00eb dh\u00ebnave, dhe burimet e hyrjes dhe daljes q\u00eb nevojiten p\u00ebr mbajtjen e SLA. N\u00eb p\u00ebrgjith\u00ebsi, mund t\u00eb pritet nj\u00eb kursim shtes\u00eb t\u00eb hap\u00ebsir\u00ebs p\u00ebr t\u00eb dh\u00ebnat q\u00eb kompresohen me ndihm\u00ebn e SQL Server, megjithat\u00eb, t\u00eb dh\u00ebnat e kompresuara me funksionin e kompresimit TSQL duke p\u00ebrdorur algoritmin GZIP, nuk do t\u00eb fitojn\u00eb ndonj\u00eb reduktim t\u00eb r\u00ebnd\u00ebsish\u00ebm t\u00eb volumit nga funksionet e kompresimit t\u00eb Unity XT, pasi shumica e p\u00ebrfitimeve arrihen p\u00ebrmes algoritmit universale t\u00eb aplikuar t\u00eb parin.<\/p>\n<p>Kompresimi i Unity siguron kursim hap\u00ebsire, n\u00ebse t\u00eb dh\u00ebnat n\u00eb objektin e ruajtjes kompresohen t\u00eb pakt\u00ebn me 25%. Para se t\u00eb aktivizoni kompresimin p\u00ebr objektin e ruajtjes, p\u00ebrcaktoni n\u00ebse ai p\u00ebrmban t\u00eb dh\u00ebna q\u00eb mund t\u00eb kompresohen. Mos aktivizoni kompresimin p\u00ebr objektin e ruajtjes n\u00ebse kjo nuk do t\u00eb sjell\u00eb kursim kapaciteti.\u00a0<\/p>\n<p>Kur merrni vendimin n\u00ebse duhet t\u00eb p\u00ebrdorni reduktimin e volumit t\u00eb t\u00eb dh\u00ebnave t\u00eb Unity, kompresimin n\u00eb nivelin e baz\u00ebs s\u00eb t\u00eb dh\u00ebnave SQL Server ose t\u00eb dyja, merrni parasysh sa vijon:<\/p>\n<ul>\n<li>T\u00eb dh\u00ebnat q\u00eb shkruhen n\u00eb sistemin Unity, konfirmohen nga hosti pasi ruhen n\u00eb cache-in e sistemit. Megjithat\u00eb, procesi i kompresimit nuk fillon derisa cache-i t\u00eb pastrohet.<\/li>\n<\/ul>\n<p><\/p>\n<ul>\n<li>Kursimi n\u00eb kompresim arrihet jo vet\u00ebm p\u00ebr burimet e ruajtjes Unity XT, por gjithashtu p\u00ebr snapshotet dhe klon\u00ebt e holl\u00eb t\u00eb burimit.<\/li>\n<li>N\u00eb procesin e kompresimit, disa blloqe agregohen me ndihm\u00ebn e algoritmit t\u00eb zgjedhjes, p\u00ebr t\u00eb p\u00ebrcaktuar n\u00ebse t\u00eb dh\u00ebnat i n\u00ebnshtrohen kompresimit. N\u00ebse algoritmi i zgjedhjes p\u00ebrcakton se mund t\u00eb arrihet vet\u00ebm nj\u00eb kursim minimal, at\u00ebher\u00eb kompresimi anashkalohet dhe t\u00eb dh\u00ebnat shkruhen n\u00eb rezervuar.<\/li>\n<li>Kur t\u00eb dh\u00ebnat kompresohen para se t\u00eb shkruhen n\u00eb medium, volumi i operacioneve me to zvog\u00eblohet ndjesh\u00ebm. Prandaj, kompresimi ndihmon n\u00eb zvog\u00eblimin e konsumit t\u00eb flash-memory duke reduktuar volumin fizik t\u00eb t\u00eb dh\u00ebnave q\u00eb shkruhen n\u00eb disq.<\/li>\n<\/ul>\n<p>\nP\u00ebr m\u00eb shum\u00eb informacione mbi kompresimin e rreshtave dhe faqeve n\u00eb SQL Server p\u00ebr tabelat dhe indeksat, shikoni n\u00eb <noindex><a rel=\"nofollow\" href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/data-compression\/data-compression\">dokumentet Microsoft<\/a><\/noindex>.<\/p>\n<p>Mos harroni se p\u00ebr \u00e7do kompresim jan\u00eb t\u00eb nevojshme burime t\u00eb procesorit. N\u00ebse k\u00ebrkesat p\u00ebr band\u00eb jan\u00eb t\u00eb larta, kompresimi mund t\u00eb ket\u00eb nj\u00eb ndikim t\u00eb duksh\u00ebm n\u00eb performanc\u00eb. Koeficientet e larta t\u00eb shkrimeve t\u00eb ngarkesave OLAP gjithashtu mund t\u00eb zvog\u00eblojn\u00eb p\u00ebrfitimet e kompresimit p\u00ebr baz\u00ebn e t\u00eb dh\u00ebnave SQL Server.<\/p>\n<p>Specialist\u00ebt e Dell EMC studiuan kursimet potenciale duke p\u00ebrdorur koeficient\u00ebt real\u00eb t\u00eb reduktimit t\u00eb t\u00eb dh\u00ebnave n\u00eb grumbullin Unity. Grupi grumbulloi t\u00eb dh\u00ebna nga makinat virtuale VMware, ndarjet e skedar\u00ebve, bazat e t\u00eb dh\u00ebnave SQL Server, makinat virtuale Microsoft Hyper-V, etj.<\/p>\n<p>Rezultatet e studimit treguan se reduktimi i volumit t\u00eb skedarit t\u00eb regjistrave SQL Server ishte pothuajse 10 her\u00eb m\u00eb i vog\u00ebl se ai i skedar\u00ebve t\u00eb t\u00eb dh\u00ebnave:<\/p>\n<ul>\n<li>Hap\u00ebsira e baz\u00ebs s\u00eb t\u00eb dh\u00ebnave = 1.49: 1 (32.96%)<\/li>\n<li>Hap\u00ebsira e regjistrave = 12.9: 1 (92.25%)<\/li>\n<\/ul>\n<p>\nBaza e t\u00eb dh\u00ebnave SQL Server ishte e furnizuar me dy volume. Skedar\u00ebt e baz\u00ebs s\u00eb t\u00eb dh\u00ebnave ruhen n\u00eb nj\u00eb volum, nd\u00ebrsa regjistrat e transaksioneve n\u00eb nj\u00eb tjet\u00ebr. P\u00ebrdorimi i teknologjis\u00eb s\u00eb reduktimit t\u00eb t\u00eb dh\u00ebnave me volumin e baz\u00ebs s\u00eb t\u00eb dh\u00ebnave mund t\u00eb siguroj\u00eb kursim ruajtjeje; megjithat\u00eb, duhet t\u00eb merret parasysh ndikimi n\u00eb performanc\u00eb kur vendosni n\u00ebse t\u00eb aktivizoni deduplication n\u00eb volumin e baz\u00ebs s\u00eb t\u00eb dh\u00ebnave. Edhe pse reduktimi i v\u00ebrtet\u00eb i volumit t\u00eb baz\u00ebs s\u00eb t\u00eb dh\u00ebnave mund t\u00eb variroj\u00eb n\u00eb var\u00ebsi t\u00eb t\u00eb dh\u00ebnave t\u00eb ruajtura, rezultatet e studimit treguan se hap\u00ebsira p\u00ebr ruajtjen e regjistrave t\u00eb transaksioneve SQL Server mund <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\">t\u00eb reduktohet ndjesh\u00ebm<\/a><\/noindex>.<\/p>\n<h2>Praktikat m\u00eb t\u00eb mira p\u00ebr reduktimin e volumit t\u00eb t\u00eb dh\u00ebnave<\/h2>\n<p>\nPara se t\u00eb aktivizoni reduktimin e t\u00eb dh\u00ebnave n\u00eb objektin e ruajtjes, merrni parasysh rekomandimet e m\u00ebposhtme:<\/p>\n<ul>\n<li>P\u00ebrdorni monitorimin e sistemit t\u00eb ruajtjes p\u00ebr t'u siguruar q\u00eb ai ka burime t\u00eb disponueshme p\u00ebr t\u00eb mb\u00ebshtetur reduktimin e volumit t\u00eb t\u00eb dh\u00ebnave.<\/li>\n<li>Aktivizoni reduktimin e volumit t\u00eb t\u00eb dh\u00ebnave p\u00ebr disa objekte ruajtjeje nj\u00ebkoh\u00ebsisht. Para se t\u00eb aktivizoni n\u00eb objekte t\u00eb tjera ruajtjeje, monitoroni sistemin p\u00ebr t'u siguruar q\u00eb ai \u00ebsht\u00eb n\u00eb modet e rekomanduara t\u00eb pun\u00ebs.<\/li>\n<li>N\u00eb modelet Unity XT x80F, reduktimi i volumit t\u00eb t\u00eb dh\u00ebnave do t\u00eb siguroj\u00eb kursim kapaciteti, n\u00ebse t\u00eb dh\u00ebnat n\u00eb bllokun e ruajtjes kompresohen t\u00eb pakt\u00ebn me 1%.<\/li>\n<\/ul>\n<p>\nReduktimi i volumit t\u00eb t\u00eb dh\u00ebnave n\u00eb modelet e m\u00ebparshme Unity x80F, duke punuar n\u00ebn OE 5.0, siguronte kursim, n\u00ebse t\u00eb dh\u00ebnat ishin t\u00eb kompresueshme t\u00eb pakt\u00ebn me 25%.<\/p>\n<ul>\n<li>Para se t\u00eb aktivizoni reduktimin e volumit t\u00eb t\u00eb dh\u00ebnave n\u00eb objektin e ruajtjes, p\u00ebrcaktoni n\u00ebse objekti p\u00ebrmban t\u00eb dh\u00ebna t\u00eb kompresueshme. Lloje t\u00eb caktuara t\u00eb t\u00eb dh\u00ebnave, si video, audio, imazhe dhe t\u00eb dh\u00ebna binare, zakonisht japin p\u00ebrfitime t\u00eb vogla nga kompresimi. Mos aktivizoni reduktimin e volumit t\u00eb t\u00eb dh\u00ebnave n\u00eb objektin e ruajtjes, n\u00ebse nuk do t\u00eb ket\u00eb kursim hap\u00ebsire.<\/li>\n<li>Merrni parasysh nj\u00eb mund\u00ebsi t\u00eb kompresimit t\u00eb pjessh\u00ebm t\u00eb volumit t\u00eb t\u00eb dh\u00ebnave t\u00eb skedar\u00ebve, t\u00eb cilat zakonisht kompresohen mir\u00eb.<\/li>\n<\/ul>\n<p><\/p>\n<h2>Virtualizimi VMware<\/h2>\n<p>\nVMware vSphere \u00ebsht\u00eb nj\u00eb platform\u00eb efektive dhe e sigurt p\u00ebr virtualizimin dhe ambientin cloud. Komponent\u00ebt kryesor\u00eb t\u00eb vSphere jan\u00eb VMware vCenter Server dhe hipervizori VMware ESXi.<\/p>\n<p>vCenter Server \u00ebsht\u00eb nj\u00eb platform\u00eb unike menaxhimi p\u00ebr ambientet vSphere. Ajo karakterizohet nga leht\u00ebsia e implementimit dhe optimizimi proaktiv i burimeve. ESXi \u00ebsht\u00eb nj\u00eb hipervizor me kod t\u00eb hapur, i cili instalohet direkt n\u00eb server\u00ebt fizik\u00eb. ESXi ka qasje t\u00eb drejtp\u00ebrdrejt\u00eb n\u00eb burimet baz\u00eb dhe nj\u00eb p\u00ebrmas\u00eb t\u00eb vog\u00ebl prej 150 MB, e cila minimizon k\u00ebrkesat p\u00ebr memorie. Ai ofron performanc\u00eb t\u00eb besueshme p\u00ebr ngarkesa t\u00eb ndryshme aplikacionesh dhe mb\u00ebshtet konfigurime t\u00eb fuqishme virtuale\u2014deri n\u00eb 128 CPU virtual\u00eb, 6 TB RAM, dhe 120 pajisje.<\/p>\n<p>P\u00ebr t\u00eb punuar n\u00eb m\u00ebnyr\u00eb efektive SQL Server n\u00eb pajisje moderne, sistemi operativ i SQL Server (SQLOS) duhet t\u00eb \"kuptoj\u00eb\" struktur\u00ebn e pajisjes. Me shfaqjen e sistemeve multi-b\u00ebrthamore dhe multi-nodale me akses t\u00eb heterogjensh\u00ebm n\u00eb memorie (NUMA), ka qen\u00eb ve\u00e7an\u00ebrisht e r\u00ebnd\u00ebsishme t\u00eb kuptohet nd\u00ebrveprimi midis b\u00ebrthamave, procesor\u00ebve logjik\u00eb dhe fizik\u00eb.<\/p>\n<h2>Procesor\u00ebt\u00a0<\/h2>\n<p>\nProcesori virtual (vCPU) \u00ebsht\u00eb nj\u00eb procesor qendror virtual, i caktuar p\u00ebr makin\u00ebn virtuale. Numri total i vCPU t\u00eb caktuar llogaritet si:<\/p>\n<pre><code class=\"plaintext\">Total vCPU = (numri i socket-\u00ebve virtual\u00eb) * (numri i b\u00ebrthamave virtuale p\u00ebr socket)<\/code><\/pre>\n<p>\nN\u00ebse performanca e q\u00ebndrueshme \u00ebsht\u00eb e r\u00ebnd\u00ebsishme, VMware rekomandon q\u00eb numri total i vCPU t\u00eb caktuar t\u00eb t\u00eb gjitha makinave virtuale t\u00eb mos tejkaloj\u00eb numrin total t\u00eb b\u00ebrthamave fizike t\u00eb disponueshme n\u00eb hostin ESXi, por \u00ebsht\u00eb e mundur t\u00eb rritni numrin e vCPU t\u00eb caktuar n\u00ebse monitorimi tregon se burimet e padisponueshme jan\u00eb t\u00eb disponueshme.<\/p>\n<p>N\u00eb sistemet me teknologjin\u00eb Intel Hyper-Threading t\u00eb aktivizuar, numri i b\u00ebrthamave logjike (vCPU) \u00ebsht\u00eb dyfish i numrit t\u00eb b\u00ebrthamave fizike. N\u00eb k\u00ebt\u00eb rast, mos caktoni numrin total t\u00eb vCPU.<\/p>\n<p>P\u00ebr ngarkesat e SQL Server me nivel m\u00eb t\u00eb ul\u00ebt, variabiliteti i vones\u00ebs ka m\u00eb pak ndikim. Prandaj, k\u00ebto ngarkesa mund t\u00eb ekzekutohen n\u00eb hoste me nj\u00eb raport m\u00eb t\u00eb lart\u00eb t\u00eb vCPU ndaj fizik\u00ebve. Nivelet e arsyeshme t\u00eb ngarkes\u00ebs s\u00eb CPU mund t\u00eb rrisin kapacitetin total t\u00eb sistemit, t\u00eb ruajn\u00eb licencat dhe t\u00eb mb\u00ebshtesin performanc\u00ebn adekuate.<\/p>\n<p>Intel Hyper-Threading zakonisht rrit kapacitetin total t\u00eb host\u00ebve nga 10\u201330%, q\u00eb sugjeron nj\u00eb raport t\u00eb vCPU ndaj procesor\u00ebve fizik\u00eb nga 1,1 deri n\u00eb 1,3. VMware rekomandon aktivizimin e Hyper-Threading n\u00eb BIOS UEFI, sa her\u00eb q\u00eb \u00ebsht\u00eb e mundur, p\u00ebr t\u00eb mund\u00ebsuar q\u00eb ESXi t\u00eb p\u00ebrfitoj\u00eb nga kjo teknologji. P\u00ebr m\u00eb tep\u00ebr, VMware rekomandon testim t\u00eb kujdessh\u00ebm dhe monitorim n\u00eb p\u00ebrdorimin e Hyper-Threading p\u00ebr ngarkesat e SQL Server.<\/p>\n<h2>Memoria<\/h2>\n<p>\nGati t\u00eb gjith\u00eb server\u00ebt modern\u00eb p\u00ebrdorin nj\u00eb arkitektur\u00eb me akses t\u00eb heterogjensh\u00ebm n\u00eb memorie (NUMA) p\u00ebr lidhjen midis memories kryesore dhe procesor\u00ebve. NUMA \u00ebsht\u00eb nj\u00eb arkitektur\u00eb harduerike p\u00ebr memori t\u00eb ndar\u00eb, q\u00eb implementon ndarjen e grupeve t\u00eb memories fizike midis procesor\u00ebve fizik\u00eb. Nj\u00eb nyje NUMA \u00ebsht\u00eb nj\u00eb ose disa socket-e CPU s\u00eb bashku me nj\u00eb bllok t\u00eb memories s\u00eb dedikuar.\u00a0<\/p>\n<p>Gjat\u00eb dekad\u00ebs s\u00eb fundit, NUMA ka qen\u00eb nj\u00eb tem\u00eb e diskutueshme e gjer\u00eb. Kompleksiteti relativ i NUMA varet, p\u00ebrve\u00e7 t\u00eb tjerash, nga implementimet nga furnizues t\u00eb ndrysh\u00ebm. N\u00eb mjediset e virtualizuara, kompleksiteti i NUMA gjithashtu p\u00ebrcaktohet nga numri i parametrave t\u00eb konfigurimit dhe niveleve\u2014nga hardueri n\u00eb hipervizor, n\u00eb sistemin operativ mysafir dhe, p\u00ebrfundimisht, n\u00eb aplikacionin SQL Server. Njohja e mir\u00eb e arkitektur\u00ebs harduerike NUMA \u00ebsht\u00eb nj\u00eb k\u00ebrkes\u00eb e domosdoshme p\u00ebr \u00e7do administrator t\u00eb baz\u00ebs s\u00eb t\u00eb dh\u00ebnave SQL Server q\u00eb punon me nj\u00eb instanc\u00eb t\u00eb virtualizuar t\u00eb SQL Server.<\/p>\n<p>P\u00ebr t\u00eb arritur efikasitet m\u00eb t\u00eb madh n\u00eb server\u00ebt me shum\u00eb b\u00ebrthama, Microsoft prezantoi SoftNUMA. SoftNUMA lejon ndarjen e burimeve t\u00eb disponueshme CPU brenda nj\u00eb NUMA n\u00eb disa nyje SoftNUMA. Sipas VMware, SoftNUMA \u00ebsht\u00eb e p\u00ebrputhshme me topologjin\u00eb e NUMA virtuale (vNUMA) t\u00eb VMware dhe mund t\u00eb optimizoj\u00eb m\u00eb tej shkallueshm\u00ebrin\u00eb dhe performanc\u00ebn e motorit t\u00eb DB p\u00ebr shumic\u00ebn e ngarkesave t\u00eb pun\u00ebs\u2026<\/p>\n<p>Kur virtualizoni VMware me SQL Server, p\u00ebrdorni:<\/p>\n<ul>\n<li>Monitorimin e makinave virtuale p\u00ebr t\u00eb zbuluar munges\u00ebn e burimeve t\u00eb memories p\u00ebr Motorin e Baz\u00ebs s\u00eb t\u00eb Dh\u00ebnave SQL Server. Ky problem \u00e7on n\u00eb rritjen e operacioneve t\u00eb hyrjes-daljes dhe zvog\u00eblimin e performanc\u00ebs.<\/li>\n<\/ul>\n<p><\/p>\n<ul>\n<li>P\u00ebr t\u00eb rritur performanc\u00ebn, parandaloni konfliktet e memories midis makinave virtuale duke evituar mbingarkes\u00ebn e memories n\u00eb nivelin e hostit ESXi.<\/li>\n<li>Mund t\u00eb shqyrtoni verifikimin e alokimit t\u00eb memories fizike NUMA p\u00ebr t\u00eb p\u00ebrcaktuar sasin\u00eb maksimale t\u00eb memories q\u00eb mund t'i caktohet makin\u00ebs virtuale brenda kufijve fizik\u00eb t\u00eb NUMA.<\/li>\n<li>N\u00ebse arritja e nj\u00eb performanc\u00eb adekuate \u00ebsht\u00eb q\u00ebllimi kryesor, konsideroni rezervimin e memories t\u00eb barabart\u00eb me at\u00eb t\u00eb alokuar. Kjo konfigurim garantohet q\u00eb makina virtuale t\u00eb marr\u00eb vet\u00ebm \u043f\u0430\u043c\u044f\u0442\u044c fizik.<\/li>\n<\/ul>\n<p><\/p>\n<h2>Ruajtja e virtualizuar<\/h2>\n<p>\nKonfigurimi i ruajtjes n\u00eb nj\u00eb mjedis t\u00eb virtualizuar k\u00ebrkon njohuri p\u00ebr infrastruktur\u00ebn e ruajtjes s\u00eb dh\u00ebnave. Ashtu si me NUMA, duhet t\u00eb kuptoni se si funksionojn\u00eb nivelet e ndryshme t\u00eb hyrjes-daljes \u2014 n\u00eb k\u00ebt\u00eb rast, nga aplikacioni n\u00eb VM deri te leximi dhe shkruarja fizike e informacionit n\u00eb nj\u00eb medium t\u00eb p\u00ebrhersh\u00ebm.<\/p>\n<p>vSphere ofron nj\u00eb s\u00ebr\u00eb opsionesh p\u00ebr konfigurimin e ruajtjes, t\u00eb cilat kan\u00eb aplikime t\u00eb dobishme n\u00eb implementimin e SQL Server me array Unity XT. FS VMFS \u00ebsht\u00eb metoda m\u00eb e p\u00ebrdorur p\u00ebr ruajtjen e t\u00eb dh\u00ebnave n\u00eb sisteme t\u00eb ruajtjes bllok, t\u00eb tilla si Unity XT. Array Unity XT \u00ebsht\u00eb niveli i posht\u00ebm, i p\u00ebrb\u00ebr\u00eb nga disqe fizik\u00eb q\u00eb paraqiten n\u00eb vSphere si disqe logjike (volume). Volume Unity XT jan\u00eb t\u00eb formatizuara si volume VMFS nga hipervizori ESXi. Administratoret e VMware krijojn\u00eb nj\u00eb ose m\u00eb shum\u00eb disqe virtuale (VMDK), t\u00eb cilat paraqiten nga sistemi operativ mysafir. RDM lejon q\u00eb makina virtuale t\u00eb aksesoj\u00eb drejtp\u00ebrdrejt ruajtjen bllokuese (p\u00ebrmes FC ose iSCSI) Unity XT pa formatizuar VMFS. Volume VMFS dhe RDM mund t\u00eb ofrojn\u00eb kapacitet t\u00eb nj\u00ebjt\u00eb p\u00ebr transaksione.\u00a0<\/p>\n<p>P\u00ebr ruajtjen e bazuar n\u00eb NFS p\u00ebr ESXi, Dell EMC rekomandon p\u00ebrdorimin e VMware NFS n\u00eb vend t\u00eb sistemeve t\u00eb dosjeve NFS t\u00eb zakonshme. Nj\u00eb makin\u00eb virtuale q\u00eb funksionon n\u00eb SQL Server dhe p\u00ebrdor VMDK n\u00eb ruajtjen e t\u00eb dh\u00ebnave NFS, nuk di p\u00ebr nivelin e ul\u00ebt t\u00eb NFS. Sistemi operativ mysafir e shikon makin\u00ebn virtuale si nj\u00eb server fizik n\u00ebn Windows Server dhe SQL Server. Disk\u00ebt e ndar\u00eb p\u00ebr konfigurimet e klastrit t\u00eb q\u00ebndruesh\u00ebm n\u00eb ruajtjet e t\u00eb dh\u00ebnave NFS nuk mb\u00ebshteten.<\/p>\n<p>Volume virtuale VMware vSphere (VVols) ofrojn\u00eb nj\u00eb menaxhim m\u00eb t\u00eb detajuar n\u00eb nivelin e makin\u00ebs virtuale, pavar\u00ebsisht nga pamja baz\u00eb e memories fizike (p.sh. volume ose sisteme dosjesh). Replikimi i bazuar n\u00eb array me VVols mb\u00ebshtetet q\u00eb nga VVol 2.0 (vSphere 6.5). Disku VVol mund t\u00eb p\u00ebrdoret si z\u00ebvend\u00ebsim p\u00ebr disku RDM p\u00ebr t\u00eb ofruar burimin disk t\u00eb nj\u00eb instance t\u00eb klas\u00eb t\u00eb q\u00ebndrueshme SQL, duke filluar nga vSphere 6.7, me mb\u00ebshtetje p\u00ebr rezervimin e p\u00ebrhersh\u00ebm p\u00ebrmes SCSI.<\/p>\n<h2>Rrjetat e virtualizuar<\/h2>\n<p>\nRrjeti n\u00eb bot\u00ebn virtuale ndjek t\u00eb nj\u00ebjtat koncepte logjike si n\u00eb bot\u00ebn fizike, por p\u00ebrdor softuer n\u00eb vend t\u00eb kabllove dhe switch-\u00ebve fizik\u00eb. Ndikimi i vones\u00ebs s\u00eb rrjetit mbi ngarkesat e pun\u00ebs SQL Server mund t\u00eb ndryshoj\u00eb ndjesh\u00ebm. Monitorimi i treguesve t\u00eb performanc\u00ebs s\u00eb rrjetit n\u00eb nj\u00eb ngarkes\u00eb ekzistuese ose n\u00eb nj\u00eb sistem testimi t\u00eb implementuar mir\u00eb gjat\u00eb nj\u00eb periudhe t\u00eb p\u00ebrfaq\u00ebsuar ndihmon n\u00eb krijimin e nj\u00eb rrjeti virtual.<\/p>\n<p>Kur p\u00ebrdorni virtualizimin VMware me SQL Server, duhet t\u00eb merrni parasysh k\u00ebt\u00eb:<\/p>\n<ul>\n<li>Si switch-ingjet virtuale standarde ashtu edhe ato t\u00eb shp\u00ebrndara ofrojn\u00eb funksionalitetin e nevojsh\u00ebm p\u00ebr SQL Server.<\/li>\n<li>P\u00ebr ndarjen logjike t\u00eb trafikut t\u00eb menaxhimit, vSphere vMotion dhe ruajtjen e rrjetit, p\u00ebrdorni etiketimin VLAN dhe grupe t\u00eb porteve t\u00eb switch-it virtual.<\/li>\n<li>VMware rekomandon fuqish\u00ebm aktivizimin e frame-\u00ebve t\u00eb m\u00ebdhenj n\u00eb switch-et virtuale t\u00eb cilat kan\u00eb trafik vSphere vMotion ose trafik iSCSI.<\/li>\n<li>N\u00eb p\u00ebrgjith\u00ebsi, respektoni rekomandimet e rrjetit p\u00ebr sistemet operative mysafire dhe pajisjet.<\/li>\n<\/ul>\n<p><\/p>\n<h2>\u00a0P\u00ebrfundimi\u00a0<\/h2>\n<p>\nMjediset e baza t\u00eb dh\u00ebnash SQL Server po b\u00ebhen gjithnj\u00eb e m\u00eb t\u00eb m\u00ebdha dhe komplekse. N\u00eb SQL Server 2019, Microsoft p\u00ebrmir\u00ebsoi funksionet themelore t\u00eb SQL Server dhe shtoi t\u00eb reja, t\u00eb tilla si mb\u00ebshtetje p\u00ebr ngarkesa t\u00eb dh\u00ebnash t\u00eb m\u00ebdha p\u00ebrmes Apache Spark dhe HDFS. Dell EMC, n\u00eb bashk\u00ebpunim me Microsoft, vazhdon t\u00eb ofroj\u00eb komponent\u00ebt e nevojsh\u00ebm t\u00eb infrastruktur\u00ebs p\u00ebr mjedisin SQL Server \u2014 server\u00ebt, ruajtjet dhe rrjetet.\u00a0<\/p>\n<p>Ne v\u00ebrejm\u00eb nj\u00eb rritje t\u00eb konsiderueshme t\u00eb koh\u00ebs s\u00eb disponueshm\u00ebris\u00eb dhe ulje t\u00eb kostos totale t\u00eb pron\u00ebs (TCO), n\u00ebse specialist\u00ebt e ruajtjes dhe t\u00eb bazave t\u00eb dh\u00ebnash punojn\u00eb s\u00eb bashku p\u00ebr t\u00eb krijuar zgjidhje infrastrukturore p\u00ebr SQL Server n\u00eb platformat me ruajtje t\u00eb p\u00ebrbashk\u00ebt. Flash-array Dell EMC Unity XT \u00ebsht\u00eb nj\u00eb zgjidhje e nivelit t\u00eb mes\u00ebm, e p\u00ebrshtatshme p\u00ebr zhvilluesit dhe administrator\u00ebt e SQL Server, t\u00eb cil\u00ebt k\u00ebrkojn\u00eb performanc\u00eb t\u00eb lart\u00eb dhe vonesa t\u00eb ul\u00ebta. Sistemi Unity XT All-Flash, i dizajnuar p\u00ebr t\u00eb funksionuar n\u00eb t\u00eb gjitha disk\u00ebt flash, mb\u00ebshtet procesor\u00eb dual-CPU, konfigurime me dy kontroler\u00eb dhe optimizim me shum\u00eb b\u00ebrthama.<\/p>\n<p>Nj\u00eb num\u00ebr gjithnj\u00eb e m\u00eb i madh organizatash po virtualizojn\u00eb ambientet e tyre SQL Server. Edhe pse virtualizimi shton nj\u00eb nivel tjet\u00ebr projektimi n\u00eb arktitektur\u00eb, ai ofron p\u00ebrfitime t\u00eb konsiderueshme. Shpresojm\u00eb se do t'ju ndihmojn\u00eb disa nga funksionet dhe mjetet m\u00eb t\u00eb p\u00ebrdorura t\u00eb VMware n\u00eb ambientet SQL Server, t\u00eb paraqitura m\u00eb lart. Ne gjithashtu rekomandojm\u00eb lidhje p\u00ebr burime p\u00ebr informacione m\u00eb t\u00eb detajuara.<\/p>\n<h2>Linqe t\u00eb dobishme<\/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\">Fleushin e Specifikimeve t\u00eb Seris\u00eb Dell EMC Unity XT Storage<\/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>Burimi: <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.0.1 - 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\/sq\/blog\/administrirovanie\/microsoft-sql-server-2019-i-flesh-massivy-dell-emc-unity-xt\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.0.1\" \/>\n\t\t<meta property=\"og:locale\" content=\"sq_AL\" \/>\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\/sq\/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 dhe flasht e Dell EMC Unity XT | ProHoster","description":"Sot \u00ebsht\u00eb parashikuar p\u00ebr t'ju njohur me ve\u00e7orit\u00eb e p\u00ebrdorimit t\u00eb SQL Server 2019 me sistemin e ruajtjes Unity XT, si dhe do t'ju jepni rekomandime p\u00ebr virtualizimin e SQL Server me teknologjin\u00eb VMware, si dhe p\u00ebr konfigurimin dhe menaxhimin.","canonical_url":"https:\/\/prohoster.info\/sq\/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":"sq_AL","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\/sq\/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\/sq\/wp-json\/wp\/v2\/posts\/53529","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/comments?post=53529"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/posts\/53529\/revisions"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/media?parent=53529"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/categories?post=53529"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/tags?post=53529"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}