{"id":97702,"date":"2020-10-20T20:42:28","date_gmt":"2020-10-20T18:42:28","guid":{"rendered":"https:\/\/prohoster.info\/blog\/administrirovanie\/rasshifrovyvaem-key-i-page-waitresource-v-dedlokah-i-blokirovkah"},"modified":"2020-10-20T20:42:28","modified_gmt":"2020-10-20T18:42:28","slug":"rasshifrovyvaem-key-i-page-waitresource-v-dedlokah-i-blokirovkah","status":"publish","type":"post","link":"https:\/\/prohoster.info\/sq\/blog\/administrirovanie\/rasshifrovyvaem-key-i-page-waitresource-v-dedlokah-i-blokirovkah","title":{"rendered":"Shkruajm\u00eb Key dhe Page WaitResource n\u00eb bllokime dhe bllokase","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p>N\u00ebse po p\u00ebrdorni raportin p\u00ebr bllokimin (blocked process report) ose po mbledhni grafet e deadlock-\u00ebve, q\u00eb ofrohen nga SQL Server, nga koh\u00eb n\u00eb koh\u00eb do t\u00eb p\u00ebrballeni me k\u00ebto gj\u00ebra: <\/p>\n<blockquote><p>waitresource=\"PAGE: 6:3:70133\"<\/p>\n<p>waitresource=\"KEY: 6:72057594041991168 (ce52f92a058c)\"<\/p><\/blockquote>\n<p>\nNdoshta, n\u00eb at\u00eb XML gjigand q\u00eb po shqyrtoni, do t\u00eb ket\u00eb m\u00eb shum\u00eb informacion (grafikat e bllokimeve p\u00ebrmbajn\u00eb nj\u00eb list\u00eb burimesh, e cila ndihmon n\u00eb identifikimin e emrave t\u00eb objektit dhe indeksit), por jo gjithmon\u00eb.<\/p>\n<p>Ky tekst do t'ju ndihmoj\u00eb ta kuptoni.<\/p>\n<p>T\u00eb gjitha informacionet q\u00eb jan\u00eb k\u00ebtu jan\u00eb n\u00eb internet n\u00eb vende t\u00eb ndryshme, ato jan\u00eb thjesht shum\u00eb t\u00eb shp\u00ebrndara! Dua t'i grumbulloj t\u00eb gjitha s\u00eb bashku - nga DBCC PAGE te hobt_id dhe funksionet e pa dokumentuara %%physloc%% dhe %%lockres%%.<br \/>\n<noindex><a rel=\"nofollow\" name=\"habracut\"><\/a><\/noindex><br \/>\nS\u00eb pari, le t\u00eb flasim p\u00ebr pritjet n\u00eb bllokimet PAGE, dhe pastaj t\u00eb kalojm\u00eb te bllokimet KEY.<\/p>\n<h3>1) waitresource=\"PAGE: 6:3:70133\" = Id_Baze_Datoj: Id_Fajli: Numri_i_Faqes<\/h3>\n<p>\nN\u00ebse pyetja juaj pret p\u00ebr nj\u00eb bllokim PAGE, SQL Server do t'ju jap\u00eb adres\u00ebn e k\u00ebsaj faqe.<\/p>\n<p>Duke e ndar\u00eb \"PAGE: 6:3:70133\" ne marrim:<\/p>\n<ul>\n<li>database_id = 6<\/li>\n<li>data_file_id = 3<\/li>\n<li>page_numer = 70133<\/li>\n<\/ul>\n<h4>1.1) Shkruajm\u00eb database_id<\/h4>\n<p>\nGjejm\u00eb emrin e baz\u00ebs s\u00eb t\u00eb dh\u00ebnave duke p\u00ebrdorur pyetjen:<\/p>\n<pre><code class=\"sql\">SELECT \n    name \nFROM sys.databases \nWHERE database_id=6;\nGO<\/code><\/pre>\n<p>\nKjo \u00ebsht\u00eb publike <noindex><a rel=\"nofollow\" href=\"https:\/\/www.littlekendra.com\/2016\/09\/13\/deadlock-code-for-the-wideworldimporters-sample-database\/\">Baza e t\u00eb Dh\u00ebnave WideWorldImporters<\/a><\/noindex> n\u00eb SQL Server-in tim.<\/p>\n<h4>1.2) K\u00ebrkojm\u00eb emrin e fajlit t\u00eb t\u00eb dh\u00ebnave \u2014 n\u00ebse jeni t\u00eb interesuar<\/h4>\n<p>\nDo t\u00eb p\u00ebrdorim data_file_id n\u00eb hapin tjet\u00ebr p\u00ebr t\u00eb gjetur emrin e tabel\u00ebs. Mund t\u00eb kaloni thjesht te hapi tjet\u00ebr, por n\u00ebse jeni t\u00eb interesuar p\u00ebr emrin e fajlit, mund ta gjeni duke ekzekutuar pyetjen n\u00eb kontekstin e Baza e t\u00eb Dh\u00ebnave t\u00eb gjetur, duke futur data_file_id n\u00eb k\u00ebt\u00eb pyetje:<\/p>\n<pre><code class=\"sql\">USE WideWorldImporters;\nGO\nSELECT \n    name, \n    physical_name\nFROM sys.database_files\nWHERE file_id = 3;\nGO<\/code><\/pre>\n<p>\nN\u00eb Baza e t\u00eb Dh\u00ebnave WideWorldImporters, ky \u00ebsht\u00eb nj\u00eb fajll i quajtur WWI_UserData dhe \u00ebsht\u00eb rikuperuar te C:MSSQLDATAWideWorldImporters_UserData.ndf. (Ups, m\u00eb kap\u00ebt teksa vendosja skedar\u00ebt n\u00eb disk me sistemin! Jo! Doli n\u00eb m\u00ebnyr\u00eb t\u00eb pazakont\u00eb).<\/p>\n<h4>1.3) Merrni emrin e objektit nga DBCC PAGE<\/h4>\n<p>\nTani e dim\u00eb se faqja #70133 n\u00eb fajlin e t\u00eb dh\u00ebnave 3 i p\u00ebrket Baza e t\u00eb Dh\u00ebnave WideWorldImporters. Mund t\u00eb shohim p\u00ebrmbajtjen e k\u00ebsaj faqeje duke p\u00ebrdorur DBCC PAGE t\u00eb pa dokumentuar dhe trace-flag 3604.<br \/>\nSh\u00ebnim: preferoj t\u00eb p\u00ebrdor DBCC PAGE n\u00eb nj\u00eb kopje t\u00eb rikuperuar nga backup n\u00eb nj\u00eb server tjet\u00ebr, sepse kjo \u00ebsht\u00eb nj\u00eb gj\u00eb e pa dokumentuar. N\u00eb disa raste, ajo <noindex><a rel=\"nofollow\" href=\"https:\/\/connect.microsoft.com\/SQLServer\/feedback\/details\/776144\/dbcc-page-incorrect-output-with-filtered-indexes\">mund t\u00eb \u00e7oj\u00eb n\u00eb krijimin e nj\u00eb dubliku<\/a><\/noindex> (<i>sh\u00ebnim i p\u00ebrkthyesit \u2014 lidhja, fatkeq\u00ebsisht, nuk \u00e7on asgj\u00eb, por gjykoj sipas url se b\u00ebhet fjal\u00eb p\u00ebr indekset e filtruar<\/i>).<\/p>\n<pre><code class=\"sql\">\/* This trace flag makes DBCC PAGE output go to our Messages tab\ninstead of the SQL Server Error Log file *\/\nDBCC TRACEON (3604);\nGO\n\/* DBCC PAGE (DatabaseName, FileNumber, PageNumber, DumpStyle)*\/\nDBCC PAGE ('WideWorldImporters',3,70133,2);\nGO<\/code><\/pre>\n<p>\nDuke p\u00ebrpara rezultateve, mund t\u00eb gjeni object_id dhe index_id.<br \/>\n<img decoding=\"async\" alt=\"Shkruajm\u00eb Key dhe Page WaitResource n\u00eb bllokime dhe bllokase\" src=\"\/wp-content\/uploads\/2020\/10\/c5a42f36fb7a87cfd2e11adfef3caa17.png\" style=\"display:block;margin: 0 auto;\" \/><br \/>\nGati! Tani mund t\u00eb gjeni emrat e tabel\u00ebs dhe indeksit p\u00ebrmes pyetjes:<\/p>\n<pre><code class=\"sql\">USE WideWorldImporters;\nGO\nSELECT \n    sc.name as schema_name, \n    so.name as object_name, \n    si.name as index_name\nFROM sys.objects as so \nJOIN sys.indexes as si on \n    so.object_id=si.object_id\nJOIN sys.schemas AS sc on \n    so.schema_id=sc.schema_id\nWHERE \n    so.object_id = 94623380\n    and si.index_id = 1;\nGO<\/code><\/pre>\n<p>\nDhe tani shohim se pritja p\u00ebr bllokimin ishte n\u00eb indeksin PK_Sales_OrderLines t\u00eb tabel\u00ebs Sales.OrderLines.<\/p>\n<p>Sh\u00ebnim: N\u00eb SQL Server 2014 dhe m\u00eb lart, emri i objektit gjithashtu mund t\u00eb gjendet p\u00ebrmes DMO t\u00eb pa dokumentuar sys.dm_db_database_page_allocations. Por do t'ju duhet t\u00eb k\u00ebrkoni \u00e7do faqe n\u00eb DB, q\u00eb duket jo shum\u00eb mir\u00eb p\u00ebr bazat e t\u00eb dh\u00ebnave t\u00eb m\u00ebdha, k\u00ebshtu q\u00eb un\u00eb p\u00ebrdora DBCC PAGE.<\/p>\n<h4>1.4) A mund t\u00eb shohim t\u00eb dh\u00ebnat n\u00eb at\u00eb faqe q\u00eb ishte e bllokuar?<\/h4>\n<p>\nPo, por\u2026 a jeni absolutisht t\u00eb sigurt se ju nevojitet kjo?<br \/>\nKjo \u00ebsht\u00eb e ngadalshme edhe p\u00ebr tabela t\u00eb vogla. Por \u00ebsht\u00eb ndonj\u00ebher\u00eb interesante, k\u00ebshtu q\u00eb, p\u00ebr sa koh\u00eb keni arritur n\u00eb k\u00ebt\u00eb pik\u00eb\u2026 le t\u00eb flasim p\u00ebr %%physloc%%!<\/p>\n<p>%%physloc%% \u00ebsht\u00eb nj\u00eb cop\u00eb magjie e pa dokumentuar q\u00eb kthen identifikuesin fizik p\u00ebr \u00e7do regjistrim. Ju mund ta p\u00ebrdorni <noindex><a rel=\"nofollow\" href=\"http:\/\/www.sqlskills.com\/blogs\/paul\/sql-server-2008-new-undocumented-physical-row-locator-function\/\">%%physloc%% s\u00eb bashku me sys.fn_PhysLocFormatter n\u00eb SQL Server 2008 dhe m\u00eb lart<\/a><\/noindex>.<\/p>\n<p>Tani, kur e dim\u00eb se kemi dashur t\u00eb bllokojm\u00eb faqen n\u00eb Sales.OrderLines, mund t\u00eb shohim t\u00eb gjitha t\u00eb dh\u00ebnat n\u00eb k\u00ebt\u00eb tabel\u00eb, t\u00eb cilat ruhen n\u00eb skedarin e t\u00eb dh\u00ebnave #3 n\u00eb faqe #70133, p\u00ebrmes k\u00ebsaj pyetjeje:<\/p>\n<pre><code class=\"sql\">Use WideWorldImporters;\nGO\nSELECT \n    sys.fn_PhysLocFormatter (%%physloc%%),\n    *\nFROM Sales.OrderLines (NOLOCK)\nWHERE sys.fn_PhysLocFormatter (%%physloc%%) like '(3:70133%'\nGO<\/code><\/pre>\n<p>Si\u00e7 thash\u00eb \u2014 kjo \u00ebsht\u00eb e ngadalshme edhe p\u00ebr tabela t\u00eb vogla. Kam shtuar NOLOCK n\u00eb pyetje sepse nuk kemi asnj\u00eb garanci q\u00eb t\u00eb dh\u00ebnat q\u00eb duam t\u00eb shohim jan\u00eb ato t\u00eb nj\u00ebjta q\u00eb ishin n\u00eb momentin q\u00eb u zbulua bllokimi \u2014 k\u00ebshtu q\u00eb mund t\u00eb b\u00ebjm\u00eb leht\u00ebsisht leximet e ndotura.<br \/>\nPor, urra, pyetja m\u00eb kthen ato 25 rreshta q\u00eb po luftonim p\u00ebr t\u00eb marr\u00eb<br \/>\n<img decoding=\"async\" alt=\"Shkruajm\u00eb Key dhe Page WaitResource n\u00eb bllokime dhe bllokase\" src=\"\/wp-content\/uploads\/2020\/10\/e7909bb7c496d9509e5f5a1aa30a135a.png\" style=\"display:block;margin: 0 auto;\" \/><br \/>\nMjaft me bllokimet PAGE. \u00c7far\u00eb ndodh n\u00ebse jemi duke pritur p\u00ebr bllokim KEY?<\/p>\n<h3>2) waitresource=\u201cKEY: 6:72057594041991168 (ce52f92a058c)\u201d = Database_Id, HOBT_Id (hash magjik q\u00eb mund t\u00eb dekodifikohet me %%lockres%%, n\u00ebse e d\u00ebshironi me t\u00eb v\u00ebrtet\u00eb)<\/h3>\n<p>N\u00ebse pyetja juaj p\u00ebrpiqet t\u00eb bllokoj\u00eb nj\u00eb regjistrim n\u00eb indeks dhe p\u00ebrfundon duke u bllokuar vet\u00eb, merrni nj\u00eb lloj krejt\u00ebsisht t\u00eb ndrysh\u00ebm t\u00eb adres\u00ebs.<br \/>\nDuke ndar\u00eb \u201c6:72057594041991168 (ce52f92a058c)\u201d n\u00eb pjes\u00eb, ne marrim:<\/p>\n<ul>\n<li>database_id = 6<\/li>\n<li>hobt_id = 72057594041991168<\/li>\n<li>hashi magjik = (ce52f92a058c)<\/li>\n<\/ul>\n<h4>2.1) Shkruaj database_id<\/h4>\n<p>\nKjo funksionon pik\u00ebrisht si shembulli m\u00eb sip\u00ebr! Gjejm\u00eb emrin e baz\u00ebs s\u00eb t\u00eb dh\u00ebnave p\u00ebrmes nj\u00eb k\u00ebrkese:<\/p>\n<pre><code class=\"sql\">SELECT \n    name \nFROM sys.databases \nWHERE database_id=6;\nGO<\/code><\/pre>\n<p>\nN\u00eb rastin tim \u2014 \u00ebsht\u00eb akoma e nj\u00ebjta <noindex><a rel=\"nofollow\" href=\"https:\/\/www.littlekendra.com\/2016\/09\/13\/deadlock-code-for-the-wideworldimporters-sample-database\/\">Baza e t\u00eb Dh\u00ebnave WideWorldImporters<\/a><\/noindex>.<\/p>\n<h4>2.2) Shkruaj hobt_id<\/h4>\n<p>\nN\u00eb kontekstin e baz\u00ebs s\u00eb t\u00eb dh\u00ebnave t\u00eb gjetur, duhet t\u00eb kryhet nj\u00eb k\u00ebrkes\u00eb ndaj sys.partitions me \u00e7ift join-esh q\u00eb ndihmojn\u00eb n\u00eb p\u00ebrcaktimin e emrave t\u00eb tabel\u00ebs dhe indeksit\u2026<\/p>\n<pre><code class=\"sql\">USE WideWorldImporters;\nGO\nSELECT \n    sc.name as schema_name, \n    so.name as object_name, \n    si.name as index_name\nFROM sys.partitions AS p\nJOIN sys.objects as so on \n    p.object_id=so.object_id\nJOIN sys.indexes as si on \n    p.index_id=si.index_id and \n    p.object_id=si.object_id\nJOIN sys.schemas AS sc on \n    so.schema_id=sc.schema_id\nWHERE hobt_id = 72057594041991168;\nGO<\/code><\/pre>\n<p>\nAi m\u00eb thot\u00eb se k\u00ebrkesa ka pritur p\u00ebr bllokimin e Application.Countries, duke p\u00ebrdorur indeksin PK_Application_Countries.<\/p>\n<h4>2.3) Tani pak magji %%lockres%% \u2014 n\u00ebse d\u00ebshironi t\u00eb zbuloni se cila regjistrim ishte i bllokuar<\/h4>\n<p>\nN\u00ebse v\u00ebrtet dua t\u00eb di se mbi cilin rresht ishte nevoja p\u00ebr bllokim, mund ta zbuloj k\u00ebt\u00eb p\u00ebrmes nj\u00eb k\u00ebrkese ndaj tabel\u00ebs s\u00eb vet. Mund t\u00eb p\u00ebrdorim funksionin e pa dokumentuar %%lockres%% p\u00ebr t\u00eb gjetur regjistrimin q\u00eb p\u00ebrputhet me hash-in magjik.<br \/>\nKujdes, se kjo k\u00ebrkes\u00eb do t\u00eb skanoj\u00eb t\u00eb gjith\u00eb tabel\u00ebn dhe n\u00eb tabelat e m\u00ebdha kjo mund t\u00eb mos jet\u00eb shum\u00eb e k\u00ebndshme:<\/p>\n<pre><code class=\"sql\">SELECT\n    *\nFROM Application.Countries (NOLOCK)\nWHERE %%lockres%% = '(ce52f92a058c)';\nGO<\/code><\/pre>\n<p>\nKam shtuar NOLOCK (<noindex><a rel=\"nofollow\" href=\"https:\/\/twitter.com\/Aschenbrenner\/status\/788036874891853824\">sipari\u015f nga Klaus Aschenbrenner n\u00eb Twitter<\/a><\/noindex>) sepse bllokimet mund t\u00eb b\u00ebhen problem. Duam thjesht t\u00eb shikojm\u00eb se \u00e7far\u00eb ka tani, jo se \u00e7far\u00eb ka pasur kur filloi transaksioni \u2014 nuk mendoj se \u00ebsht\u00eb e r\u00ebnd\u00ebsishme q\u00eb t\u00eb dh\u00ebnat t\u00eb jen\u00eb t\u00eb q\u00ebndrueshme.<br \/>\nVoila, regjistrimi p\u00ebr t\u00eb cilin luftuam!<br \/>\n<img decoding=\"async\" alt=\"Shkruajm\u00eb Key dhe Page WaitResource n\u00eb bllokime dhe bllokase\" src=\"\/wp-content\/uploads\/2020\/10\/4107bfa33261ea62d17f27f61b1b4c23.png\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<\/p>\n<h3>Faleminderit dhe lexim i m\u00ebtejsh\u00ebm<\/h3>\n<p>\nNuk e mbaj mend se kush e p\u00ebrshkroi p\u00ebr her\u00eb t\u00eb par\u00eb shum\u00eb nga k\u00ebto gj\u00ebra, por ja dy postime p\u00ebr gj\u00ebrat m\u00eb pak t\u00eb dokumentuara, q\u00eb mund t'ju interesojn\u00eb:<\/p>\n<ul>\n<li>Postimi i Paul Randal mbi <noindex><a rel=\"nofollow\" href=\"http:\/\/www.sqlskills.com\/blogs\/paul\/sql-server-2008-new-undocumented-physical-row-locator-function\/\">%%physloc%% dhe sys.fn_PhysLocFormatter<\/a><\/noindex> (si i mor\u00ebm t\u00eb dh\u00ebnat tona n\u00eb shembullin e par\u00eb)<\/li>\n<li>Pyetje n\u00eb StackOverflow rreth <noindex><a rel=\"nofollow\" href=\"https:\/\/dba.stackexchange.com\/questions\/106762\/how-can-i-convert-a-key-in-a-sql-server-deadlock-report-to-the-value\">p\u00ebrdorimit t\u00eb %%lockres%%<\/a><\/noindex> (si gjet\u00ebm t\u00eb dh\u00ebnat n\u00eb shembullin e dyt\u00eb). Nj\u00eb nga p\u00ebrgjigjet \u00e7on n\u00eb postimin <noindex><a rel=\"nofollow\" href=\"http:\/\/www.scarydba.com\/2010\/03\/18\/undocumented-virtual-column-lockres\/\">Grant Fritchey mbi %%lockres%%, shkruar q\u00eb n\u00eb 2010<\/a><\/noindex>.<\/li>\n<\/ul>\n<p>Burimi: <a content=\"nofollow\" rel=\"nofollow\" href=\"https:\/\/habr.com\/ru\/post\/524098\/\">habr.com<\/a> <\/p>","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"excerpt":{"rendered":"<p>\u0415\u0441\u043b\u0438 \u0432\u044b \u043f\u043e\u043b\u044c\u0437\u0443\u0435\u0442\u0435\u0441\u044c \u043e\u0442\u0447\u0451\u0442\u043e\u043c \u043e \u0431\u043b\u043e\u043a\u0438\u0440\u043e\u0432\u043a\u0430\u0445 (blocked process report) \u0438\u043b\u0438 \u0441\u043e\u0431\u0438\u0440\u0430\u0435\u0442\u0435 \u0433\u0440\u0430\u0444\u044b \u0434\u0435\u0434\u043b\u043e\u043a\u043e\u0432, \u043f\u0440\u0435\u0434\u043e\u0441\u0442\u0430\u0432\u043b\u044f\u0435\u043c\u044b\u0435 SQL Server&#8217;\u043e\u043c, \u043f\u0435\u0440\u0438\u043e\u0434\u0438\u0447\u0435\u0441\u043a\u0438, \u0432\u044b \u0431\u0443\u0434\u0435\u0442\u0435 \u0441\u0442\u0430\u043b\u043a\u0438\u0432\u0430\u0442\u044c\u0441\u044f \u0441 \u0432\u043e\u0442 \u0442\u0430\u043a\u0438\u043c\u0438 \u0448\u0442\u0443\u043a\u0430\u043c\u0438: waitresource=\u201cPAGE: 6:3:70133\u201c waitresource=\u201cKEY: 6:72057594041991168 (ce52f92a058c)\u201c \u0418\u043d\u043e\u0433\u0434\u0430, \u0432 \u0442\u043e\u043c \u0433\u0438\u0433\u0430\u043d\u0442\u0441\u043a\u043e\u043c XML, \u043a\u043e\u0442\u043e\u0440\u044b\u0439 \u0432\u044b \u0438\u0437\u0443\u0447\u0430\u0435\u0442\u0435, \u0431\u0443\u0434\u0435\u0442 \u0431\u043e\u043b\u044c\u0448\u0435 \u0438\u043d\u0444\u043e\u0440\u043c\u0430\u0446\u0438\u0438 (\u0433\u0440\u0430\u0444\u044b \u0434\u0435\u0434\u043b\u043e\u043a\u043e\u0432 \u0441\u043e\u0434\u0435\u0440\u0436\u0430\u0442 \u0441\u043f\u0438\u0441\u043e\u043a \u0440\u0435\u0441\u0443\u0440\u0441\u043e\u0432, \u043a\u043e\u0442\u043e\u0440\u044b\u0439 \u043f\u043e\u043c\u043e\u0433\u0430\u0435\u0442 \u0443\u0437\u043d\u0430\u0442\u044c \u0438\u043c\u0435\u043d\u0430 \u043e\u0431\u044a\u0435\u043a\u0442\u0430 \u0438 \u0438\u043d\u0434\u0435\u043a\u0441\u0430), \u043d\u043e \u043d\u0435 \u0432\u0441\u0435\u0433\u0434\u0430. [&hellip;]<\/p>\n","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"author":1,"featured_media":97703,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[688],"tags":[],"class_list":["post-97702","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-administrirovanie"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 5.0.2.1 - aioseo.com -->\n\t<meta name=\"description\" content=\"\u0415\u0441\u043b\u0438 \u0432\u044b \u043f\u043e\u043b\u044c\u0437\u0443\u0435\u0442\u0435\u0441\u044c \u043e\u0442\u0447\u0451\u0442\u043e\u043c \u043e \u0431\u043b\u043e\u043a\u0438\u0440\u043e\u0432\u043a\u0430\u0445 (blocked process report) \u0438\u043b\u0438 \u0441\u043e\u0431\u0438\u0440\u0430\u0435\u0442\u0435 \u0433\u0440\u0430\u0444\u044b \u0434\u0435\u0434\u043b\u043e\u043a\u043e\u0432, \u043f\u0440\u0435\u0434\u043e\u0441\u0442\u0430\u0432\u043b\u044f\u0435\u043c\u044b\u0435 SQL Server&#039;\u043e\u043c, \u043f\u0435\u0440\u0438\u043e\u0434\u0438\u0447\u0435\u0441\u043a\u0438, \u0432\u044b \u0431\u0443\u0434\u0435\u0442\u0435 \u0441\u0442\u0430\u043b\u043a\u0438\u0432\u0430\u0442\u044c\u0441\u044f \u0441 \u0432\u043e\u0442 \u0442\u0430\u043a\u0438\u043c\u0438 \u0448\u0442\u0443\u043a\u0430\u043c\u0438: .\" \/>\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\/rasshifrovyvaem-key-i-page-waitresource-v-dedlokah-i-blokirovkah\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.2.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\udd47\u0420\u0430\u0441\u0448\u0438\u0444\u0440\u043e\u0432\u044b\u0432\u0430\u0435\u043c Key \u0438 Page WaitResource \u0432 \u0434\u0435\u0434\u043b\u043e\u043a\u0430\u0445 \u0438 \u0431\u043b\u043e\u043a\u0438\u0440\u043e\u0432\u043a\u0430\u0445 | ProHoster\" \/>\n\t\t<meta property=\"og:description\" content=\"\u0415\u0441\u043b\u0438 \u0432\u044b \u043f\u043e\u043b\u044c\u0437\u0443\u0435\u0442\u0435\u0441\u044c \u043e\u0442\u0447\u0451\u0442\u043e\u043c \u043e \u0431\u043b\u043e\u043a\u0438\u0440\u043e\u0432\u043a\u0430\u0445 (blocked process report) \u0438\u043b\u0438 \u0441\u043e\u0431\u0438\u0440\u0430\u0435\u0442\u0435 \u0433\u0440\u0430\u0444\u044b \u0434\u0435\u0434\u043b\u043e\u043a\u043e\u0432, \u043f\u0440\u0435\u0434\u043e\u0441\u0442\u0430\u0432\u043b\u044f\u0435\u043c\u044b\u0435 SQL Server&#039;\u043e\u043c, \u043f\u0435\u0440\u0438\u043e\u0434\u0438\u0447\u0435\u0441\u043a\u0438, \u0432\u044b \u0431\u0443\u0434\u0435\u0442\u0435 \u0441\u0442\u0430\u043b\u043a\u0438\u0432\u0430\u0442\u044c\u0441\u044f \u0441 \u0432\u043e\u0442 \u0442\u0430\u043a\u0438\u043c\u0438 \u0448\u0442\u0443\u043a\u0430\u043c\u0438: .\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/prohoster.info\/sq\/blog\/administrirovanie\/rasshifrovyvaem-key-i-page-waitresource-v-dedlokah-i-blokirovkah\" \/>\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=\"2020-10-20T18:42:28+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2020-10-20T18:42:28+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\udd47Shkruaj Key dhe Page WaitResource n\u00eb nd\u00ebrprerje dhe bllokime | ProHoster","description":"N\u00ebse p\u00ebrdorni raportin e bllokimeve (blocked process report) ose grumbulloni grafiket e nd\u00ebrprerjeve q\u00eb ofrohen nga SQL Server'i, her\u00eb pas here do t\u00eb p\u00ebrballeni me k\u00ebto gj\u00ebra: .","canonical_url":"https:\/\/prohoster.info\/sq\/blog\/administrirovanie\/rasshifrovyvaem-key-i-page-waitresource-v-dedlokah-i-blokirovkah","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\udd47\u0420\u0430\u0441\u0448\u0438\u0444\u0440\u043e\u0432\u044b\u0432\u0430\u0435\u043c Key \u0438 Page WaitResource \u0432 \u0434\u0435\u0434\u043b\u043e\u043a\u0430\u0445 \u0438 \u0431\u043b\u043e\u043a\u0438\u0440\u043e\u0432\u043a\u0430\u0445 | ProHoster","og:description":"\u0415\u0441\u043b\u0438 \u0432\u044b \u043f\u043e\u043b\u044c\u0437\u0443\u0435\u0442\u0435\u0441\u044c \u043e\u0442\u0447\u0451\u0442\u043e\u043c \u043e \u0431\u043b\u043e\u043a\u0438\u0440\u043e\u0432\u043a\u0430\u0445 (blocked process report) \u0438\u043b\u0438 \u0441\u043e\u0431\u0438\u0440\u0430\u0435\u0442\u0435 \u0433\u0440\u0430\u0444\u044b \u0434\u0435\u0434\u043b\u043e\u043a\u043e\u0432, \u043f\u0440\u0435\u0434\u043e\u0441\u0442\u0430\u0432\u043b\u044f\u0435\u043c\u044b\u0435 SQL Server'\u043e\u043c, \u043f\u0435\u0440\u0438\u043e\u0434\u0438\u0447\u0435\u0441\u043a\u0438, \u0432\u044b \u0431\u0443\u0434\u0435\u0442\u0435 \u0441\u0442\u0430\u043b\u043a\u0438\u0432\u0430\u0442\u044c\u0441\u044f \u0441 \u0432\u043e\u0442 \u0442\u0430\u043a\u0438\u043c\u0438 \u0448\u0442\u0443\u043a\u0430\u043c\u0438: .","og:url":"https:\/\/prohoster.info\/sq\/blog\/administrirovanie\/rasshifrovyvaem-key-i-page-waitresource-v-dedlokah-i-blokirovkah","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":"2020-10-20T18:42:28+00:00","article:modified_time":"2020-10-20T18:42:28+00:00","article:publisher":"https:\/\/www.facebook.com\/prohoster","article:author":"https:\/\/www.facebook.com\/prohoster"},"aioseo_meta_data":{"post_id":"97702","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":null,"breadcrumb_settings":null,"limit_modified_date":false,"reviewed_by":null,"ai":null,"created":"2021-02-28 10:15:26","updated":"2022-10-03 07:13:25","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\/97702","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=97702"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/posts\/97702\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/media\/97703"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/media?parent=97702"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/categories?post=97702"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/tags?post=97702"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}