1"use strict";(globalThis.webpackChunkdbmarlin_kb=globalThis.webpackChunkdbmarlin_kb||[]).push([[8487],{99136(e,s,t){t.r(s),t.d(s,{assets:()=>l,contentTitle:()=>o,default:()=>h,frontMatter:()=>a,metadata:()=>i,toc:()=>c});const i=JSON.parse('{"id":"kb/wait-events/sqlserver/PAGEIOLATCH_DT","title":"PAGEIOLATCH_DT","description":"Occurs when a task is waiting on a latch for a buffer that is in an I/O request. The latch request is in Destroy mode. Long waits may indicate problems with the disk subsystem.","source":"@site/docs/kb/wait-events/sqlserver/PAGEIOLATCH_DT 7f48ee920a444e8ab681e64f0fbe9b34.md","sourceDirName":"kb/wait-events/sqlserver","slug":"/kb/wait-events/sqlserver/pageiolatch_dt","permalink":"/docs/kb/wait-events/sqlserver/pageiolatch_dt","draft":false,"unlisted":false,"editUrl":"https://www.dbmarlin.com/knowledge-base-suggestion","tags":[],"version":"current","frontMatter":{"id":"PAGEIOLATCH_DT","slug":"pageiolatch_dt","title":"PAGEIOLATCH_DT","sidebar_label":"PAGEIOLATCH_DT","custom_edit_url":"https://www.dbmarlin.com/knowledge-base-suggestion"},"sidebar":"tutorialSidebar","previous":{"title":"ONDEMAND_TASK_QUEUE","permalink":"/docs/kb/wait-events/sqlserver/ondemand_task_queue"},"next":{"title":"PAGEIOLATCH_EX","permalink":"/docs/kb/wait-events/sqlserver/pageiolatch_ex"}}');var n=t(74848),r=t(28453);const a={id:"PAGEIOLATCH_DT",slug:"pageiolatch_dt",title:"PAGEIOLATCH_DT",sidebar_label:"PAGEIOLATCH_DT",custom_edit_url:"https://www.dbmarlin.com/knowledge-base-suggestion"},o=void 0,l={},c=[{value:"Detailed Description",id:"detailed-description",level:2},{value:"How to reduce this wait",id:"how-to-reduce-this-wait",level:2},{value:"Additional Links",id:"additional-links",level:2},{value:"Search online",id:"search-online",level:2}];function d(e){const s={a:"a",admonition:"admonition",code:"code",h2:"h2",li:"li",p:"p",strong:"strong",ul:"ul",...(0,r.R)(),...e.components};return(0,n.jsxs)(n.Fragment,{children:[(0,n.jsx)("iframe",{id:"top-banner",src:"https://docs.dbmarlin.com/img/html/top-banner.html",width:"100%",scrolling:"no"}),"\n",(0,n.jsx)(s.admonition,{title:"Short Description",type:"tip",children:(0,n.jsx)(s.p,{children:"Occurs when a task is waiting on a latch for a buffer that is in an I/O request. The latch request is in Destroy mode. Long waits may indicate problems with the disk subsystem."})}),"\n",(0,n.jsx)(s.h2,{id:"detailed-description",children:"Detailed Description"}),"\n",(0,n.jsx)(s.p,{children:"Latches are lightweight, fast methods of managing concurrency on a specific resource."}),"\n",(0,n.jsxs)(s.p,{children:["The ",(0,n.jsx)(s.code,{children:"PAGEIOLATCH_*"})," group of latches are seen in management of data pages."]}),"\n",(0,n.jsxs)(s.p,{children:[(0,n.jsx)(s.code,{children:"PAGEIOLATCH_DT"})," is waiting for a latch to be allocated in destroy (DT) mode. There is little evidence of this event being seen in the real world."]}),"\n",(0,n.jsx)(s.h2,{id:"how-to-reduce-this-wait",children:"How to reduce this wait"}),"\n",(0,n.jsxs)(s.p,{children:["Whilst long waits on ",(0,n.jsx)(s.code,{children:"PAGEIOLATCH_*"})," may indicate problems with the disk subsystem, it is important to check against a performance baseline to check:"]}),"\n",(0,n.jsxs)(s.ul,{children:["\n",(0,n.jsx)(s.li,{children:"Check for large increase in the volume of I/O"}),"\n",(0,n.jsx)(s.li,{children:"Check for large increases in database time"}),"\n",(0,n.jsx)(s.li,{children:"Check for large increases in the volume of queries"}),"\n",(0,n.jsx)(s.li,{children:"Check for changes in execution plans"}),"\n"]}),"\n",(0,n.jsx)(s.h2,{id:"additional-links",children:"Additional Links"}),"\n",(0,n.jsxs)(s.ul,{children:["\n",(0,n.jsx)(s.li,{children:(0,n.jsx)(s.a,{href:"https://docs.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-os-wait-stats-transact-sql#WaitTypes",children:"Microsoft Docs - sys.dm_os_wait_stats (Transact-SQL)"})}),"\n",(0,n.jsx)(s.li,{children:(0,n.jsx)(s.a,{href:"https://sqlperformance.com/2014/06/io-subsystem/knee-jerk-waits-pageiolatch-sh",children:"sqlperformance.com - Knee-Jerk Wait Statistics : PAGEIOLATCH_SH"})}),"\n",(0,n.jsx)(s.li,{children:(0,n.jsx)(s.a,{href:"https://www.sqlskills.com/help/waits/pageiolatch_sh/",children:"sqlskills.com - PAGEIOLATCH_SH"})}),"\n"]}),"\n",(0,n.jsx)(s.h2,{id:"search-online",children:"Search online"}),"\n",(0,n.jsxs)(s.p,{children:["If this article doesn't have the information you need you can try searching online. Remember, you can ",(0,n.jsx)(s.strong,{children:(0,n.jsx)(s.a,{href:"https://www.dbmarlin.com/knowledge-base-suggestion",children:"contribute suggestions to this page"})}),"."]}),"\n",(0,n.jsxs)(s.ul,{children:["\n",(0,n.jsx)(s.li,{children:(0,n.jsx)(s.a,{href:"https://www.google.com/search?q=sqlserver+%27PAGEIOLATCH_DT%27+wait",children:"Google Search for sqlserver - PAGEIOLATCH_DT"})}),"\n",(0,n.jsx)(s.li,{children:(0,n.jsx)(s.a,{href:"https://www.ecosia.org/search?q=sqlserver+%27PAGEIOLATCH_DT%27+wait",children:"Ecosia Search for sqlserver - PAGEIOLATCH_DT"})}),"\n",(0,n.jsx)(s.li,{children:(0,n.jsx)(s.a,{href:"https://www.bing.com/search?q=sqlserver+%27PAGEIOLATCH_DT%27+wait",children:"Bing Search for sqlserver - PAGEIOLATCH_DT"})}),"\n"]}),"\n",(0,n.jsx)("iframe",{id:"bottom-banner",src:"https://docs.dbmarlin.com/img/html/bottom-banner.html",width:"100%",scrolling:"no"})]})}function h(e={}){const{wrapper:s}={...(0,r.R)(),...e.components};return s?(0,n.jsx)(s,{...e,children:(0,n.jsx)(d,{...e})}):d(e)}},28453(e,s,t){t.d(s,{R:()=>a,x:()=>o});var i=t(96540);const n={},r=i.createContext(n);function a(e){const s=i.useContext(r);return i.useMemo(function(){return"function"==typeof e?e(s):{...s,...e}},[s,e])}function o(e){let s;return s=e.disableParentContext?"function"==typeof e.components?e.components(n):e.components||n:a(e.components),i.createElement(r.Provider,{value:s},e.children)}}}]);
Line numbers count LF bytes from the start of the resource, as the search results do. Vendor segments are library code the classifier recognised; they are stored but not indexed. Bytes are shown as Latin1 characters, one per byte.