{"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\/sv\/blog\/administrirovanie\/rasshifrovyvaem-key-i-page-waitresource-v-dedlokah-i-blokirovkah","title":{"rendered":"Avkodning av Key och Page WaitResource i deadlocks och l\u00e5sningar","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p>Om du anv\u00e4nder rapporten om blockeringar (blocked process report) eller samlar in d\u00f6dl\u00e4gesgrafer som tillhandah\u00e5lls av SQL Server, kommer du regelbundet att st\u00f6ta p\u00e5 s\u00e5dana h\u00e4r saker: <\/p>\n<blockquote><p>waitresource=\"PAGE: 6:3:70133\"<\/p>\n<p>waitresource=\"KEY: 6:72057594041991168 (ce52f92a058c)\"<\/p><\/blockquote>\n<p>\nIbland, i den gigantiska XML som du studerar, kommer det att finnas mer information (d\u00f6dl\u00e4gesgrafer inneh\u00e5ller en lista \u00f6ver resurser som hj\u00e4lper till att identifiera objekt- och indexnamn), men det \u00e4r inte alltid.<\/p>\n<p>Denna text hj\u00e4lper dig att avkoda dem.<\/p>\n<p>All information som finns h\u00e4r finns p\u00e5 internet p\u00e5 olika st\u00e4llen, den \u00e4r bara mycket spridd! Jag vill samla allt p\u00e5 ett st\u00e4lle \u2014 fr\u00e5n DBCC PAGE till hobt_id och de odokumenterade %%physloc%% och %%lockres%% funktionerna.<br \/>\n<noindex><a rel=\"nofollow\" name=\"habracut\"><\/a><\/noindex><br \/>\nF\u00f6rst pratar vi om v\u00e4ntan p\u00e5 PAGE-blockeringar, och sedan g\u00e5r vi vidare till KEY-blockeringar.<\/p>\n<h3>1) waitresource=\"PAGE: 6:3:70133\" = Databas_Id: FilId: Sidanummer<\/h3>\n<p>\nOm din fr\u00e5ga v\u00e4ntar p\u00e5 en PAGE-blockering, kommer SQL Server att ge dig adressen till den sidan.<\/p>\n<p>Genom att bryta ner \"PAGE: 6:3:70133\" f\u00e5r vi:<\/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) Avkodar database_id<\/h4>\n<p>\nVi hittar databasnamnet med hj\u00e4lp av en fr\u00e5ga:<\/p>\n<pre><code class=\"sql\">SELECT \n    name \nFROM sys.databases \nWHERE database_id=6;\nGO<\/code><\/pre>\n<p>\nDet \u00e4r en offentlig <noindex><a rel=\"nofollow\" href=\"https:\/\/www.littlekendra.com\/2016\/09\/13\/deadlock-code-for-the-wideworldimporters-sample-database\/\">databas WideWorldImporters<\/a><\/noindex> p\u00e5 min SQL Server.<\/p>\n<h4>1.2) Letar efter namnet p\u00e5 datafilen \u2014 om du \u00e4r intresserad<\/h4>\n<p>\nVi kommer att anv\u00e4nda data_file_id i n\u00e4sta steg f\u00f6r att hitta namnet p\u00e5 tabellen. Du kan bara g\u00e5 vidare till n\u00e4sta steg, men om du \u00e4r intresserad av filnamnet kan du hitta det genom att k\u00f6ra en fr\u00e5ga i kontexten av den hittade databasen, d\u00e4r du stoppar in data_file_id i denna fr\u00e5ga:<\/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>\nI databasen WideWorldImporters \u00e4r detta filen som heter WWI_UserData och den finns \u00e5terst\u00e4lld hos mig i C:MSSQLDATAWideWorldImporters_UserData.ndf. (Oops, du f\u00e5ngade mig med hur jag l\u00e4gger filer p\u00e5 disken med systemet! Nej! Det blev lite pinsamt).<\/p>\n<h4>1.3) F\u00e5r objektets namn fr\u00e5n DBCC PAGE<\/h4>\n<p>\nNu vet vi att sidan #70133 i datafilen 3 tillh\u00f6r databasen WorldWideImporters. Vi kan titta p\u00e5 inneh\u00e5llet p\u00e5 denna sida med hj\u00e4lp av den odokumenterade DBCC PAGE och trace-flaggan 3604.<br \/>\nObs: Jag f\u00f6redrar att anv\u00e4nda DBCC PAGE p\u00e5 en \u00e5terst\u00e4lld backup-kopia n\u00e5gon annanstans p\u00e5 en annan server, eftersom detta \u00e4r en odokumenterad funktion. I vissa fall kan den <noindex><a rel=\"nofollow\" href=\"https:\/\/connect.microsoft.com\/SQLServer\/feedback\/details\/776144\/dbcc-page-incorrect-output-with-filtered-indexes\">lede till att en dump skapas<\/a><\/noindex> (<i>\u00f6vers. av \u00f6vers\u00e4ttaren \u2014 l\u00e4nken g\u00e5r tyv\u00e4rr ingenstans, men det verkar enligt url handla om filtrerade index<\/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>\nGenom att bl\u00e4ddra till resultaten kan man hitta object_id och index_id.<br \/>\n<img decoding=\"async\" alt=\"Avkodning av Key och Page WaitResource i deadlocks och l\u00e5sningar\" src=\"\/wp-content\/uploads\/2020\/10\/c5a42f36fb7a87cfd2e11adfef3caa17.png\" style=\"display:block;margin: 0 auto;\" \/><br \/>\nN\u00e4stan klart! Nu kan vi hitta namn p\u00e5 tabellen och indexet med hj\u00e4lp av en fr\u00e5ga:<\/p>\n<pre><code class=\"sql\">ANV\u00c4ND WideWorldImporters;\nGO\nV\u00c4LJ \n    sc.name AS schema_name, \n    so.name AS object_name, \n    si.name AS index_name\nFR\u00c5N 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\nD\u00c4R \n    so.object_id = 94623380\n    OCH si.index_id = 1;\nGO<\/code><\/pre>\n<p>\nOch h\u00e4r ser vi att v\u00e4ntan p\u00e5 l\u00e5sningen var p\u00e5 indexet PK_Sales_OrderLines i tabellen Sales.OrderLines.<\/p>\n<p>Observera: i SQL Server 2014 och senare kan du ocks\u00e5 hitta objektnamnet med hj\u00e4lp av den icke dokumenterade DMO sys.dm_db_database_page_allocations. Men du m\u00e5ste beg\u00e4ra varje sida i databasen, vilket inte \u00e4r mycket stiligt f\u00f6r stora databaser, s\u00e5 jag anv\u00e4nde DBCC PAGE.<\/p>\n<h4>1.4) Kan vi se data p\u00e5 den sida som var l\u00e5st?<\/h4>\n<p>\nNja, jo. Men\u2026 \u00e4r du s\u00e4ker p\u00e5 att du verkligen beh\u00f6ver det?<br \/>\nDet \u00e4r l\u00e5ngsamt \u00e4ven p\u00e5 sm\u00e5 tabeller. Men det verkar \u00e4nd\u00e5 coolt, s\u00e5 eftersom du har l\u00e4st till den h\u00e4r punkten\u2026 l\u00e5t oss prata om %%physloc%%!<\/p>\n<p>%%physloc%% \u00e4r en icke dokumenterad bit magi som returnerar den fysiska identifieraren f\u00f6r varje post. Du kan anv\u00e4nda <noindex><a rel=\"nofollow\" href=\"http:\/\/www.sqlskills.com\/blogs\/paul\/sql-server-2008-new-undocumented-physical-row-locator-function\/\">%%physloc%% tillsammans med sys.fn_PhysLocFormatter i SQL Server 2008 och senare<\/a><\/noindex>.<\/p>\n<p>Nu n\u00e4r vi vet att vi ville l\u00e5sa sidan i Sales.OrderLines kan vi se all data i denna tabell som lagras i datakatalog #3 p\u00e5 sida #70133 med hj\u00e4lp av f\u00f6ljande fr\u00e5ga:<\/p>\n<pre><code class=\"sql\">ANV\u00c4ND WideWorldImporters;\nGO\nV\u00c4LJ \n    sys.fn_PhysLocFormatter (%%physloc%%),\n    *\nFR\u00c5N Sales.OrderLines (NOLOCK)\nD\u00c4R sys.fn_PhysLocFormatter (%%physloc%%) LIKT '(3:70133%'\nGO<\/code><\/pre>\n<p>Som jag sa \u2013 det \u00e4r l\u00e5ngsamt \u00e4ven p\u00e5 pyttesm\u00e5 tabeller. Jag lade till NOLOCK till fr\u00e5gan eftersom vi \u00e4nd\u00e5 inte har n\u00e5gra garantier f\u00f6r att de data vi vill titta p\u00e5 verkligen \u00e4r de samma som n\u00e4r l\u00e5sningen uppt\u00e4cktes \u2013 s\u00e5 vi kan lugnt g\u00f6ra smutsiga l\u00e4sningar.<br \/>\nMen, hurra, fr\u00e5gan returnerar de d\u00e4r 25 raderna som v\u00e5r fr\u00e5ga k\u00e4mpade f\u00f6r<br \/>\n<img decoding=\"async\" alt=\"Avkodning av Key och Page WaitResource i deadlocks och l\u00e5sningar\" src=\"\/wp-content\/uploads\/2020\/10\/e7909bb7c496d9509e5f5a1aa30a135a.png\" style=\"display:block;margin: 0 auto;\" \/><br \/>\nNog om PAGE-l\u00e5sningar. Vad h\u00e4nder om vi v\u00e4ntar p\u00e5 KEY-l\u00e5sning?<\/p>\n<h3>2) waitresource=\"KEY: 6:72057594041991168 (ce52f92a058c)\" = Database_Id, HOBT_Id (den magiska hash som kan avkodas med hj\u00e4lp av %%lockres%% om du verkligen vill)<\/h3>\n<p>Om din fr\u00e5ga f\u00f6rs\u00f6ker l\u00e4gga en l\u00e5s p\u00e5 en post i indexet och blir l\u00e5st sj\u00e4lv, f\u00e5r du en helt annan typ av adress.<br \/>\nGenom att dela upp \"6:72057594041991168 (ce52f92a058c)\" f\u00e5r vi:<\/p>\n<ul>\n<li>database_id = 6<\/li>\n<li>hobt_id = 72057594041991168<\/li>\n<li>den magiska hash = (ce52f92a058c)<\/li>\n<\/ul>\n<h4>2.1) Avkodar databasen_id<\/h4>\n<p>\nDet fungerar p\u00e5 samma s\u00e4tt som i exemplet ovan! Vi hittar databasnamnet med hj\u00e4lp av en fr\u00e5ga:<\/p>\n<pre><code class=\"sql\">SELECT \n    name \nFROM sys.databases \nWHERE database_id=6;\nGO<\/code><\/pre>\n<p>\nI mitt fall \u00e4r det fortfarande samma <noindex><a rel=\"nofollow\" href=\"https:\/\/www.littlekendra.com\/2016\/09\/13\/deadlock-code-for-the-wideworldimporters-sample-database\/\">databas WideWorldImporters<\/a><\/noindex>.<\/p>\n<h4>2.2) Avkodar hobt_id<\/h4>\n<p>\nI den funna databasen m\u00e5ste vi utf\u00f6ra en fr\u00e5ga till sys.partitions med ett par joins som kommer att hj\u00e4lpa oss att best\u00e4mma namnen p\u00e5 tabellen och indexet\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>\nHan ber\u00e4ttar f\u00f6r mig att fr\u00e5gan v\u00e4ntade p\u00e5 l\u00e5set Application.Countries, med hj\u00e4lp av indexet PK_Application_Countries.<\/p>\n<h4>2.3) Nu lite magi %%lockres%% \u2014 om du vill ta reda p\u00e5 vilken post som var l\u00e5st<\/h4>\n<p>\nOm jag verkligen vill veta vilken rad som beh\u00f6vde l\u00e5sa kan jag ta reda p\u00e5 det med hj\u00e4lp av en fr\u00e5ga till sj\u00e4lva tabellen. Vi kan anv\u00e4nda den icke-dokumenterade funktionen %%lockres%% f\u00f6r att hitta posten som matchar den magiska hash.<br \/>\nT\u00e4nk p\u00e5 att denna fr\u00e5ga kommer att skanna hela tabellen, och p\u00e5 stora tabeller kan det bli ganska besv\u00e4rligt:<\/p>\n<pre><code class=\"sql\">SELECT\n    *\nFROM Application.Countries (NOLOCK)\nWHERE %%lockres%% = '(ce52f92a058c)';\nGO<\/code><\/pre>\n<p>\nJag lade till NOLOCK (<noindex><a rel=\"nofollow\" href=\"https:\/\/twitter.com\/Aschenbrenner\/status\/788036874891853824\">p\u00e5 r\u00e5d av Klaus Aschenbrenner p\u00e5 Twitter<\/a><\/noindex>) eftersom l\u00e5sningar kan bli ett problem. Vi vill bara snabbt kolla vad som finns d\u00e4r just nu, inte vad som fanns d\u00e4r n\u00e4r transaktionen b\u00f6rjade \u2014 jag tror inte att datakonsistens \u00e4r viktigt f\u00f6r oss.<br \/>\nVoila, posten som vi k\u00e4mpade f\u00f6r!<br \/>\n<img decoding=\"async\" alt=\"Avkodning av Key och Page WaitResource i deadlocks och l\u00e5sningar\" src=\"\/wp-content\/uploads\/2020\/10\/4107bfa33261ea62d17f27f61b1b4c23.png\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<\/p>\n<h3>Tack och vidare l\u00e4sning<\/h3>\n<p>\nJag minns inte vem som f\u00f6rst beskrev m\u00e5nga av dessa saker, men h\u00e4r \u00e4r tv\u00e5 inl\u00e4gg om de minst dokumenterade grejerna som kan intressera dig:<\/p>\n<ul>\n<li>Paul Randals inl\u00e4gg om <noindex><a rel=\"nofollow\" href=\"http:\/\/www.sqlskills.com\/blogs\/paul\/sql-server-2008-new-undocumented-physical-row-locator-function\/\">%%physloc%% och sys.fn_PhysLocFormatter<\/a><\/noindex> (som vi hittade v\u00e5ra data i det f\u00f6rsta exemplet)<\/li>\n<li>En fr\u00e5ga p\u00e5 StackOverflow om <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\">anv\u00e4ndningen av %%lockres%%<\/a><\/noindex> (som vi fann data i det andra exemplet). Ett av svaren leder till ett inl\u00e4gg <noindex><a rel=\"nofollow\" href=\"http:\/\/www.scarydba.com\/2010\/03\/18\/undocumented-virtual-column-lockres\/\">av Grant Fritchey om %%lockres%%, skrivet redan 2010<\/a><\/noindex>.<\/li>\n<\/ul>\n<p>K\u00e4lla: <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.4 - 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\/sv\/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.4\" \/>\n\t\t<meta property=\"og:locale\" content=\"sv_SE\" \/>\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\/sv\/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\udd47Avkodar Key och Page WaitResource i d\u00f6dl\u00e4gen och blockeringar | ProHoster","description":"Om du anv\u00e4nder blockeringsrapporter (blocked process report) eller samlar in d\u00f6dl\u00e4gesdiagram som tillhandah\u00e5lls av SQL Server, kommer du ibland att st\u00f6ta p\u00e5 s\u00e5dana h\u00e4r saker:","canonical_url":"https:\/\/prohoster.info\/sv\/blog\/administrirovanie\/rasshifrovyvaem-key-i-page-waitresource-v-dedlokah-i-blokirovkah","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"sv_SE","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\/sv\/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\/sv\/wp-json\/wp\/v2\/posts\/97702","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/sv\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/sv\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sv\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sv\/wp-json\/wp\/v2\/comments?post=97702"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/sv\/wp-json\/wp\/v2\/posts\/97702\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sv\/wp-json\/wp\/v2\/media\/97703"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/sv\/wp-json\/wp\/v2\/media?parent=97702"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/sv\/wp-json\/wp\/v2\/categories?post=97702"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/sv\/wp-json\/wp\/v2\/tags?post=97702"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}