{"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 nj\u00ebsit\u00eb flash Dell EMC Unity XT","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p>Sot\u00eb do t'ju njohim me ve\u00e7orit\u00eb e p\u00ebrdorimit t\u00eb SQL Server 2019 me sistemin e ruajtjes Unity XT, si dhe do t'i japim rekomandime p\u00ebr virtualizimin e SQL Server me teknologjin\u00eb VMware, p\u00ebr konfigurimin dhe menaxhimin e komponent\u00ebve baz\u00eb t\u00eb infrastrukturs 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 nj\u00ebsit\u00eb flash 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 \u2014 \"Transformimi i SQL Server: 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\">SQL Server Transformation: Toward Agility and Resiliency<\/a><\/noindex>), e cila p\u00ebrdori p\u00ebrvoj\u00ebn e an\u00ebtar\u00ebve t\u00eb Shoqat\u00ebs Profesionale t\u00eb SQL Server (Professional Association of SQL Server, PASS). Rezultatet tregojn\u00eb se mjediset e baz\u00ebs s\u00eb t\u00eb dh\u00ebnave SQL Server rriten si n\u00eb p\u00ebrmasa ashtu edhe n\u00eb kompleksitet, e cila \u00ebsht\u00eb e ndikuar nga rritja e sasis\u00eb s\u00eb t\u00eb dh\u00ebnave dhe k\u00ebrkesave t\u00eb reja t\u00eb biznesit. Baza t\u00eb dh\u00ebnash SQL Server aktualisht jan\u00eb t\u00eb implementuara n\u00eb shum\u00eb kompani, duke siguruar funksionimin e aplikacioneve kritike, dhe shpesh sh\u00ebrbejn\u00eb si baza e transformimit digjital.\u00a0<\/p>\n<p>Q\u00eb nga koha kur u zhvillua kjo anket\u00eb, Microsoft ka l\u00ebshuar brezin e ardhsh\u00ebm t\u00eb DBMS \u2014 SQL Server 2019. P\u00ebrve\u00e7 p\u00ebrmir\u00ebsimit t\u00eb funksioneve kryesore t\u00eb motorit relacional dhe ruajtjes s\u00eb t\u00eb dh\u00ebnave, 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 me t\u00eb dh\u00ebna t\u00eb 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 bashk\u00ebpunojn\u00eb n\u00eb zhvillimin e zgjidhjeve p\u00ebr SQL Server. Zbatimi i suksessh\u00ebm i nj\u00eb platforme komplekse baze t\u00eb dh\u00ebnash, si\u00e7 \u00ebsht\u00eb Microsoft SQL Server, k\u00ebrkon koordinimin e funksioneve t\u00eb softuerit me infrastruktur\u00ebn baz\u00eb IT. Kjo infrastruktur\u00eb p\u00ebrfshin kapacitetin e llogaritjes s\u00eb procesor\u00ebve, burimet e memories, ruajtjen dhe sh\u00ebrbimet rrjet. Dell EMC ofron infrastruktur\u00ebn p\u00ebr platform\u00ebn SQL Server p\u00ebr \u00e7do lloj ngarkese dhe aplikacionesh.<\/p>\n<p>Seria e server\u00ebve Dell EMC PowerEdge ofron nj\u00eb mori konfiguracionesh p\u00ebr procesor\u00ebt dhe memorien. 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 m\u00eb t\u00eb m\u00ebdha kritike, si planifikimi i burimeve t\u00eb nd\u00ebrmarrjeve (ERP), magazinimi i t\u00eb dh\u00ebnave, analiza e avancuar, tregtia elektronike, etj. Seria e sistem\u00ebve t\u00eb ruajtjes \u00ebsht\u00eb e dizajnuar p\u00ebr ruajtjen e t\u00eb dh\u00ebnave t\u00eb strukturuara dhe t\u00eb pa strukturuara.\u00a0<\/p>\n<p>Klient\u00ebt q\u00eb zhvillojn\u00eb SQL Server 2019 me infrastruktur\u00eb 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 t\u00eb teknologjive t\u00eb qasjes nga klienti, komunikimeve midis server\u00ebve dhe komunikimeve \"server-magazin\u00eb\". Koncepti Dell EMC bazohet n\u00eb nj\u00eb model t\u00eb disaggreguar, duke ofruar nj\u00eb ekosistem t\u00eb hapur. Organi mund t\u00eb zgjedhin nga nj\u00eb gam\u00eb t\u00eb gjer\u00eb aplikacionesh rrjetesh standarde industriale, sisteme operative dhe platforma harduerike. Ky qasje ofron kontroll maksimal mbi teknologjit\u00eb dhe arkitekturat, duke rezultuar n\u00eb kursime t\u00eb dukshme dhe fleksibilitet.<\/p>\n<p>VMware ofron virtualizimin e t\u00eb gjitha komponent\u00ebve kritik\u00eb t\u00eb infrastruktur\u00ebs q\u00eb nevojiten p\u00ebr SQL Server p\u00ebr t\u00eb arritur performanc\u00eb t\u00eb lart\u00eb dhe koherenc\u00eb operimesh. P\u00ebrve\u00e7 mjeteve private, VMware aktualisht ofron gjithashtu modele hibride p\u00ebr ngarkesat e pun\u00ebs, q\u00eb mbulojn\u00eb arkitekturat private dhe publike t\u00eb mjeteve n\u00eb cloud.\u00a0<\/p>\n<p>Shum\u00eb organizata ndodhen n\u00eb virtualizim p\u00ebr t\u00eb ulur kostot e infrastruktur\u00ebs, p\u00ebr t\u00eb siguruar disponibilitet t\u00eb lart\u00eb dhe p\u00ebr t\u00eb thjeshtuar rikuperimin nga fatkeq\u00ebsit\u00eb. 94% e specialist\u00ebve t\u00eb SQL Server t\u00eb anketuar raportojn\u00eb p\u00ebr nj\u00eb nivel t\u00eb ndonj\u00eb forme virtualizimi n\u00eb mjedisin e tyre. 70% e atyre q\u00eb p\u00ebrdorin virtualizimin, zgjedhin VMware. 60% e nivelit t\u00eb virtualizimit t\u00eb SQL Server \u00ebsht\u00eb 75% ose m\u00eb shum\u00eb. P\u00ebr m\u00eb tep\u00ebr, rezultatet e anketimeve tregojn\u00eb bindsh\u00ebm se disponibiliteti i lart\u00eb dhe rikuperimi nga fatkeq\u00ebsit\u00eb t\u00eb realizuara n\u00eb nivelin e virtualizimit jan\u00eb b\u00ebr\u00eb faktor\u00eb t\u00eb r\u00ebnd\u00ebsish\u00ebm p\u00ebr vendimmarrjen n\u00eb lidhje me 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>\nPlatformat e bazave t\u00eb dh\u00ebnash SQL Server 2019 p\u00ebrfshin nj\u00eb gam\u00eb t\u00eb gjer\u00eb teknologjish, funksionesh dhe sh\u00ebrbimesh q\u00eb mb\u00ebshtesin aplikacionet kritik\u00eb, si\u00e7 jan\u00eb analitika, bazat e t\u00eb dh\u00ebnave t\u00eb nd\u00ebrmarrjeve, analitika e biznesit (BI) dhe p\u00ebrpunimi i transaksioneve t\u00eb shkall\u00ebzuara (OLTP). Platforma SQL Server ka fituar mund\u00ebsi p\u00ebr menaxhimin e integrimit t\u00eb t\u00eb dh\u00ebnave, magazinave t\u00eb t\u00eb dh\u00ebnave, raportimit dhe analitik\u00ebs s\u00eb avancuar, funksioneve t\u00eb replikimit dhe menaxhimit t\u00eb llojeve t\u00eb dh\u00ebnash pjes\u00ebrisht t\u00eb 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 e SQL Server me an\u00eb t\u00eb virtualizimit.\u00a0<\/p>\n<p>Sot, nd\u00ebrmarrjeve shpesh u duhet t\u00eb mb\u00ebshteten n\u00eb sasi t\u00eb m\u00ebdha t\u00eb dh\u00ebnash nga nj\u00eb gam\u00eb t\u00eb gjer\u00eb t\u00eb grupeve t\u00eb t\u00eb dh\u00ebnave q\u00eb rriten vazhdimisht. Me SQL Server 2019, ju mund t\u00eb merrni informacion t\u00eb vlefsh\u00ebm pothuajse n\u00eb koh\u00eb reale nga t\u00eb gjitha t\u00eb dh\u00ebnat. Klasteret SQL Server 2019 ofrojn\u00eb nj\u00eb mjedis t\u00eb plot\u00eb p\u00ebr t\u00eb punuar me grupe t\u00eb m\u00ebdha t\u00eb dh\u00ebnash, duke p\u00ebrfshir\u00eb p\u00ebr p\u00ebrdorim t\u00eb m\u00ebsimit t\u00eb makineris\u00eb dhe mund\u00ebsive t\u00eb inteligjenc\u00ebs artificiale. Karakteristikat dhe p\u00ebrmir\u00ebsimet kryesore t\u00eb reja n\u00eb SQL Server 2019 jan\u00eb t\u00eb listuara 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\">dokumenin e Microsoft<\/a><\/noindex>.<\/p>\n<h2>Sistemi i ruajtjes Dell EMC Unity XT p\u00ebr klas\u00ebn e mesme<\/h2>\n<p>\nSeria e SFXH-ve Dell EMC Unity u shfaq 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 klas\u00ebs s\u00eb mesme p\u00ebr thjesht\u00ebsin\u00eb, performanc\u00ebn dhe efikasitetin e kostos. Platformat e klas\u00ebs s\u00eb mesme Dell EMC Unity XT jan\u00eb zgjidhje me magazinim t\u00eb p\u00ebrbashk\u00ebt q\u00eb ofrojn\u00eb vonesa t\u00eb ulta, kapacitet t\u00eb lart\u00eb dhe kosto t\u00eb ul\u00ebta menaxhimi 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 mbajtur hyrjen\/dalin\u00eb dhe p\u00ebr t\u00eb kryer operacione me t\u00eb dh\u00ebna n\u00eb modalitetin aktive\/aktive. N\u00eb Unity XT dual SP, p\u00ebr t\u00eb siguruar performanc\u00eb t\u00eb lart\u00eb dhe efikasitet, p\u00ebrdoret nj\u00eb lidhje e plot\u00eb SAS 12 Gbit\/s dhe nj\u00eb arkitektur\u00eb e shum\u00ebp\u00ebrb\u00ebr\u00eb e patentuar. Sistemet e diskut lejojn\u00eb zgjerimin e kapacitetit t\u00eb ruajtjes me an\u00eb t\u00eb rafteve shtes\u00eb.<\/p>\n<p><img decoding=\"async\" alt=\"Microsoft SQL Server 2019 dhe nj\u00ebsit\u00eb flash 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, gjenerat\u00ebn e re t\u00eb sistemeve t\u00eb ruajtjes (hibrid\u00eb dhe t\u00ebr\u00ebsisht me flash), performanca ka p\u00ebsuar nj\u00eb rritje t\u00eb ndjeshme, efikasiteti \u00ebsht\u00eb rritur, dhe jan\u00eb shtuar mund\u00ebsi dhe sh\u00ebrbime t\u00eb reja p\u00ebr ambientet multi-cloud.\u00a0<\/p>\n<p>Arkitektura e Unity XT lejon p\u00ebrpunimin e m\u00eb shum\u00eb t\u00eb dh\u00ebnave nj\u00ebher\u00ebsh, redukton volumet e tyre dhe mb\u00ebshtet sh\u00ebrbime si replikimi pa e d\u00ebmton performanc\u00ebn e aplikacioneve. Krahasuar me zgjidhjen e gjenerat\u00ebs s\u00eb m\u00ebparshme, performanca e sistemi t\u00eb ruajtjes Dell EMC Unity XT \u00ebsht\u00eb dyfishuar, dhe koha e p\u00ebrgjigjes \u00ebsht\u00eb zvog\u00ebluar me 75%. Sigurisht, Dell EMC Unity mb\u00ebshtet standardin NVMe.<\/p>\n<p>Sistemet e ruajtjes me disqe NVMe tregojn\u00eb performanc\u00ebn m\u00eb t\u00eb mir\u00eb n\u00eb aplikacione q\u00eb jan\u00eb t\u00eb ndjeshme ndaj vonesave. P\u00ebr shembull, n\u00eb aplikacione si bazat e t\u00eb dh\u00ebnave masive, NVMe ofron vonesa t\u00eb vogla dhe shpejt\u00ebsi t\u00eb larta transferimi. 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 parashikimeve t\u00eb IDC, deri n\u00eb vitin 2021, sistemet flash me lidhje 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>Ekonomit\u00eb n\u00eb ruajtje 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 dedupikimi kryhen n\u00eb m\u00ebnyr\u00eb inline \u2014 n\u00eb nivelin e kontroler\u00ebve. T\u00eb dh\u00ebnat ruhen n\u00eb nj\u00eb form\u00eb t\u00eb kompresuar. Sistemi gjithashtu automatizon pun\u00ebn me snapshot-et e t\u00eb dh\u00ebnave.<\/p>\n<p>Sistemet e ruajtjes flash Unity jan\u00eb t\u00eb lehta p\u00ebr t'u p\u00ebrdorur dhe ofrojn\u00eb akses t\u00eb unifikuar (blok dhe skedar) me vonesa stabile t\u00eb p\u00ebrgjigjes, integrohen me sh\u00ebrbimet e ruajtjes n\u00eb cloud dhe mb\u00ebshtesin p\u00ebrmir\u00ebsimin pa migrimin e t\u00eb dh\u00ebnave. N\u00eb konfigurimin baz\u00eb, ky sistem universalisht i ruajtjes mund t\u00eb instalohet brenda 30 minutash.<\/p>\n<p>Teknologjia e ruajtjes s\u00eb t\u00eb dh\u00ebnave e quajtur \"pula dinamike\" lejon kalimin nga nj\u00eb rritje statike n\u00eb nj\u00eb rritje dinamike t\u00eb memorie, ofron fleksibilitet t\u00eb lart\u00eb operativ dhe leht\u00ebsi n\u00eb rritjen e kapacitetit t\u00eb sistemit. Pulat dinamike kursejn\u00eb kapacitetin dhe buxhetin, k\u00ebrkojn\u00eb m\u00eb pak koh\u00eb p\u00ebr rind\u00ebrtim. Rritja e kapacitetit dhe performanc\u00ebs s\u00eb Dell EMC Unity nuk k\u00ebrkon migrim t\u00eb t\u00eb dh\u00ebnave.\u00a0<\/p>\n<p>Shum\u00eb kompani sot, p\u00ebrve\u00e7 infrastruktur\u00ebs s\u00eb tyre lokale, p\u00ebrdorin disa sh\u00ebrbime publike t\u00eb remeve t\u00eb dh\u00ebnash. Dell EMC Unity XT mund t\u00eb funksionoj\u00eb si nj\u00eb komponent i mjedisit t\u00eb remeve t\u00eb Dell Technologies Cloud. Kjo pajisje e ruajtjes s\u00eb t\u00eb dh\u00ebnave mund t\u00eb p\u00ebrdoret n\u00eb re publike dhe t\u00eb transferoj\u00eb t\u00eb dh\u00ebna n\u00eb re private. P\u00ebr m\u00eb tep\u00ebr, pajisja e ruajtjes Dell EMC Unity XT \u00ebsht\u00eb e disponueshme n\u00eb modelin \"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 \/>\nSh\u00ebrbimet e ruajtjes n\u00eb re po marrin popullaritet n\u00eb rritje, pasi ofrojn\u00eb rritje t\u00eb kthimit mbi investimet duke reduktuar kostot e infrastruktur\u00ebs. Sh\u00ebrbimet e ruajtjes n\u00eb re Cloud Storage Services zgjerojn\u00eb qendrat e t\u00eb dh\u00ebnave t\u00eb klient\u00ebve n\u00eb re, duke ofruar ruajtje Dell EMC (e lidhur drejtp\u00ebrdrejt me burimet e remeve publike) si sh\u00ebrbim. Ofrues t\u00eb pal\u00ebve t\u00eb treta mund t\u00eb sigurojn\u00eb lidhje me shpejt\u00ebsi t\u00eb lart\u00eb (me vones\u00eb t\u00eb ul\u00ebt) t\u00eb remeve publike drejtp\u00ebrdrejt me sistemet Dell EMC Unity, PowerMax dhe Isilon n\u00eb qendr\u00ebn 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>Masivat e unifikuara hibride dhe flash\u00a0<\/h2>\n<p>\nSistemet e ruajtjes Unity XT Hybrid dhe Unity XT All-Flash, q\u00eb bazohen n\u00eb procesor\u00ebt Intel, realizojn\u00eb nj\u00eb arkitektur\u00eb t\u00eb integruar p\u00ebr aksesin n\u00eb blloqe, skedar\u00eb dhe volume VMware VVols me mb\u00ebshtetje p\u00ebr protokollet e ruajtjes n\u00eb rrjet (NAS), iSCSI dhe Fibre Channel (FC). Platforma Unity XT Hybrid dhe Unity XT All-Flash jan\u00eb t\u00eb gatshme p\u00ebr t\u00eb p\u00ebrdorur disqet NVMe.<\/p>\n<p>Sistemet hibride Unity XT mb\u00ebshtesin operimin n\u00eb mjedise multi-re. Mb\u00ebshtetja p\u00ebr mjediset multi-re do t\u00eb thot\u00eb zgjerimin e sistemit t\u00eb ruajtjes s\u00eb t\u00eb dh\u00ebnave n\u00eb re ose shkarkimin n\u00eb re me mund\u00ebsi fleksib\u00ebl p\u00ebr p\u00ebrdorimin e burimeve. Ruajtjet multi-re synojn\u00eb t\u00eb sigurojn\u00eb l\u00ebvizshm\u00ebri, portabilitet t\u00eb t\u00eb dh\u00ebnave midis shum\u00eb platformave re \u2013 private dhe publike. Kjo ndikon jo vet\u00ebm n\u00eb proceset e l\u00ebvizjes s\u00eb t\u00eb dh\u00ebnave, por edhe n\u00eb organizimin e qasjes s\u00eb aplikacioneve n\u00eb t\u00eb dh\u00ebna n\u00eb disa re publike. <\/p>\n<p><img decoding=\"async\" alt=\"Microsoft SQL Server 2019 dhe nj\u00ebsit\u00eb flash Dell EMC Unity XT\" src=\"\/wp-content\/uploads\/2019\/12\/d61d5fa31b94676109c89338070dbf0b.jpg\" style=\"display:block;margin: 0 auto;\" \/><br \/>\nK\u00ebto masiva hibride ofrojn\u00eb mund\u00ebsit\u00eb e m\u00ebposhtme:<\/p>\n<ul>\n<li>Mund\u00ebsi p\u00ebr t\u00eb shkall\u00ebzuar deri n\u00eb 16 PB kapaciteti \"t\u00eb pap\u00ebrpunuar\".<\/li>\n<li>Funksionet e nd\u00ebrtuara p\u00ebr reduktimin e volumit t\u00eb t\u00eb dh\u00ebnave p\u00ebr t\u00eb gjitha grupet e flash.<\/li>\n<li>Instalim dhe konfigirim t\u00eb shpejt\u00eb (n\u00eb mesatarje zgjat 25 minuta).<\/li>\n<\/ul>\n<p>\nTeknologjit e ndihm\u00ebs s\u00eb kujtes\u00ebs s\u00eb ngurt\u00eb po p\u00ebrmir\u00ebsohen me shpejt\u00ebsi, dhe n\u00eb vitet e ardhshme produkte revolucionar\u00eb t\u00eb rinj do t\u00eb dalin n\u00eb treg. Nd\u00ebrkoh\u00eb, organizatat do t\u00eb vazhdojn\u00eb t\u00eb z\u00ebvend\u00ebsojn\u00eb disk\u00ebt tradicional\u00eb HDD me ndihm\u00ebs t\u00eb kujtes\u00ebs s\u00eb ngurt\u00eb p\u00ebr t\u00eb p\u00ebrmir\u00ebsuar performanc\u00ebn, thjesht\u00ebsin\u00eb e menaxhimit dhe kursimin e energjis\u00eb. Generatat e reja t\u00eb sistemeve flash do t\u00eb ve\u00e7ohen p\u00ebr mjete m\u00eb t\u00eb avancuara t\u00eb automatizimit t\u00eb ruajtjes, integreve me re publike dhe mbrojtjes s\u00eb 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 disa re. Karakteristikat 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>Instalim dhe konfigurim t\u00eb shpejt\u00eb (pro\u00e7esi zgjat m\u00eb pak se 30 minuta).<\/li>\n<\/ul>\n<p><\/p>\n<h2>\u00a0UnityVSA<\/h2>\n<p>\nSistemi UnityVSA \u00ebsht\u00eb nj\u00eb sistem i ruajtjes s\u00eb t\u00eb dh\u00ebnave t\u00eb definuar nga softueri p\u00ebr mjediset virtuale VMware ESXi, q\u00eb p\u00ebrdor kapacitetin e ruajtjes serverike, t\u00eb p\u00ebrbashk\u00ebt ose n\u00eb re. UnityVSA HA, nj\u00eb konfigurim me dy ruajtje UnityVSA, ofron disponueshm\u00ebri t\u00eb shtuar. Ruajtja UnityVSA ofron:<\/p>\n<ul>\n<li>Derisa 50 TB kapacitet t\u00eb ruajtjes s\u00eb unifikuar me funksionalitete t\u00eb plota.<\/li>\n<li>P\u00ebrputhshm\u00ebri me sistemet dhe funksionalitetet e Unity XT.<\/li>\n<li>Mb\u00ebshtetje p\u00ebr sistemet me disponueshm\u00ebri t\u00eb lart\u00eb (UnityVSA HA).<\/li>\n<li>Lidhje si NAS dhe iSCSI.<\/li>\n<li>Replikimin e 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 skedar\u00ebve dhe operacioneve t\u00eb rikuperimit t\u00eb fatkeq\u00ebsis\u00eb me re, familja e Unity XT p\u00ebrfshin versionin Unity Cloud Edition, i cili ofron:<\/p>\n<ul>\n<li>Kapacitete t\u00eb plota ruajtjeje duke p\u00ebrdorur SAK (Sistemin e Ruajtjes s\u00eb Definuar nga Softueri), t\u00eb vendosur n\u00eb re.<\/li>\n<li>Zhvillim t\u00eb thjesht\u00eb t\u00eb ruajtjes bllok dhe skedar\u00ebsh me VMware Cloud n\u00eb AWS.<\/li>\n<li>Mb\u00ebshtetje p\u00ebr rikuperimin nga fatkeq\u00ebsit\u00eb, duke p\u00ebrfshir\u00eb testimin dhe analizimin e t\u00eb dh\u00ebnave.<\/li>\n<\/ul>\n<p>\n<img decoding=\"async\" alt=\"Microsoft SQL Server 2019 dhe nj\u00ebsit\u00eb flash 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 e Unisphere Research p\u00ebr vitin 2017 \"Transformimi i SQL Server: n\u00eb rrug\u00ebn drejt fleksibilitetit dhe disponueshm\u00ebris\u00eb\" (<noindex><a rel=\"nofollow\" href=\"http:\/\/www.dbta.com\/DBTA-Downloads\/ResearchReports\/SQL-Server-Transformation-Toward-Agility-and-Resiliency-6705.aspx\">SQL Server Transformation: Toward Agility and Resiliency<\/a><\/noindex>) 22% e t\u00eb anketuarve raportuan se po p\u00ebrdorin teknologjin\u00eb e ruajtjes me flash n\u00eb prodhim (16%) ose planifikojn\u00eb ta b\u00ebjn\u00eb k\u00ebt\u00eb (6%). 30% aplikojn\u00eb sisteme hibride, duke p\u00ebrfshir\u00eb kujtes\u00ebn me flash. 13% p\u00ebrdorin sisteme flash me lidhje direkte. 13% b\u00ebjn\u00eb kopje rezerv\u00eb t\u00eb bazave t\u00eb t\u00eb dh\u00ebnave SQL Server n\u00eb ruajtjen me flash.<\/p>\n<p>Ky implementimi i shpejt\u00eb i magazinave flash p\u00ebr p\u00ebrdorim me SQL Server do t\u00eb thot\u00eb se array-t e Unity XT All-Flash jan\u00eb ve\u00e7an\u00ebrisht t\u00eb p\u00ebrshtatshme p\u00ebr zhvilluesit dhe administrator\u00ebt e SQL Server. Sistemat 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 e zakonshme t\u00eb magazinimit (SAN).<\/p>\n<p><img decoding=\"async\" alt=\"Microsoft SQL Server 2019 dhe nj\u00ebsit\u00eb flash 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 implementim NVMe (p\u00ebr nj\u00eb performanc\u00eb m\u00eb t\u00eb lart\u00eb dhe vones\u00eb m\u00eb t\u00eb ul\u00ebt), kan\u00eb form\u00ebn e 2U, mb\u00ebshtesin procesor\u00eb me dy b\u00ebrthama, dy kontroler\u00eb n\u00eb modalitetin aktive\/aktive.<\/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>Memoria (p\u00ebr procesor)<\/p>\n<p>Numri maksimal i disqeve<\/p>\n<p>Kapaciteti maksimal 'i 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 mund t\u00eb gjenden n\u00eb specifikimet e array-it (<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\">Flet\u00eb specifikimi e Seris\u00eb Dell EMC Unity XT Storage<\/a><\/noindex>).<\/p>\n<h2>Grupet e magazinimit<\/h2>\n<p>\nShum\u00eb profesionist\u00eb q\u00eb punojn\u00eb me SQL Server e din\u00eb se t\u00eb gjith\u00eb array-t moderne t\u00eb magazinimit p\u00ebrcaktojn\u00eb mund\u00ebsin\u00eb p\u00ebr t\u00eb grumbulluar disqet n\u00eb nj\u00ebsi m\u00eb t\u00eb m\u00ebdha magazinimi me nj\u00eb nivel t\u00eb caktuar mbrojtjeje RAID. Grumbujt e ndar\u00eb t\u00eb disqeve me mbrojtje RAID jan\u00eb grupet tradicionale t\u00eb magazinimit. Nd\u00ebrsa sistemet hibride Unity XT mb\u00ebshtesin vet\u00ebm grupet tradicionale, array-t Unity XT All-Flash gjithashtu ofrojn\u00eb grupe dinamike magazinimi. N\u00eb rastin e grupeve dinamike, mbrojtja RAID aplikohet n\u00eb ekstentet e disqeve - nj\u00ebsit\u00eb e magazinimit m\u00eb t\u00eb vogla se disku i plot\u00eb. Grupe 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 magazinimit p\u00ebr t\u00eb arritur performanc\u00eb maksimale me nd\u00ebrlikim minimal. P\u00ebr shembull, rekomandohet t\u00eb minimizohet numri i grupeve t\u00eb magazinimit Unity XT, p\u00ebr t\u00eb ulur kompleksitetin dhe p\u00ebr t\u00eb rritur fleksibilitetin. Megjithat\u00eb, konfiguruar grupe t\u00eb tjera magazinimi mund t\u00eb jet\u00eb shum\u00eb e arsyeshme n\u00eb disa raste, p\u00ebrfshir\u00eb kur ju nevojitet:<\/p>\n<ul>\n<li>T\u00eb mbani ngarkesa t\u00eb ve\u00e7anta pune me profile t\u00eb ndryshme hyrjeje\/kuarjeje.<\/li>\n<li>T\u00eb ndaj\u00eb burime p\u00ebr t\u00eb arritur parametrat specifik t\u00eb performanc\u00ebs.<\/li>\n<li>T\u00eb ndaj\u00eb burime t\u00eb ve\u00e7anta p\u00ebr multi-bler\u00ebsit.<\/li>\n<li>T\u00eb krijoj\u00eb zona m\u00eb t\u00eb vogla p\u00ebr mbrojtje nga d\u00ebshtimi<\/li>\n<\/ul>\n<p><\/p>\n<h2>V\u00ebllimet e magazinimit (LUN)<\/h2>\n<p>\nSi si mund t\u00eb arrini nj\u00eb kompromis midis menaxhimit dhe fleksibilitetit kur b\u00ebni zgjedhjen e numrit t\u00eb volumend\u00eb n\u00eb nj\u00eb sistem? P\u00ebr fleksibilitet maksimal n\u00eb Unity me SQL Server, rekomandohet q\u00eb t\u00eb krijoni volumin p\u00ebr secil\u00ebn skedar t\u00eb baz\u00ebs s\u00eb t\u00eb dh\u00ebnave. N\u00eb praktik\u00eb, shumica e organizatave zbatojn\u00eb nj\u00eb qasje t\u00eb shum\u00eb-niv\u00ebshme, ku bazat e t\u00eb dh\u00ebnave t\u00eb r\u00ebnd\u00ebsishme marrin fleksibilitet maksimal, nd\u00ebrsa skedar\u00ebt e bazave t\u00eb dh\u00ebnave m\u00eb pak t\u00eb r\u00ebnd\u00ebsishme grupohen n\u00eb numra m\u00eb t\u00eb vog\u00ebl volumesh t\u00eb m\u00ebdha. Ne 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 dhe monitorimit t\u00eb t\u00eb dh\u00ebnave varen nga izolatimi dhe lokalizimi i skedar\u00ebve.<\/p>\n<p>Menaxhimi i volumend\u00ebve t\u00eb shumt\u00eb shpesh \u00ebsht\u00eb i v\u00ebshtir\u00eb, ve\u00e7an\u00ebrisht n\u00eb mjedise virtuale. Mjediset virtuale t\u00eb SQL Server jan\u00eb nj\u00eb shembull i mir\u00eb kur ka kuptim t\u00eb vendosen disa lloje skedar\u00ebsh n\u00eb nj\u00eb volum. Administratori i baz\u00ebs s\u00eb t\u00eb dh\u00ebnave ose administrator i ruajtjes (ose t\u00eb dy) duhet t\u00eb gjejn\u00eb balancimin e duhur midis fleksibilitetit dhe leht\u00ebsis\u00eb s\u00eb mir\u00ebmbajtjes kur p\u00ebrcaktojn\u00eb numrin e volumend\u00ebve q\u00eb krijohen.<\/p>\n<h2>Ruajtja e skedar\u00ebve<\/h2>\n<p>\nServer\u00ebt NAS vendosin sistemet e skedar\u00ebve n\u00eb sistemin e ruajtjes Unity XT. Sistemet e skedar\u00ebve mund t\u00eb aksesohen p\u00ebrmes protokolleve SMB ose NFS, dhe p\u00ebr shkak t\u00eb sistemit t\u00eb skedar\u00ebve shum\u00eb-protokollor, \u00ebsht\u00eb e mundur t\u00eb p\u00ebrdoren t\u00eb dy protokollet nj\u00ebkoh\u00ebsisht. P\u00ebr lidhjen e host\u00ebve me sistemet shum\u00eb-protokollore t\u00eb skedar\u00ebve, si dhe me ruajtjet e dh\u00ebnave VMware NFS dhe volumet virtuale VMware, server\u00ebt NAS p\u00ebrdorin nd\u00ebrfaqe virtuale. Sistemet e skedar\u00ebve dhe nd\u00ebrfaqet virtuale jan\u00eb t\u00eb izoluara brenda nj\u00eb serveri NAS, duke mund\u00ebsuar p\u00ebrdorimin e disa server\u00ebve NAS p\u00ebr multi-qiramarrje. Server\u00ebt NAS kalojn\u00eb automatikisht n\u00eb rezerv\u00eb n\u00eb rast d\u00ebshtimi, n\u00ebse procesori i ruajtjes d\u00ebshton. Sistemet e skedar\u00ebve t\u00eb lidhura gjithashtu kalojn\u00eb n\u00eb rezerv\u00eb n\u00eb rast d\u00ebshtimi.<\/p>\n<p>SQL Server 2012 (11.x) dhe versionet m\u00eb t\u00eb reja mb\u00ebshtesin protokollin Server Message Block (SMB) 3.0, i cili lejon ndarjen e nj\u00eb skedari rrjeti p\u00ebr ruajtje. Si p\u00ebr instalimin autonom, ashtu edhe p\u00ebr klasterin me toleranc\u00eb ndaj d\u00ebshtimit, mund t\u00eb instaloni bazat e t\u00eb dh\u00ebnave sistemike (master, model, msdb dhe tempdb) dhe bazat e t\u00eb dh\u00ebnave t\u00eb p\u00ebrdoruesve t\u00eb Database Engine me opsionin e ruajtjes SMB. P\u00ebrdorimi i ruajtjes SMB \u00ebsht\u00eb nj\u00eb mund\u00ebsi e mir\u00eb kur p\u00ebrdoren grupet me disponueshm\u00ebri t\u00eb lart\u00eb Always On Availability Groups, pasi k\u00ebrkohet qasje n\u00eb nj\u00eb burim rrjeti me disponueshm\u00ebri t\u00eb lart\u00eb p\u00ebr burimin e p\u00ebrbashk\u00ebt t\u00eb skedar\u00ebve.<\/p>\n<p>Krijimi i burimeve t\u00eb p\u00ebrbashk\u00ebta SMB p\u00ebr shp\u00ebrndarjen e SQL Server me ruajtje Unity XT \u00ebsht\u00eb nj\u00eb proces i thjesht\u00eb me tre hapa: nevojitet krijimi i nj\u00eb serveri NAS, nj\u00eb sistemi skedari dhe nj\u00eb burimi t\u00eb p\u00ebrbashk\u00ebt SMB. Softuari Dell EMC Unisphere Storage Management p\u00ebrfshin nj\u00eb utilitare t\u00eb konfigurimit q\u00eb do t\u00eb ndihmoj\u00eb n\u00eb realizimin e k\u00ebtij procesi. Megjithat\u00eb, kur vendosni ngarkesat e pun\u00ebs SQL Server n\u00eb burimet e p\u00ebrbashk\u00ebta SMB, nuk duhet harruar 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 p\u00ebrpiluar nj\u00eb list\u00eb t\u00eb pyetjeve t\u00eb instalimit dhe siguris\u00eb si dhe problemeve t\u00eb njohura p\u00ebr momentin; detaje mund t\u00eb shihni n\u00eb seksionin \"Instalimi i SQL Server me ruajtje skedari 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 e Microsoft<\/a><\/noindex>.<\/p>\n<h2>Fotografit\u00eb e 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 sot mjediset kritike k\u00ebrkojn\u00eb jo vet\u00ebm rezervim. \u00cbsht\u00eb e nevojshme q\u00eb aplikacionet t\u00eb jen\u00eb gjithmon\u00eb n\u00eb linj\u00eb, duke siguruar operacione dhe azhurnime t\u00eb vazhdueshme. Ato gjithashtu k\u00ebrkojn\u00eb performanc\u00eb t\u00eb lart\u00eb dhe disponueshm\u00ebri t\u00eb t\u00eb dh\u00ebnave p\u00ebrmes opsioneve si replikimi lokal i fotografive dhe replikimi i larg\u00ebt.<\/p>\n<p>Sistemi i ruajtjes Unity XT ofron mund\u00ebsi p\u00ebr krijimin e fotografive p\u00ebr blloqe dhe skedar\u00eb, duke p\u00ebrdorur procese, operacione dhe arkitektur\u00eb t\u00eb p\u00ebrbashk\u00ebt. Metodologjia e fotografive Unity siguron nj\u00eb m\u00ebnyr\u00eb t\u00eb thjesht\u00eb dhe efektive p\u00ebr mbrojtjen e t\u00eb dh\u00ebnave. Fotografit\u00eb e leht\u00ebsojn\u00eb rikuperimin e t\u00eb dh\u00ebnave \u2014 kthim n\u00eb nj\u00eb fotografi m\u00eb t\u00eb hershme, ose mund t\u00eb kopjoni t\u00eb dh\u00ebnat e zgjedhura nga nj\u00eb fotografi t\u00eb m\u00ebparshme. N\u00eb tabel\u00ebn n\u00eb vazhdim, jepen periudhat e ruajtjes s\u00eb fotografive p\u00ebr sistemet Unity XT.<\/p>\n<h2>Ruajtja lokale dhe e larg\u00ebt e fotografive t\u00eb t\u00eb dh\u00ebnave<\/h2>\n<p><\/p>\n<p>Lloji i fotografis\u00eb<\/p>\n<p>CLI<br \/>\nUI<br \/>\nREST<\/p>\n<p>Dore\u00a0<\/p>\n<p>Me orar\u00a0<\/p>\n<p>Dore\u00a0<\/p>\n<p>Me orar\u00a0<\/p>\n<p>Dore\u00a0<\/p>\n<p>Me orar\u00a0<\/p>\n<p>Lokal\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\u00ebt\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 backup-i. Ato mund t\u00eb plot\u00ebsojn\u00eb tradicionale backup-in si nj\u00eb linj\u00eb t\u00eb par\u00eb mbrojtjeje p\u00ebr skenar\u00ebt me RTO t\u00eb ul\u00ebt.<\/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 funksionalitetin e reduktimit t\u00eb volumit, t\u00eb dh\u00ebnat n\u00eb burim mund t\u00eb kompresohen ose t\u00eb deduplikohen.<\/p>\n<p>Ja disa v\u00ebrejtje p\u00ebr rikuperimin e baz\u00ebs s\u00eb t\u00eb dh\u00ebnave duke p\u00ebrdorur snapshot-e 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 jen\u00eb pjes\u00eb e nj\u00eb grupi t\u00eb q\u00ebndruesh\u00ebm. Grupi i q\u00ebndruesh\u00ebm garanton q\u00eb snapshot-i do t\u00eb realizohet 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, ato burime t\u00eb p\u00ebrbashk\u00ebta duhet t\u00eb jen\u00eb n\u00eb nj\u00eb sistem t\u00eb vet\u00ebm t\u00eb skedar\u00ebve.<\/li>\n<li>Kur rikuperoni baz\u00ebn e t\u00eb dh\u00ebnave SQL Server nga nj\u00eb snapshot i bazuar n\u00eb bllok, n\u00ebse instanca e SQL Server duhet t\u00eb mbetet e lidhur, p\u00ebrdorni lidhjen me host-in Unisphere. P\u00ebr rikuperimin e bazuar n\u00eb skedar\u00eb krijohet nj\u00eb burim i p\u00ebrbashk\u00ebt SMB shtes\u00eb duke p\u00ebrdorur snapshot-in si burim. Pas lidhjes s\u00eb volumit, baza e t\u00eb dh\u00ebnave mund t\u00eb lidhet n\u00ebn nj\u00eb em\u00ebr tjet\u00ebr 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 duke p\u00ebrdorur metod\u00ebn e rikuperimit Snapshot Restore n\u00eb Unisphere, transferoni instanc\u00ebn e SQL Server n\u00eb modalitetin offline. SQL Server nuk e di p\u00ebr operacionet e rikuperimit. Transferimi i instanc\u00ebs n\u00eb modalitetin offline garanton q\u00eb volumet t\u00eb mos d\u00ebmtohen gjat\u00eb operacioneve t\u00eb shkruar n\u00eb baz\u00ebn e t\u00eb dh\u00ebnave para rikuperimit. Sapo instanca t\u00eb ri\u00e7ellet, rikuperimi emergjente i SQL Server do t\u00eb \u00e7oj\u00eb bazat e t\u00eb dh\u00ebnave n\u00eb nj\u00eb gjendje t\u00eb q\u00ebndrueshme.<\/li>\n<li>Lejoni krijimin e kopjeve t\u00eb menj\u00ebhershme p\u00ebr disa objekte ruajtjeje nj\u00ebkoh\u00ebsisht dhe m\u00eb pas, p\u00ebrpara se t\u00eb aktivizoni kopje t\u00eb tjera, sigurohuni q\u00eb sistemi \u00ebsht\u00eb n\u00eb modet e rekomanduara t\u00eb operimit gjat\u00eb monitorimit.<\/li>\n<\/ul>\n<p><\/p>\n<h2>Automatizimi dhe planifikimi i kopjeve t\u00eb menj\u00ebhershme<\/h2>\n<p>\nKopjet e menj\u00ebhershme n\u00eb Unity XT mund t\u00eb automatizohen. N\u00eb sistemin e menaxhimit t\u00eb ruajtjes Unisphere, jan\u00eb n\u00eb dispozicion opsionet e m\u00ebposhtme p\u00ebr kopje t\u00eb menj\u00ebhershme me t\u00eb dh\u00ebna: mbrojtja e parazgjedhur, mbrojtja me afat m\u00eb t\u00eb shkurt\u00ebr ruajtjeje dhe mbrojtja me afat m\u00eb t\u00eb gjat\u00eb ruajtjeje. \u00c7do opsion krijon kopje t\u00eb menj\u00ebhershme \u00e7do dit\u00eb dhe i ruan ato p\u00ebr periudha t\u00eb ndryshme kohe.<\/p>\n<p>Mund t\u00eb zgjidhni nj\u00eb (ose t\u00eb dy) nga opsionet e planifikimit \u2014 \u00e7do x or\u00eb (nga 1 deri n\u00eb 24) dhe \u00e7do dit\u00eb \/ \u00e7do jav\u00eb. Planifikimi i kopjeve t\u00eb menj\u00ebhershme \u00e7do dit\u00eb \/ \u00e7do jav\u00eb lejon caktimin e nj\u00eb kohe dhe dit\u00ebsh t\u00eb caktuara p\u00ebr t\u00eb krijuar kopje t\u00eb menj\u00ebhershme. P\u00ebr secil\u00ebn mund\u00ebsi 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 grupin ose p\u00ebr t\u00eb ruajtur p\u00ebrkoh\u00ebsisht.<\/p>\n<p>Informacione t\u00eb tjera rreth kopjeve t\u00eb menj\u00ebhershme 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>\nNj\u00eb klon i holl\u00eb \u00ebsht\u00eb nj\u00eb kopje q\u00eb lejohet p\u00ebr lexim\/shkruaj dhe mbulon burimin e ruajtjes s\u00eb holl\u00eb t\u00eb bllokut, si\u00e7 \u00ebsht\u00eb nj\u00eb volum, nj\u00eb grup konsistent ose ruajtja e t\u00eb dh\u00ebnave VMFS VMware, 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 treguar shpejt dhe me kompakt\u00ebsin\u00eb kopje t\u00eb nj\u00eb baze t\u00eb dh\u00ebnash SQL Server, q\u00eb nuk mund t\u00eb arrihet me mjetet tradicionale SQL Server. Pas trajtimit t\u00eb klonit t\u00eb holl\u00eb n\u00eb host, volumi mund t\u00eb kaloj\u00eb n\u00eb modin aktiv (online), dhe baza e t\u00eb dh\u00ebnave do t\u00eb bashkohet duke p\u00ebrdorur metod\u00ebn e bashkimit t\u00eb DB n\u00eb SQL Server.<\/p>\n<p>N\u00eb p\u00ebrdorimin e funksionit t\u00eb p\u00ebrdit\u00ebsimit 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 p\u00ebrdit\u00ebsimit. N\u00ebse nuk i kaloni bazat e t\u00eb dh\u00ebnave n\u00eb modalitetin offline para p\u00ebrdit\u00ebsimit, mund t\u00eb ndodhin 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 sinkronizohen t\u00eb dh\u00ebnat me nj\u00eb sistem t\u00eb larg\u00ebt n\u00eb t\u00eb nj\u00ebjtin objekt ose n\u00eb nj\u00eb vend tjet\u00ebr. Parametrat 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 ekuilib\u00ebr midis performanc\u00ebs dhe kapacitetit t\u00eb transfert\u00ebs.<\/p>\n<p>Kur p\u00ebrdoret replikimi i Dell EMC Unity p\u00ebr t\u00eb mbrojtur bazat e t\u00eb dh\u00ebnave SQL Server n\u00eb disa volume, duhet t\u00eb kufizoni t\u00eb dh\u00ebnat dhe volume t\u00eb skedar\u00ebve t\u00eb baz\u00ebs s\u00eb t\u00eb dh\u00ebnave n\u00eb nj\u00eb grup konsistent ose sistem skedar\u00ebsh. M\u00eb pas, replikimi konfigurtohet 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 parametra t\u00eb ndrysh\u00ebm replikimi duhet t\u00eb ndodhen n\u00eb LUN t\u00eb ve\u00e7anta, grupe konsistente ose sisteme skedar\u00ebsh.<\/p>\n<p>Kloni i holl\u00eb \u00ebsht\u00eb i p\u00ebrshtatsh\u00ebm si p\u00ebr replikimin sinkron ashtu edhe p\u00ebr at\u00eb asinkron. Kur nj\u00eb klon i holl\u00eb replikon n\u00eb destinacion, ai b\u00ebhet nj\u00eb kopje e plot\u00eb e volumit, grupit t\u00eb konsistenc\u00ebs ose depozit\u00ebs VMFS. Pas replikimit, kloni i holl\u00eb \u00ebsht\u00eb nj\u00eb volum t\u00ebr\u00ebsisht t\u00eb pavarur me cil\u00ebsimet e tij. <\/p>\n<p><img decoding=\"async\" alt=\"Microsoft SQL Server 2019 dhe nj\u00ebsit\u00eb flash 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 atyre q\u00ebllimore.<\/i><\/p>\n<p>Replikimi i baz\u00ebs s\u00eb t\u00eb dh\u00ebnave tempdb nuk k\u00ebrkohet, pasi skedari rind\u00ebrtohet kur rilansohet SQL Server, k\u00ebshtu q\u00eb metadatav e saj nuk p\u00ebrputhen me metodat e instancave t\u00eb tjera t\u00eb SQL Server. Zgjedhja e kujdesshme e volumeve p\u00ebr replikim dhe p\u00ebrmbajtjes s\u00eb k\u00ebtyre volumeve eliminojn\u00eb trafikun e panevojsh\u00ebm t\u00eb replikimit.<\/p>\n<h2>Menaxhimi i integruar i kopjeve t\u00eb t\u00eb dh\u00ebnave n\u00eb Microsoft SQL Server<\/h2>\n<p>\nShumica e produkteve moderne t\u00eb ruajtjes (duke p\u00ebrfshir\u00eb t\u00eb gjitha produktet e Dell EMC) mund t\u00eb krijojn\u00eb kopje \"t\u00eb harmonizuara me sistemin operativ\" t\u00eb \u00e7do lloji skedari duke:<\/p>\n<ul>\n<li>Krijuar nj\u00eb rend t\u00eb harmonizuar shkruar nga sistemi operativ n\u00eb t\u00eb gjitha nivelet - nga hosti deri te disku.<\/li>\n<li>Grupuar volume, n\u00eb m\u00ebnyr\u00eb q\u00eb p\u00ebr disa skedar\u00eb mbi volume t\u00eb ndryshme t\u00eb ruhet rendi i shkruar.<\/li>\n<\/ul>\n<p>\nMe p\u00ebrhapjen e gjer\u00eb t\u00eb pajisjeve sh\u00ebruese t\u00eb shkallueshme, Microsoft ka zhvilluar nj\u00eb API p\u00ebr ofruesit e ruajtjes. Ky API u mund\u00ebson ofruesve t\u00eb ruajtjes t\u00eb koordinojn\u00eb veprimet e tyre me softuerin e bazave t\u00eb t\u00eb dh\u00ebnave SQL Server p\u00ebr t\u00eb krijuar \"kopje t\u00eb pajtueshme me aplikacionin\" p\u00ebrmes sh\u00ebrbimit t\u00eb kopjimit t\u00eb volumit (VSS). K\u00ebto kopje imitojn\u00eb nd\u00ebrveprimin e SQL Server dhe sistemit operativ gjat\u00eb ndalesave t\u00eb planifikuara dhe p\u00ebrfundimit t\u00eb pun\u00ebs s\u00eb SQL Server. T\u00eb gjitha tampon\u00ebt e shkrimit pastrohen, dhe transaksionet pezullohen derisa t\u00eb gjitha disk\u00ebt t\u00eb jen\u00eb p\u00ebrdit\u00ebsuar dhe t\u00eb pajtohen n\u00eb nj\u00eb moment t\u00eb caktuar, i cili regjistrohet n\u00eb logun e SQL.<\/p>\n<p>Softueri Dell EMC AppSync, i integruar me pamjet Unity XT, thjeshton dhe automatizon procesin e krijimit, p\u00ebrdorimit dhe menaxhimit t\u00eb kopjeve t\u00eb pajtueshme me aplikacionin t\u00eb t\u00eb dh\u00ebnave punuese. Ky softuer \u00ebsht\u00eb projektuar p\u00ebr t'u p\u00ebrdorur n\u00eb skenar\u00ebt e menaxhimit t\u00eb kopimeve p\u00ebr rikuperimin e bazave t\u00eb t\u00eb dh\u00ebnave dhe rip\u00ebrdorimin e tyre.\u00a0<\/p>\n<p>Softueri AppSync e zbulon automatikisht bazat e t\u00eb dh\u00ebnave t\u00eb aplikacioneve, shqyrton struktur\u00ebn e baz\u00ebs s\u00eb t\u00eb dh\u00ebnave dhe e p\u00ebrfaq\u00ebson struktur\u00ebn e skedar\u00ebve p\u00ebrmes niveleve t\u00eb harduerit ose niveleve t\u00eb virtualizimit n\u00eb ruajtjen baz\u00eb Unity XT. Ai organizon t\u00eb gjitha veprimet e nevojshme, nga krijimi dhe verifikimi i kopjes deri te montimi i pamjeve n\u00eb hostin e synuar dhe aktivizimi ose rikuperimi i baz\u00ebs s\u00eb t\u00eb dh\u00ebnave. AppSync mb\u00ebshtet dhe thjeshton flukset e pun\u00ebs t\u00eb SQL Server, t\u00eb cilat p\u00ebrfshijn\u00eb p\u00ebrdit\u00ebsimin dhe rikuperimin e baz\u00ebs s\u00eb t\u00eb dh\u00ebnave punuese.<\/p>\n<h2>Reducimi i volumit t\u00eb t\u00eb dh\u00ebnave dhe ndihma e avancuar n\u00eb dedublimin<\/h2>\n<p>\nFamilja e sistemeve t\u00eb ruajtjes t\u00eb t\u00eb dh\u00ebnave Dell EMC Unity ofron sh\u00ebrbime multifunksionale dhe t\u00eb lehta p\u00ebr t'u p\u00ebrdorur p\u00ebr reduktimin e volumit t\u00eb t\u00eb dh\u00ebnave. Kursimi arrihet jo vet\u00ebm n\u00eb burimet e konfiguruara fillestare t\u00eb ruajtjes, por gjithashtu n\u00eb pamjet dhe klon\u00ebt e holl\u00eb t\u00eb k\u00ebtyre burimeve. Pamjet dhe klon\u00ebt e holl\u00eb trash\u00ebgojn\u00eb konfigurimin e reduktimit t\u00eb volumit t\u00eb ruajtjes origjinale, duke rritur kursimin e kapacitetit.<\/p>\n<p>Funksioni i reduktimit t\u00eb volumit t\u00eb t\u00eb dh\u00ebnave p\u00ebrfshin veprime t\u00eb dedupikimit, kompresimin dhe zbulimin e blloqeve t\u00eb zbraz\u00ebta, t\u00eb cilat potencialisht rrisin volumet e hap\u00ebsir\u00ebs s\u00eb dobishme p\u00ebr ruajtjen e objekteve t\u00eb p\u00ebrdoruesve dhe p\u00ebrdorimin e brendsh\u00ebm. Funksioni i reduktimit t\u00eb volumit t\u00eb t\u00eb dh\u00ebnave Unity XT z\u00ebvend\u00ebson funksionin e kompresimit n\u00eb Unity OE 4.3 dhe versionet m\u00eb t\u00eb reja. Kompresimi \u00ebsht\u00eb nj\u00eb algorit\u00ebm i reduktimit t\u00eb t\u00eb dh\u00ebnave q\u00eb mund t\u00eb zvog\u00ebloj\u00eb shp\u00ebrndarjen fizike t\u00eb kapacitetit t\u00eb nevojsh\u00ebm p\u00ebr t\u00eb ruajtur nj\u00eb grup t\u00eb dh\u00ebnash.<\/p>\n<p>Sistemet Unity XT gjithashtu ofrojn\u00eb nj\u00eb funksion t\u00eb avancuar dedupikimi, i cili mund t\u00eb aktivizohet n\u00ebse \u00ebsht\u00eb aktivizuar reduktimi i volumit t\u00eb t\u00eb dh\u00ebnave. Dedupikimi i avancuar zvog\u00eblon kapacitetin e nevojsh\u00ebm p\u00ebr t\u00eb dh\u00ebnat e p\u00ebrdoruesve, duke ruajtur vet\u00ebm nj\u00eb num\u00ebr t\u00eb vog\u00ebl kopjesh (shpesh vet\u00ebm nj\u00eb kopje) t\u00eb blloqeve t\u00eb t\u00eb dh\u00ebnave Unity. Zona e dedupikimit \u00ebsht\u00eb nj\u00eb LUN. Merrni parasysh k\u00ebt\u00eb kur zgjidhni nj\u00eb skem\u00eb ruajtjeje. Numri m\u00eb i vog\u00ebl i LUN-\u00ebve \u00e7on n\u00eb nj\u00eb dedupikim m\u00eb t\u00eb mir\u00eb, por m\u00eb shum\u00eb LUN ofron performanc\u00eb t\u00eb p\u00ebrmir\u00ebsuar.\u00a0<\/p>\n<p>Kursimi i kapacitetit p\u00ebrmes dedupikimit t\u00eb avancuar mund t\u00eb siguroj\u00eb kthimin m\u00eb t\u00eb lart\u00eb n\u00eb shumic\u00ebn e ambienteve, por gjithashtu k\u00ebrkon p\u00ebrdorimin e burimeve t\u00eb procesor\u00ebve t\u00eb sistemit Unity. N\u00eb OE 5.0, dedupikimi i avancuar, n\u00ebse aktivizohet, dedupikon \u00e7do bllok (t\u00eb kompresuar ose t\u00eb pa kompresuar). Informacione t\u00eb m\u00ebtejshme mund t\u00eb gjenden n\u00eb <noindex><a rel=\"nofollow\" href=\"https:\/\/www.emc.com\/collateral\/white-papers\/h15571-dell-emc-unity-compression.pdf\">dokumentacionin Dell EMC<\/a><\/noindex>.<\/p>\n<p>T\u00eb dh\u00ebnat e m\u00ebposhtme tregojn\u00eb konfigurimet e mb\u00ebshtetura p\u00ebr reduktimin e t\u00eb dh\u00ebnave dhe dedupikimin e avancuar:<\/p>\n<h2>Reduktimi i t\u00eb dh\u00ebnave n\u00eb Unity (t\u00eb gjitha modelet) dhe mb\u00ebshtetje e avancuar p\u00ebr dedupikimin<\/h2>\n<p><\/p>\n<p>Versioni Unity OE\u00a0<\/p>\n<p>Shkenca\u00a0<\/p>\n<p>Lloji i mb\u00ebshtetur i grupit\u00a0<\/p>\n<p>Modelet e mb\u00ebshtetura<\/p>\n<p>4.3 \/ 4.4\u00a0<\/p>\n<p>Reduktimi i volumit t\u00eb t\u00eb dh\u00ebnave\u00a0<\/p>\n<p>Grupi i memories flash - tradicional ose dinamik\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>Reduktimi i volumit t\u00eb t\u00eb dh\u00ebnave\u00a0<\/p>\n<p>300, 400, 500, 600, 300F, 400F, 500F, 600F, 350F, 450F, 550F, 650F\u00a0<\/p>\n<p>Reduktimi i volumit t\u00eb t\u00eb dh\u00ebnave dhe dedupikimi i avancuar*<\/p>\n<p>450F, 550F, 650F\u00a0<\/p>\n<p>5\u00a0<br \/>\n\u00a0<\/p>\n<p>Reduktimi i volumit t\u00eb t\u00eb dh\u00ebnave\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>Reducimi i volumit t\u00eb t\u00eb dh\u00ebnave dhe ndihma e avancuar n\u00eb dedublimin<\/p>\n<p>450F, 550F, 650F, 380, 480, 680, 880, 380F, 480F, 680F, 880F<\/p>\n<p><i> * Reduktimi i volumit t\u00eb t\u00eb dh\u00ebnave \u00ebsht\u00eb i \u00e7aktivizuar nga default dhe duhet t\u00eb aktivizohet para se dedupikimi i avancuar t\u00eb b\u00ebhet nj\u00eb opsion i disponuesh\u00ebm. Pas aktivizimit t\u00eb reduktimit t\u00eb volumit t\u00eb t\u00eb dh\u00ebnave, dedupikimi i avancuar \u00ebsht\u00eb i disponuesh\u00ebm, por nga default \u00ebsht\u00eb i \u00e7aktivizuar.<\/i><\/p>\n<h2>Reduktimi i volumit t\u00eb t\u00eb dh\u00ebnave n\u00eb Unity dhe kompresimi i t\u00eb dh\u00ebnave n\u00eb SQL Server<\/h2>\n<p>\nLan\u00e7imi i SQL Server 2008 Enterprise Edition ishte l\u00ebshimi i par\u00eb me funksione t\u00eb veta p\u00ebr kompresimin e t\u00eb dh\u00ebnave. Gjat\u00eb kompresimit n\u00eb nivelin e rreshtave dhe faqeve, SQL Server 2008 shfryt\u00ebzon njohurit\u00eb rreth formatit t\u00eb tabel\u00ebs s\u00eb baz\u00ebs s\u00eb t\u00eb dh\u00ebnave SQL Server p\u00ebr t\u00eb reduktuar hap\u00ebsir\u00ebn e z\u00ebn\u00eb nga objektet e baz\u00ebs s\u00eb t\u00eb dh\u00ebnave. Reduktimi i hap\u00ebsir\u00ebs lejon ruajtjen e m\u00eb shum\u00eb rreshtave n\u00eb nj\u00eb faqe dhe m\u00eb shum\u00eb faqeve n\u00eb pool-in e bufferave. Duke qen\u00eb se t\u00eb dh\u00ebnat q\u00eb nuk ruhen n\u00eb formatin e faqeve t\u00eb t\u00eb dh\u00ebnave 8k, p\u00ebr shembull, t\u00eb dh\u00ebnat jasht\u00eb rreshtit, si NVARCHAR (MAX), nuk do t\u00eb p\u00ebrdorin metodat e kompresimit t\u00eb rreshtave ose faqeve, Microsoft introduktoi funksionet Transact-SQL COMPRESS dhe DECOMPRESS.\u00a0<\/p>\n<p>K\u00ebto funksione p\u00ebrdorin qasje tradicionale p\u00ebr kompresimin e t\u00eb dh\u00ebnave (algoritmi GZIP), i cili duhet t\u00eb thirret p\u00ebr \u00e7do seksion t\u00eb t\u00eb dh\u00ebnave p\u00ebr kompresim ose shp\u00ebrb\u00ebrje.<\/p>\n<p>Kompresimi Unity XT, i cili nuk lidhet ekskluzivisht me SQL Server, p\u00ebrdor nj\u00eb algorit\u00ebm softuerik p\u00ebr analiz\u00ebn dhe kompresimin e t\u00eb dh\u00ebnave t\u00eb nj\u00ebsis\u00eb s\u00eb ruajtjes. Q\u00eb kur \u00ebsht\u00eb l\u00ebshuar Unity OE 4.1, kompresimi i t\u00eb dh\u00ebnave n\u00eb Unity ka qen\u00eb i disponuesh\u00ebm p\u00ebr volumet e ruajtjes bllok dhe ruajtjes s\u00eb t\u00eb dh\u00ebnave VMFS n\u00eb nj\u00eb pool me memorie flash. Q\u00eb nga Unity OE 4.2, kompresimi gjithashtu \u00ebsht\u00eb i disponuesh\u00ebm p\u00ebr sistemet e skedar\u00ebve dhe ruajtjet e t\u00eb dh\u00ebnave NFS n\u00eb pool-et e ruajtjes n\u00eb pajisje flash.<\/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 CPU \u2014 si n\u00eb ruajtje ashtu edhe n\u00eb serverat e baz\u00ebs s\u00eb t\u00eb dh\u00ebnave, si dhe burimet e input-output t\u00eb nevojshme p\u00ebr t\u00eb mbajtur SLA-n\u00eb. N\u00eb p\u00ebrgjith\u00ebsi, pritet kursim shtes\u00eb hap\u00ebsire p\u00ebr t\u00eb dh\u00ebnat q\u00eb kompresohen me mjete 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 nj\u00eb reduktim t\u00eb konsideruesh\u00ebm volumesh nga funksionet e kompresimit Unity XT, pasi shumica e p\u00ebrfitimeve arrihen nga algoritmi universali t\u00eb aplikuar s\u00eb pari.<\/p>\n<p>Kompresimi Unity ofron kursim hap\u00ebsire n\u00ebse t\u00eb dh\u00ebnat n\u00eb objektin e ruajtjes kompresohen t\u00eb pakt\u00ebn 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 nuk do t\u00eb sjell\u00eb kursim t\u00eb kapacitetit.\u00a0<\/p>\n<p>Kur vendosni n\u00ebse t\u00eb p\u00ebrdorni kompresimin e t\u00eb dh\u00ebnave t\u00eb Unity, kompresimin n\u00eb nivelin e baz\u00ebs s\u00eb t\u00eb dh\u00ebnave SQL Server, apo t\u00eb dyja, merrni parasysh k\u00ebt\u00eb:<\/p>\n<ul>\n<li>T\u00eb dh\u00ebnat q\u00eb sh\u00ebnohen n\u00eb sistemin Unity, konfirmohen nga host-i pas ruajtjes s\u00eb tyre n\u00eb cache-in sistematik. Megjithat\u00eb, procesi i kompresimit nuk fillon derisa t\u00eb pastrohet cache.<\/li>\n<\/ul>\n<p><\/p>\n<ul>\n<li>Kursimi nga kompresimi arrihet jo vet\u00ebm p\u00ebr burimet e ruajtjes s\u00eb Unity XT, por edhe p\u00ebr snapshot-e dhe klone t\u00eb holl\u00eb t\u00eb burimit.<\/li>\n<li>Gjat\u00eb procesit t\u00eb kompresimit, disa blloqe agregohen duke p\u00ebrdorur nj\u00eb algorit\u00ebm zgjedhjeje 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 injorohet dhe t\u00eb dh\u00ebnat shkruhen n\u00eb grupin e t\u00eb dh\u00ebnave ekzistuese.<\/li>\n<li>Kur t\u00eb dh\u00ebnat kompresohen para se t\u00eb shkruhen n\u00eb medium, volumi i operacioneve me to reduktohet ndjesh\u00ebm. Prandaj, kompresimi ndihmon n\u00eb uljen e konsumit t\u00eb flash-memory duke reduktuar volumin fizik t\u00eb t\u00eb dh\u00ebnave q\u00eb shkruhen n\u00eb ruajt\u00ebs.<\/li>\n<\/ul>\n<p>\nP\u00ebr m\u00eb shum\u00eb informacione rreth kompresimit t\u00eb rreshtave dhe faqeve n\u00eb SQL Server p\u00ebr tabela dhe indekse, shihni n\u00eb <noindex><a rel=\"nofollow\" href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/data-compression\/data-compression\">dokumentet e Microsoft<\/a><\/noindex>.<\/p>\n<p>Mos harroni se \u00e7do kompresim k\u00ebrkon burime t\u00eb procesorit. Kur \u00ebsht\u00eb e lart\u00eb k\u00ebrkesa p\u00ebr kapacitet, kompresimi mund t\u00eb ket\u00eb nj\u00eb ndikim t\u00eb duksh\u00ebm n\u00eb performanc\u00eb. Koeficient\u00ebt e lart\u00eb t\u00eb shkarkimeve 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 kursimin potencial duke p\u00ebrdorur koeficient\u00ebt real\u00eb t\u00eb reduktimit t\u00eb t\u00eb dh\u00ebnave n\u00eb sistemin Unity. Grupi grumbulloi t\u00eb dh\u00ebna nga makinat virtuale VMware, aksesi n\u00eb skedar\u00eb, 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 sked\u00ebs s\u00eb regjistrimit n\u00eb SQL Server ishte gati 10 her\u00eb m\u00eb i vog\u00ebl se ai i sked\u00ebs s\u00eb t\u00eb dh\u00ebnave:<\/p>\n<ul>\n<li>Volumi i baz\u00ebs s\u00eb t\u00eb dh\u00ebnave = 1,49: 1 (32,96%)<\/li>\n<li>Volumi i regjistrave = 12,9: 1 (92,25%)<\/li>\n<\/ul>\n<p>\nBaza e t\u00eb dh\u00ebnave SQL Server \u00ebsht\u00eb furnizuar me dy volume. Skedaret e baz\u00ebs s\u00eb t\u00eb dh\u00ebnave ruhen n\u00eb nj\u00eb volum, nd\u00ebrsa gazet\u00eb e transaksioneve n\u00eb volumin tjet\u00ebr. P\u00ebrdorimi i teknologjis\u00eb s\u00eb reduktimit t\u00eb t\u00eb dh\u00ebnave me volumet e baz\u00ebs s\u00eb t\u00eb dh\u00ebnave mund t\u00eb siguroj\u00eb kursim t\u00eb hap\u00ebsir\u00ebs; megjithat\u00eb, duhet marr\u00eb parasysh ndikimi n\u00eb performanc\u00eb kur merret nj\u00eb vendim n\u00ebse t\u00eb p\u00ebrfshihet deduplikimi n\u00eb volumet e baz\u00ebs s\u00eb t\u00eb dh\u00ebnave. Edhe pse reduktimi real i madh\u00ebsis\u00eb s\u00eb baz\u00ebs s\u00eb t\u00eb dh\u00ebnave mund t\u00eb ndryshoj\u00eb var\u00ebsisht nga t\u00eb dh\u00ebnat e ruajtura, studimi tregoi se hap\u00ebsira p\u00ebr ruajtjen e gazetave t\u00eb transaksioneve t\u00eb 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 t\u00eb reduktimit t\u00eb t\u00eb dh\u00ebnave<\/h2>\n<p>\nPara se t\u00eb aktivizoni reduktimin e t\u00eb dh\u00ebnave n\u00eb nj\u00eb objekt ruajtjeje, merrni parasysh rekomandimet e m\u00ebposhtme:<\/p>\n<ul>\n<li>P\u00ebrdorni monitorimin e sistemit t\u00eb ruajtjes p\u00ebr t\u00eb siguruar q\u00eb ai ka burime t\u00eb disponueshme p\u00ebr t\u00eb mb\u00ebshtetur reduktimin e t\u00eb dh\u00ebnave.<\/li>\n<li>Aktivizoni reduktimin e t\u00eb dh\u00ebnave p\u00ebr disa objekte ruajtjeje nj\u00ebkoh\u00ebsisht. Para se t\u00eb aktivizoni p\u00ebr objekte t\u00eb tjera ruajtjeje, monitoroni sistemin p\u00ebr t\u00eb siguruar q\u00eb ai \u00ebsht\u00eb n\u00eb modalitetet e rekomanduara t\u00eb pun\u00ebs.<\/li>\n<li>N\u00eb modelet Unity XT x80F, reduktimi i t\u00eb dh\u00ebnave do t\u00eb siguroj\u00eb kursim kapaciteti n\u00ebse t\u00eb dh\u00ebnat n\u00eb bllokun e ruajtjes kompresohen me t\u00eb pakt\u00ebn 1%.<\/li>\n<\/ul>\n<p>\nReduktimi i t\u00eb dh\u00ebnave n\u00eb modelet e m\u00ebparshme Unity x80F, t\u00eb cilat funksionojn\u00eb n\u00ebn OE 5.0, siguronte kursim n\u00ebse t\u00eb dh\u00ebnat ishin t\u00eb kompresueshme me t\u00eb pakt\u00ebn 25%.<\/p>\n<ul>\n<li>Para se t\u00eb aktivizoni reduktimin e t\u00eb dh\u00ebnave n\u00eb nj\u00eb objekt ruajtjeje, identifikoni n\u00ebse objekti p\u00ebrmban t\u00eb dh\u00ebna t\u00eb kompresueshme. Lloje t\u00eb caktuara t\u00eb t\u00eb dh\u00ebnave, t\u00eb tilla si video, audio, imazhe dhe t\u00eb dh\u00ebna binar\u00eb, zakonisht japin p\u00ebrfitim t\u00eb vog\u00ebl nga kompresimi. Mos aktivizoni reduktimin e t\u00eb dh\u00ebnave n\u00eb nj\u00eb objekt ruajtjeje n\u00ebse nuk do ket\u00eb kursimnde hap\u00ebsir\u00eb.<\/li>\n<li>Konsideroni mund\u00ebsin\u00eb e kompresimit selektiv t\u00eb volumit t\u00eb skedar\u00ebve t\u00eb dh\u00ebnash q\u00eb 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 e cloud. Komponent\u00ebt kryesor\u00eb t\u00eb vSphere jan\u00eb VMware vCenter Server dhe hipervizori VMware ESXi.<\/p>\n<p>vCenter Server \u2014 nj\u00eb platform\u00eb e unifikuar p\u00ebr menaxhimin e ambienteve vSphere. Ajo dallon p\u00ebr leht\u00ebsin\u00eb e implementimit dhe optimizimin proaktiv t\u00eb 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 themelore dhe madh\u00ebsia e tij e vog\u00ebl prej 150 MB minimizon k\u00ebrkesat p\u00ebr memorie. Ai ofron nj\u00eb performanc\u00eb t\u00eb besueshme p\u00ebr ngarkesa t\u00eb ndryshme aplikimesh dhe mb\u00ebshtet konfigurime t\u00eb fuqishme virtuale \u2014 deri n\u00eb 128 CPU virtuale, 6 TB RAM dhe 120 pajisje.<\/p>\n<p>P\u00ebr t\u00eb siguruar q\u00eb SQL Server t\u00eb funksionoj\u00eb n\u00eb m\u00ebnyr\u00eb efektive n\u00eb pajisjet moderne, sistemi operativ i SQL Server (SQLOS) duhet t\u00eb \"kuptoj\u00eb\" struktur\u00ebn e pajisjes. Me shfaqjen e sistemeve me shum\u00eb b\u00ebrthama dhe shum\u00eb nod\u00eb t\u00eb aksesit t\u00eb heterogjen\u00eb n\u00eb memorje (NUMA), \u00ebsht\u00eb ve\u00e7an\u00ebrisht e r\u00ebnd\u00ebsishme t\u00eb kuptojm\u00eb marr\u00ebdh\u00ebniet nd\u00ebrmjet 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 nj\u00eb makine virtuale. Numri total i vCPU t\u00eb caktuar llogaritet si:<\/p>\n<pre><code class=\"plaintext\">Total vCPU = (numri i soketeve virtuale) * (numri i b\u00ebrthamave virtuale p\u00ebr soket)<\/code><\/pre>\n<p>\nN\u00ebse performanca stabil \u00ebsht\u00eb e r\u00ebnd\u00ebsishme, VMware rekomandon q\u00eb numri total i vCPU t\u00eb caktuar t\u00eb gjitha makineve virtuale t\u00eb mos kaloj\u00eb numrin total t\u00eb b\u00ebrthamave fizike q\u00eb jan\u00eb n\u00eb dispozicion n\u00eb hostin ESXi, por \u00ebsht\u00eb e mundur t\u00eb rritet numri i vCPU t\u00eb caktuar n\u00ebse monitorimi tregon se ka burime t\u00eb pa p\u00ebrdorura t\u00eb CPU.<\/p>\n<p>N\u00eb sistemet me teknologjin\u00eb Intel Hyper-Threading t\u00eb aktivizuar, numri i b\u00ebrthamave logjike (vCPU) dyfishohet krahasuar me numrin e b\u00ebrthamave fizike. N\u00eb k\u00ebt\u00eb rast, mos caktoni numrin total t\u00eb vCPU.<\/p>\n<p>Ngarkesat e pun\u00ebs t\u00eb SQL Server me nivel t\u00eb ul\u00ebt preken m\u00eb pak nga variabiliteti i vones\u00ebs. 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 b\u00ebrthamave fizike. Niveli t\u00eb arsyesh\u00ebm i ngarkes\u00ebs s\u00eb CPU mund t\u00eb rris\u00eb kapacitetin e p\u00ebrgjithsh\u00ebm t\u00eb sistemit, t\u00eb kursej\u00eb licencat maksimale dhe t\u00eb siguroj\u00eb performanc\u00eb t\u00eb k\u00ebnaqshme.<\/p>\n<p>Intel Hyper-Threading zakonisht rrit kapacitetin total t\u00eb hostit me 10\u201330%, duke sugjeruar nj\u00eb raport t\u00eb CPU-ve virtuale ndaj procesor\u00ebve fizik\u00eb prej 1,1 deri n\u00eb 1,3. VMware rekomandon q\u00eb Hyper-Threading t\u00eb aktivizohet n\u00eb BIOS UEFI, kur \u00ebsht\u00eb e mundur, n\u00eb m\u00ebnyr\u00eb q\u00eb ESXi t\u00eb mund t\u00eb shfryt\u00ebzoj\u00eb p\u00ebrfitimet e k\u00ebsaj teknologjie. Gjithashtu, VMware rekomandon q\u00eb t\u00eb kryhen teste t\u00eb kujdesshme dhe monitorim kur p\u00ebrdoret Hyper-Threading p\u00ebr ngarkesat e pun\u00ebs n\u00eb SQL Server.<\/p>\n<h2>Memoria<\/h2>\n<p>\nGati t\u00eb gjith\u00eb server\u00ebt modern\u00eb p\u00ebrdorin arkitektur\u00ebn e aksesit t\u00eb pap\u00ebrputhsh\u00ebm n\u00eb memorie (NUMA) p\u00ebr komunikim midis memories kryesore dhe procesor\u00ebve. NUMA \u00ebsht\u00eb nj\u00eb arkitektur\u00eb harduerike p\u00ebr memorien e ndar\u00eb, e cila realizon ndarjen e blloqeve t\u00eb memories fizike mes procesor\u00ebve fizik\u00eb. Nj\u00eb nyje NUMA \u00ebsht\u00eb nj\u00eb ose disa socket-e CPU me nj\u00eb bllok memorie t\u00eb dedikuar.\u00a0<\/p>\n<p>Gjat\u00eb dekad\u00ebs s\u00eb fundit, NUMA ka qen\u00eb nj\u00eb tem\u00eb e diskutuara gjer\u00ebsisht. Kompleksiteti relativ i NUMA \u00ebsht\u00eb, n\u00eb ve\u00e7anti, rezultat i implementimeve nga furnizues t\u00eb ndrysh\u00ebm. N\u00eb mjediset virtualizuese, kompleksiteti i NUMA p\u00ebrcaktohet gjithashtu nga numri i parametrave t\u00eb konfigurimit dhe niveleve - nga hardueri p\u00ebrmes hipervizorit n\u00eb sistemin operativ mik 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 databaz\u00ebs SQL Server q\u00eb punon me nj\u00eb instanc\u00eb virtualizuar SQL Server.<\/p>\n<p>P\u00ebr t\u00eb arritur efikasitet m\u00eb t\u00eb lart\u00eb n\u00eb server\u00ebt me shum\u00eb b\u00ebrthama, Microsoft paraqiti SoftNUMA. Softueri SoftNUMA lejon ndarjen e burimeve t\u00eb disponueshme t\u00eb CPU-s\u00eb brenda nj\u00eb NUMA n\u00eb disa nyje SoftNUMA. Sipas VMware, SoftNUMA \u00ebsht\u00eb e pajtueshme me topologjin\u00eb virtuale NUMA (vNUMA) t\u00eb VMware dhe mund t\u00eb optimizoj\u00eb m\u00eb tej shkall\u00ebzimin dhe performanc\u00ebn e motorit DB p\u00ebr shumic\u00ebn e ngarkesave t\u00eb pun\u00ebs...<\/p>\n<p>Kur virtualizoni VMware me SQL Server p\u00ebrdorni:<\/p>\n<ul>\n<li>Monitorimin e makinave virtuale p\u00ebr t\u00eb identifikuar munges\u00ebn e burimeve t\u00eb memories p\u00ebr Motorin e Databaz\u00ebs SQL Server. Ky problem \u00e7on n\u00eb rritjen e operacioneve t\u00eb hyrjes\/daljes dhe uljen 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 shmangur mbingarkes\u00ebn e memories n\u00eb nivelin e hostit ESXi.<\/li>\n<li>Mendoni nj\u00eb kontroll t\u00eb alokimit t\u00eb memories fizike NUMA p\u00ebr t\u00eb p\u00ebrcaktuar sasin\u00eb maksimale t\u00eb memories q\u00eb mund t\u00eb caktosh nj\u00eb makine virtuale brenda kufijve fizik\u00eb NUMA.<\/li>\n<li>N\u00ebse arritja e nj\u00eb performanc\u00eb t\u00eb k\u00ebnaqshme \u00ebsht\u00eb q\u00ebllimi kryesor, konsideroni rezervimin e memories t\u00eb barabart\u00eb me memory t\u00eb caktuar. Kjo konfigurim garanton q\u00eb makina virtuale t\u00eb marr\u00eb vet\u00ebm memory fizike.<\/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 SAN. Ashtu si\u00e7 nevojitet t\u00eb kuptojm\u00eb si funksionojn\u00eb nivelet e ndryshme t\u00eb input-output \u2014 n\u00eb k\u00ebt\u00eb rast, nga aplikacioni n\u00eb VM deri n\u00eb leximin dhe shkrimin fizik t\u00eb informacionit n\u00eb nj\u00eb pajisje t\u00eb p\u00ebrhershme.<\/p>\n<p>vSphere ofron nj\u00eb s\u00ebr\u00eb opsionesh p\u00ebr konfigurimin e ruajtjes, t\u00eb cilat kan\u00eb aplikacione t\u00eb dobishme n\u00eb implementimin e SQL Server me matri\u00e7\u00ebn Unity XT. FS VMFS \u00ebsht\u00eb metoda m\u00eb e p\u00ebrdorur p\u00ebr ruajtjen e t\u00eb dh\u00ebnave n\u00eb sistemet e ruajtjes blokale, si\u00e7 \u00ebsht\u00eb Unity XT. Matri\u00e7a Unity XT \u00ebsht\u00eb niveli i posht\u00ebm, i p\u00ebrb\u00ebr\u00eb nga disqe fizik\u00eb, t\u00eb paraqitur nga vSphere si disqe logjike (volume). Volume-t e Unity XT jan\u00eb formatuar si volume VMFS nga hipervizori ESXi. Administrator\u00ebt e VMware krijojn\u00eb nj\u00eb ose m\u00eb shum\u00eb disqe virtuale (VMDK), t\u00eb cilat paraqiten n\u00eb sistemin operativ mysafir. RDM lejon makin\u00ebn virtuale t\u00eb aksesoj\u00eb drejtp\u00ebrdrejt ruajtjen blokale (p\u00ebrmes FC ose iSCSI) t\u00eb Unity XT pa formatim VMFS. Volume-t VMFS dhe RDM mund t\u00eb sigurojn\u00eb t\u00eb nj\u00ebjt\u00ebn kapacitet t\u00eb transaksioneve.\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 sistem\u00ebve t\u00eb skedar\u00ebve t\u00eb zakonsh\u00ebm NFS. Nj\u00eb makin\u00eb virtuale q\u00eb punon n\u00eb SQL Server dhe p\u00ebrdor VMDK n\u00eb ruajtjen e t\u00eb dh\u00ebnave NFS, nuk e di p\u00ebr nivelin e posht\u00ebm t\u00eb NFS. Sistemi operativ mysafir e sheh makin\u00ebn virtuale si nj\u00eb server fizik n\u00ebn menaxhimin e Windows Server dhe SQL Server. Disk\u00ebt e ndar\u00eb p\u00ebr konfigurimet e instanc\u00ebs s\u00eb klasterit 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 menaxhim m\u00eb t\u00eb sakt\u00eb n\u00eb nivelin e makin\u00ebs virtuale, pa marr\u00eb parasysh p\u00ebrfaq\u00ebsimin themelor t\u00eb memories fizike (p.sh., volumenet ose sistemet e skedar\u00ebve). Replikimi i bazuar n\u00eb matrix me VVols mb\u00ebshtetet q\u00eb nga VVol 2.0 (vSphere 6.5). Disku VVol mund t\u00eb p\u00ebrdoret si nj\u00eb z\u00ebvend\u00ebsues p\u00ebr diskun RDM p\u00ebr t\u00eb ofruar burimin disk p\u00ebr nj\u00eb instanc\u00eb klastri SQL t\u00eb q\u00ebndruesh\u00ebm, duke filluar nga vSphere 6.7, me mb\u00ebshtetje p\u00ebr ruajtjen e vazhdueshme p\u00ebrmes SCSI.<\/p>\n<h2>Rrjetat e virtualizuara<\/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 software, jo kabllot dhe switch-at fizik\u00eb. Ndikimi i vones\u00ebs n\u00eb rrjet mbi ngarkesat e pun\u00ebs t\u00eb SQL Server-it mund t\u00eb ndryshoj\u00eb ndjesh\u00ebm. Monitorimi i treguesve t\u00eb performanc\u00ebs s\u00eb rrjetit n\u00eb nj\u00eb ngarkes\u00eb pune ekzistuese ose n\u00eb nj\u00eb sistem testimi t\u00eb zbatuar mir\u00eb p\u00ebr nj\u00eb periudh\u00eb reprezentuese 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>T\u00eb dy switch-at virtual\u00eb standard dhe 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 magazin\u00ebs rrjet, p\u00ebrdorni etiketimin VLAN dhe grupet e porteve t\u00eb switch-it virtual.<\/li>\n<li>VMware rekomandon fuqish\u00ebm aktivizimin e frame-ve t\u00eb m\u00ebdha n\u00eb switch-at virtual\u00eb ku \u00ebsht\u00eb aktiv trafiku vSphere vMotion ose trafiku i iSCSI.<\/li>\n<li>N\u00eb p\u00ebrgjith\u00ebsi, respektoni rekomandimet p\u00ebr rrjetin p\u00ebr sistemet operative dhe pajisjet mikprit\u00ebse.<\/li>\n<\/ul>\n<p><\/p>\n<h2>\u00a0P\u00ebrfundim\u00a0<\/h2>\n<p>\nMjediset e bazave t\u00eb t\u00eb dh\u00ebnave 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 baz\u00eb t\u00eb SQL Server dhe shtoi t\u00eb reja, si mb\u00ebshtetje p\u00ebr ngarkesat e pun\u00ebs t\u00eb t\u00eb dh\u00ebnave t\u00eb m\u00ebdha me Apache Spark dhe HDFS. Dell EMC n\u00eb bashk\u00ebpunim me Microsoft vazhdon t\u00eb ofroj\u00eb komponent\u00ebt e infrastruktur\u00ebs t\u00eb nevojsh\u00ebm p\u00ebr mjedisin SQL Server \u2013 server\u00eb, magazina dhe rrjeta.\u00a0<\/p>\n<p>V\u00ebrejm\u00eb nj\u00eb rritje t\u00eb konsiderueshme t\u00eb koh\u00ebs s\u00eb disponueshm\u00ebris\u00eb dhe nj\u00eb ulje t\u00eb kostos totale t\u00eb pron\u00ebsis\u00eb (TCO) kur specialist\u00ebt e ruajtjes dhe bazave t\u00eb dh\u00ebnash punojn\u00eb s\u00eb bashku p\u00ebr krijimin e zgjidhjeve infrastrukturore p\u00ebr SQL Server n\u00eb platformat me ruajtje t\u00eb p\u00ebrbashk\u00ebt. Array-i flak\u00eb Dell EMC Unity XT \u00ebsht\u00eb nj\u00eb zgjidhje e mesme, e p\u00ebrshtatshme p\u00ebr zhvilluesit dhe administrator\u00ebt e SQL Server q\u00eb k\u00ebrkojn\u00eb performanc\u00eb t\u00eb lart\u00eb dhe vonesa t\u00eb ul\u00ebta. Sistemi Unity XT All-Flash, i destinuar t\u00eb punoj\u00eb n\u00eb t\u00eb gjitha ruajtjet flash, mb\u00ebshtet CPU me dy procesor\u00eb, konfigurime me dy kontroler\u00eb dhe optimizim shum\u00ebb\u00ebrthamor.<\/p>\n<p>Organizatat po virtualizojn\u00eb gjithnj\u00eb e m\u00eb shum\u00eb ambientet e tyre SQL Server. Edhe pse virtualizimi shton nj\u00eb nivel tjet\u00ebr projektimi n\u00eb arkitektur\u00ebn e stack-ut, ai ofron p\u00ebrfitime t\u00eb konsiderueshme. Shpresojm\u00eb se disa nga funksionet dhe mjete t\u00eb p\u00ebrdorura m\u00eb shpesh t\u00eb VMware n\u00eb ambientet e SQL Server, t\u00eb paraqitura m\u00eb sip\u00ebr, do t'ju ndihmojn\u00eb. Ne gjithashtu rekomandojm\u00eb lidhje me burime p\u00ebr informacion m\u00eb t\u00eb detajuar.<\/p>\n<h2>Useful links<\/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 p\u00ebr Zgjidhje t\u00eb Gatshme<\/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 me 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: Udh\u00ebzues p\u00ebr Praktika t\u00eb Mira<\/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: Dokument Informativ mbi Kompresimin<\/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: Dokument Informativ mbi Snapshot dhe Klon\u00ebt e Holl\u00eb<\/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: Analiza e Reduktimit t\u00eb t\u00eb Dh\u00ebnave<\/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: Dokument Informativ mbi Reduktimin e t\u00eb Dh\u00ebnave<\/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\">Flet\u00eb specifikimi e 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 Storage t\u00eb Bashkuar<\/a><\/noindex> (faqja e produktit)<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.youtube.com\/watch?v=oJ9T1lJf538\">P\u00ebrmbledhja e Produktit Dell EMC Unity dhe Arkitektura me 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\">Programi i Besnik\u00ebris\u00eb s\u00eb Dell EMC p\u00ebr t\u00eb Ardhmen<\/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\">Bloget e SQL Server<\/a><\/noindex><\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.vmware.com\/solutions\/business-critical-apps\/sql-virtualization.html\">Virtualizimi i Microsoft SQL mbi 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\">Arkitektura e Microsoft SQL Server n\u00eb VMware vSphere\u2014Udh\u00ebzues p\u00ebr Praktika t\u00eb Mira<\/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\">Karakterizimi i Performanc\u00ebs s\u00eb Microsoft SQL Server mbi 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\/\">Dokumenti teknik i Microsoft SQL Server 2019<br \/>\nBlogu i SQL Server<\/a><\/noindex><br \/>\n<noindex><a rel=\"nofollow\" href=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/default.aspx\">Platforma e t\u00eb Dh\u00ebnave t\u00eb Microsoft<\/a><\/noindex><br \/>\n<noindex><a rel=\"nofollow\" href=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/sql-server-2019\">Prezantimi i 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\">Arkiva e njoftimeve t\u00eb SQL Server 2019 CTP<\/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.1.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.1.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 array-flak\u00ebt Dell EMC Unity XT | ProHoster","description":"Sot do t'ju njohim me ve\u00e7orit\u00eb e p\u00ebrdorimit t\u00eb SQL Server 2019 me sistemin e ruajtjes Unity XT dhe do t\u00eb ofrojm\u00eb rekomandime p\u00ebr virtualizimin e SQL Server me teknologjin\u00eb VMware, 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}]}}