{"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\/hu\/blog\/administrirovanie\/rasshifrovyvaem-key-i-page-waitresource-v-dedlokah-i-blokirovkah","title":{"rendered":"A Key \u00e9s Page WaitResource dek\u00f3dol\u00e1sa holtpontokban \u00e9s z\u00e1rol\u00e1sokban","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p>Ha blokkol\u00e1si jelent\u00e9st (blocked process report) haszn\u00e1l, vagy id\u0151nk\u00e9nt a SQL Server \u00e1ltal biztos\u00edtott holtverseny grafik\u00e1kat gy\u0171jt, akkor id\u0151nk\u00e9nt ezekkel a dolgokkal tal\u00e1lkozik: <\/p>\n<blockquote><p>waitresource=\"PAGE: 6:3:70133\"<\/p>\n<p>waitresource=\"KEY: 6:72057594041991168 (ce52f92a058c)\"<\/p><\/blockquote>\n<p>\nN\u00e9ha, abban a hatalmas XML-ben, amit elemez, t\u00f6bb inform\u00e1ci\u00f3t tal\u00e1l (a holtpont grafikonok tartalmazz\u00e1k a forr\u00e1sok list\u00e1j\u00e1t, ami seg\u00edt az objektum \u00e9s index nev\u00e9nek felfedez\u00e9s\u00e9ben), de nem mindig.<\/p>\n<p>Ez a sz\u00f6veg seg\u00edt majd megfejteni \u0151ket.<\/p>\n<p>Minden inform\u00e1ci\u00f3, ami itt tal\u00e1lhat\u00f3, el\u00e9rhet\u0151 az interneten k\u00fcl\u00f6nb\u00f6z\u0151 helyeken, csak nagyon sz\u00e9tsz\u00f3rt! Szeretn\u00e9m mindent \u00f6sszehozni \u2014 a DBCC PAGE-t\u0151l kezdve a hobt_id-ig \u00e9s a nem dokument\u00e1lt %%physloc%% \u00e9s %%lockres%% funkci\u00f3kig.<br \/>\n<noindex><a rel=\"nofollow\" name=\"habracut\"><\/a><\/noindex><br \/>\nEl\u0151sz\u00f6r besz\u00e9lj\u00fcnk a PAGE z\u00e1rol\u00e1sokkal kapcsolatos v\u00e1rakoz\u00e1sokr\u00f3l, majd \u00e1tt\u00e9r\u00fcnk a KEY z\u00e1rol\u00e1sokra.<\/p>\n<h3>1) waitresource=\"PAGE: 6:3:70133\" = Adatb\u00e1zis_Id: F\u00e1jlId: Oldalsz\u00e1m<\/h3>\n<p>\nHa a k\u00e9r\u00e9s PAGE z\u00e1rol\u00e1sra v\u00e1r, az SQL Server megadja ennek az oldalnak a c\u00edm\u00e9t.<\/p>\n<p>A \u201ePAGE: 6:3:70133\u201d elemz\u00e9s\u00e9vel megkapjuk:<\/p>\n<ul>\n<li>database_id = 6<\/li>\n<li>data_file_id = 3<\/li>\n<li>page_number = 70133<\/li>\n<\/ul>\n<h4>1.1) Fejtj\u00fck meg a database_id-t<\/h4>\n<p>\nKeresd meg az adatb\u00e1zis nev\u00e9t a lek\u00e9rdez\u00e9s seg\u00edts\u00e9g\u00e9vel:<\/p>\n<pre><code class=\"sql\">SELECT \n    name \nFROM sys.databases \nWHERE database_id=6;\nGO<\/code><\/pre>\n<p>\nEz a nyilv\u00e1nos <noindex><a rel=\"nofollow\" href=\"https:\/\/www.littlekendra.com\/2016\/09\/13\/deadlock-code-for-the-wideworldimporters-sample-database\/\">WideWorldImporters adatb\u00e1zis<\/a><\/noindex> az \u00e9n SQL Serveremen.<\/p>\n<h4>1.2) Keresd meg az adatf\u00e1jl nev\u00e9t \u2014 ha \u00e9rdekel<\/h4>\n<p>\nA k\u00f6vetkez\u0151 l\u00e9p\u00e9sben a data_file_id-t haszn\u00e1ljuk, hogy megtal\u00e1ljuk a t\u00e1bl\u00e1zat nev\u00e9t. Egyszer\u0171en l\u00e9phet a k\u00f6vetkez\u0151 l\u00e9p\u00e9sre, de ha \u00e9rdekel a f\u00e1jl neve, akkor ezt a lek\u00e9rdez\u00e9st futtathatod a megtal\u00e1lt adatb\u00e1zis kontextus\u00e1ban, a data_file_id-t behelyettes\u00edtve:<\/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>\nA WideWorldImporters adatb\u00e1zisban ez a n\u00e9v WWI_UserData f\u00e1jl, \u00e9s a C:MSSQLDATAWideWorldImporters_UserData.ndf helyre\u00e1ll\u00edtottam. (Ups, rajtakapt\u00e1l, ahogy a f\u00e1jlokat a rendszerlemezre helyezem! Nem! Zavarba ejt\u0151 volt).<\/p>\n<h4>1.3) Az objektum nev\u00e9t a DBCC PAGE-b\u0151l<\/h4>\n<p>\nMost m\u00e1r tudjuk, hogy a #70133 oldal a 3-as adatf\u00e1jlban a WorldWideImporters adatb\u00e1zishoz tartozik. Megn\u00e9zhetj\u00fck ennek az oldalnak a tartalm\u00e1t a nem dokument\u00e1lt DBCC PAGE \u00e9s a 3604-es nyomk\u00f3d seg\u00edts\u00e9g\u00e9vel.<br \/>\nMegjegyz\u00e9s: Prefer\u00e1lom a DBCC PAGE-t egy vissza\u00e1ll\u00edtott p\u00e9ld\u00e1nyon futtatni, amely egy m\u00e1sik szerveren van, mert ez egy nem dokument\u00e1lt dolog. Bizonyos esetekben ez <noindex><a rel=\"nofollow\" href=\"https:\/\/connect.microsoft.com\/SQLServer\/feedback\/details\/776144\/dbcc-page-incorrect-output-with-filtered-indexes\">d\u00f6mpingel\u00e9shez vezethet<\/a><\/noindex> (<i>f\u0151k. ford\u00edt\u00f3 \u2014 a hivatkoz\u00e1s sajnos semmire sem vezet, de a URL alapj\u00e1n sz\u0171rt indexekr\u0151l van sz\u00f3.<\/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>\nA tal\u00e1latokhoz g\u00f6rgetve megtal\u00e1lhatjuk az object_id-t \u00e9s index_id-t.<br \/>\n<img decoding=\"async\" alt=\"A Key \u00e9s Page WaitResource dek\u00f3dol\u00e1sa holtpontokban \u00e9s z\u00e1rol\u00e1sokban\" src=\"\/wp-content\/uploads\/2020\/10\/c5a42f36fb7a87cfd2e11adfef3caa17.png\" style=\"display:block;margin: 0 auto;\" \/><br \/>\nMajdnem k\u00e9sz! Most m\u00e1r lek\u00e9rdez\u00e9ssel megtal\u00e1lhat\u00f3k a t\u00e1bl\u00e1k \u00e9s indexek nevei:<\/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>\n\u00c9s l\u00e1thatjuk, hogy a v\u00e1rakoz\u00e1s a blokkol\u00e1s szempontj\u00e1b\u00f3l a Sales.OrderLines t\u00e1bla PK_Sales_OrderLines index\u00e9n volt.<\/p>\n<p>Megjegyz\u00e9s: SQL Server 2014-t\u0151l kezd\u0151d\u0151en az objektum nev\u00e9t egy dokument\u00e1latlan DMO sys.dm_db_database_page_allocations seg\u00edts\u00e9g\u00e9vel is meg lehet tal\u00e1lni. De minden egyes oldalt le kell k\u00e9rdezni az adatb\u00e1zisban, ami nem igaz\u00e1n men\u0151 nagy adatb\u00e1zisok eset\u00e9n, ez\u00e9rt \u00e9n a DBCC PAGE-t haszn\u00e1ltam.<\/p>\n<h4>1.4) Meg lehet n\u00e9zni azokat az adatokat, amelyek a blokkolt oldalon voltak?<\/h4>\n<p>\nH\u00e1t, igen. De... biztos, hogy erre t\u00e9nyleg sz\u00fcks\u00e9g van?<br \/>\nEz lass\u00fa m\u00e9g a kis t\u00e1bl\u00e1k eset\u00e9n is. De valami\u00e9rt \u00e9rdekes, \u00edgy ha m\u00e1r eddig eljutott\u00e1l... besz\u00e9lj\u00fcnk a %%physloc%%-r\u00f3l!<\/p>\n<p>A %%physloc%% egy dokument\u00e1latlan var\u00e1zslat, amely visszaadja a fizikai azonos\u00edt\u00f3t minden egyes rekordhoz. Haszn\u00e1lhatod <noindex><a rel=\"nofollow\" href=\"http:\/\/www.sqlskills.com\/blogs\/paul\/sql-server-2008-new-undocumented-physical-row-locator-function\/\">%%physloc%% a sys.fn_PhysLocFormatter-rel SQL Server 2008-t\u00f3l kezd\u0151d\u0151en<\/a><\/noindex>.<\/p>\n<p>Most, hogy tudjuk, hogy a Sales.OrderLines t\u00e1bl\u00e1ban akartunk blokkolni egy oldalt, megn\u00e9zhetj\u00fck a t\u00e1bl\u00e1ban tal\u00e1lhat\u00f3 \u00f6sszes adatot, amelyek a #3 adatf\u00e1jl #70133 oldal\u00e1n tal\u00e1lhat\u00f3k, a k\u00f6vetkez\u0151 lek\u00e9rdez\u00e9ssel:<\/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>Ahogy mondtam, ez lass\u00fa m\u00e9g a pici t\u00e1bl\u00e1k eset\u00e9n is. A lek\u00e9rdez\u00e9shez NOLOCK-ot adtam, mert \u00fagyis nincs garancia arra, hogy az adatok, amiket megn\u00e9zni szeretn\u00e9nk, pontosan azok, amelyek akkor voltak, amikor a blokkol\u00e1s \u00e9szlelve lett \u2014 sz\u00f3val nyugodtan v\u00e9gezhet\u00fcnk piszkos olvas\u00e1sokat.<br \/>\nDe, hurr\u00e1, a lek\u00e9rdez\u00e9s visszaadta nekem azokat a 25 sort, amelyek\u00e9rt a k\u00e9r\u00e9s\u00fcnk harcolt.<br \/>\n<img decoding=\"async\" alt=\"A Key \u00e9s Page WaitResource dek\u00f3dol\u00e1sa holtpontokban \u00e9s z\u00e1rol\u00e1sokban\" src=\"\/wp-content\/uploads\/2020\/10\/e7909bb7c496d9509e5f5a1aa30a135a.png\" style=\"display:block;margin: 0 auto;\" \/><br \/>\nEl\u00e9g a PAGE-blokkol\u00e1sokr\u00f3l. Mi van, ha KEY-blokkol\u00e1st v\u00e1runk?<\/p>\n<h3>2) waitresource=\"KEY: 6:72057594041991168 (ce52f92a058c)\" = Database_Id, HOBT_Id (var\u00e1zslatos hash, amelyet %%lockres%% seg\u00edts\u00e9g\u00e9vel dek\u00f3dolhatsz, ha t\u00e9nyleg akarod)<\/h3>\n<p>Ha a lek\u00e9rdez\u00e9sed rekorderz\u00e9kre pr\u00f3b\u00e1l blokkolni \u00e9s blokkolva van, egy teljesen m\u00e1s t\u00edpus\u00fa c\u00edmet kapsz.<br \/>\nA \"6:72057594041991168 (ce52f92a058c)\" bont\u00e1s\u00e1val azt kapjuk:<\/p>\n<ul>\n<li>database_id = 6<\/li>\n<li>hobt_id = 72057594041991168<\/li>\n<li>var\u00e1zslatos hash = (ce52f92a058c)<\/li>\n<\/ul>\n<h4>2.1) Dek\u00f3doljuk a database_id-t<\/h4>\n<p>\nEz pontosan ugyan\u00fagy m\u0171k\u00f6dik, mint a fenti p\u00e9ld\u00e1ban! Az adatb\u00e1zis nev\u00e9t a lek\u00e9rdez\u00e9s seg\u00edts\u00e9g\u00e9vel tal\u00e1ljuk meg:<\/p>\n<pre><code class=\"sql\">SELECT \n    name \nFROM sys.databases \nWHERE database_id=6;\nGO<\/code><\/pre>\n<p>\nAz \u00e9n esetemben ez m\u00e9g mindig az <noindex><a rel=\"nofollow\" href=\"https:\/\/www.littlekendra.com\/2016\/09\/13\/deadlock-code-for-the-wideworldimporters-sample-database\/\">WideWorldImporters adatb\u00e1zis<\/a><\/noindex>.<\/p>\n<h4>2.2) Fejts\u00fck vissza a hobt_id-t<\/h4>\n<p>\nA megtal\u00e1lt adatb\u00e1zis kontextus\u00e1ban le kell futtatni egy lek\u00e9rdez\u00e9st a sys.partitions-hoz, egy p\u00e1r \u00f6sszekapcsol\u00e1ssal, amelyek seg\u00edtenek meghat\u00e1rozni a t\u00e1bl\u00e1zat \u00e9s az index nev\u00e9t...<\/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>\nAzt mondja nekem, hogy a lek\u00e9rdez\u00e9s az Application.Countries z\u00e1rol\u00e1s\u00e1ra v\u00e1rt, a PK_Application_Countries indexet haszn\u00e1lva.<\/p>\n<h4>2.3) Most egy kis var\u00e1zslat %%lockres%% \u2014 ha szeretn\u00e9d kider\u00edteni, melyik rekord volt z\u00e1rolva<\/h4>\n<p>\nHa val\u00f3ban szeretn\u00e9m tudni, melyik sorra volt sz\u00fcks\u00e9g a z\u00e1rol\u00e1sn\u00e1l, akkor ezt a t\u00e1bl\u00e1zat legjobb lek\u00e9rdez\u00e9s\u00e9vel megtudhatom. Az %%lockres%% nem dokument\u00e1lt funkci\u00f3t haszn\u00e1lhatjuk, hogy megtal\u00e1ljuk a rekordot, amely megegyezik a var\u00e1zslatos hashel.<br \/>\nNe feledd, hogy ez a lek\u00e9rdez\u00e9s v\u00e9gigmegy az eg\u00e9sz t\u00e1bl\u00e1zaton, \u00e9s nagy t\u00e1bl\u00e1k eset\u00e9ben ez nem biztos, hogy sz\u00f3rakoztat\u00f3 lesz:<\/p>\n<pre><code class=\"sql\">SELECT\n    *\nFROM Application.Countries (NOLOCK)\nWHERE %%lockres%% = '(ce52f92a058c)';\nGO<\/code><\/pre>\n<p>\nHozz\u00e1adtam a NOLOCK-at (<noindex><a rel=\"nofollow\" href=\"https:\/\/twitter.com\/Aschenbrenner\/status\/788036874891853824\">Klaus Aschenbrenner Twitter javaslata alapj\u00e1n<\/a><\/noindex>) mert a z\u00e1rol\u00e1sok probl\u00e9m\u00e1t okozhatnak. Csak azt akarjuk megn\u00e9zni, mi van ott most, nem azt, ami akkor volt, amikor a tranzakci\u00f3 elkezd\u0151d\u00f6tt \u2014 nem hiszem, hogy az adatok konzisztenci\u00e1ja fontos nek\u00fcnk.<br \/>\nVoil\u00e0, a rekord, ami\u00e9rt k\u00fczd\u00f6tt\u00fcnk!<br \/>\n<img decoding=\"async\" alt=\"A Key \u00e9s Page WaitResource dek\u00f3dol\u00e1sa holtpontokban \u00e9s z\u00e1rol\u00e1sokban\" src=\"\/wp-content\/uploads\/2020\/10\/4107bfa33261ea62d17f27f61b1b4c23.png\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<\/p>\n<h3>K\u00f6sz\u00f6netnyilv\u00e1n\u00edt\u00e1s \u00e9s tov\u00e1bbi olvasm\u00e1nyok<\/h3>\n<p>\nNem eml\u00e9kszem, ki \u00edrta el\u0151sz\u00f6r ezeket a dolgokat, de itt van k\u00e9t bejegyz\u00e9s a legkev\u00e9sb\u00e9 dokument\u00e1lt dolgokr\u00f3l, amik tetszhetnek neked:<\/p>\n<ul>\n<li>Paul Randal bejegyz\u00e9se a <noindex><a rel=\"nofollow\" href=\"http:\/\/www.sqlskills.com\/blogs\/paul\/sql-server-2008-new-undocumented-physical-row-locator-function\/\">%%physloc%% \u00e9s sys.fn_PhysLocFormatter<\/a><\/noindex> (ahogy az adatainkat az els\u0151 p\u00e9ld\u00e1ban kezelt\u00fck)<\/li>\n<li>K\u00e9rd\u00e9s a StackOverflow-on a <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\">%%lockres%% haszn\u00e1lat\u00e1r\u00f3l<\/a><\/noindex> (ahogy a m\u00e1sodik p\u00e9ld\u00e1ban megtal\u00e1ltuk az adatokat). Az egyik v\u00e1lasz utal egy bejegyz\u00e9sre <noindex><a rel=\"nofollow\" href=\"http:\/\/www.scarydba.com\/2010\/03\/18\/undocumented-virtual-column-lockres\/\">Grant Fritchey %%lockres%%-r\u0151l \u00edrt bejegyz\u00e9s\u00e9re, amit m\u00e9g 2010-ben \u00edrtak.<\/a><\/noindex>.<\/li>\n<\/ul>\n<p>Forr\u00e1s: <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.3 - 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\/hu\/blog\/administrirovanie\/rasshifrovyvaem-key-i-page-waitresource-v-dedlokah-i-blokirovkah\" \/>\n\t\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.3\" \/>\n\t\t<meta property=\"og:locale\" content=\"hu_HU\" \/>\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\/hu\/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\udd47A Key \u00e9s Page WaitResource dek\u00f3dol\u00e1sa holtpontokban \u00e9s blokkol\u00e1sokban | ProHoster","description":"Ha blokkol\u00e1si jelent\u00e9st (blocked process report) haszn\u00e1lsz, vagy a SQL Server \u00e1ltal biztos\u00edtott holtpont grafikonokat gy\u0171jtesz rendszeresen, ezekkel a dolgokkal fogsz tal\u00e1lkozni:","canonical_url":"https:\/\/prohoster.info\/hu\/blog\/administrirovanie\/rasshifrovyvaem-key-i-page-waitresource-v-dedlokah-i-blokirovkah","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"hu_HU","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\/hu\/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\/hu\/wp-json\/wp\/v2\/posts\/97702","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/comments?post=97702"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/posts\/97702\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/media\/97703"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/media?parent=97702"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/categories?post=97702"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/tags?post=97702"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}