{"id":52891,"date":"2022-11-01T16:16:05","date_gmt":"2022-11-01T16:16:05","guid":{"rendered":"https:\/\/dbtut.com\/?p=52891"},"modified":"2022-11-01T16:28:18","modified_gmt":"2022-11-01T16:28:18","slug":"sql-server-disk-latency","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2022\/11\/01\/sql-server-disk-latency\/","title":{"rendered":"SQL Server Disk Latency"},"content":{"rendered":"<p>There are actually several ways to control disk latency in SQL Server. But in this article, I will be explaining the most frequently used DMV (Dynamic Management View).<\/p>\n<p>Microsoft announced in 2005 that a DMV called sys.dm_io_virtual_file_stats was available. SQL Server records data on execution plans, resource usage, physical and logical uses of indexes since the last boot.<\/p>\n<p>We can get information about the status of the system by querying them. The dm_io_virtual_file_stats function is one of them and returns I\/O usage statistics of data and log files of databases.<\/p>\n<pre class=\"lang:default decode:true\">sys.dm_io_virtual_file_stats (\r\n{ database_id | NULL }\r\n, { file_id | NULL }\r\n)<\/pre>\n<p>Can elaborate on this DMV using the query below.<\/p>\n<pre class=\"lang:default decode:true\">SELECT\r\n   [ReadLatency] =\r\n        CASE WHEN [num_of_reads] = 0\r\n            THEN 0 ELSE ([io_stall_read_ms] \/ [num_of_reads]) END,\r\n   [WriteLatency] =\r\n        CASE WHEN [num_of_writes] = 0\r\n            THEN 0 ELSE ([io_stall_write_ms] \/ [num_of_writes]) END,\r\n   [Latency] =\r\n        CASE WHEN ([num_of_reads] = 0 AND [num_of_writes] = 0)\r\n            THEN 0 ELSE ([io_stall] \/ ([num_of_reads] + [num_of_writes])) END,\r\n   [Latency Desc] = \r\n         CASE \r\n            WHEN ([num_of_reads] = 0 AND [num_of_writes] = 0) THEN 'N\/A' \r\n            ELSE \r\n               CASE WHEN ([io_stall] \/ ([num_of_reads] + [num_of_writes])) &lt; 2 THEN 'Excellent'\r\n                    WHEN ([io_stall] \/ ([num_of_reads] + [num_of_writes])) &lt; 6 THEN 'Very good'\r\n                    WHEN ([io_stall] \/ ([num_of_reads] + [num_of_writes])) &lt; 11 THEN 'Good'\r\n                    WHEN ([io_stall] \/ ([num_of_reads] + [num_of_writes])) &lt; 21 THEN 'Poor'\r\n                    WHEN ([io_stall] \/ ([num_of_reads] + [num_of_writes])) &lt; 101 THEN 'Bad'\r\n                    WHEN ([io_stall] \/ ([num_of_reads] + [num_of_writes])) &lt; 501 THEN 'Alas!'\r\n               ELSE 'Get out!!'\r\n               END \r\n         END, \r\n   [AvgBPerRead] =\r\n        CASE WHEN [num_of_reads] = 0\r\n            THEN 0 ELSE ([num_of_bytes_read] \/ [num_of_reads]) END,\r\n   [AvgBPerWrite] =\r\n        CASE WHEN [num_of_writes] = 0\r\n            THEN 0 ELSE ([num_of_bytes_written] \/ [num_of_writes]) END,\r\n   [AvgBPerTransfer] =\r\n        CASE WHEN ([num_of_reads] = 0 AND [num_of_writes] = 0)\r\n            THEN 0 ELSE\r\n                (([num_of_bytes_read] + [num_of_bytes_written]) \/\r\n                ([num_of_reads] + [num_of_writes])) END,\r\n   LEFT ([mf].[physical_name], 2) AS [Drive],\r\n   DB_NAME ([vfs].[database_id]) AS [DB],\r\n   [mf].[physical_name]\r\nFROM\r\n   sys.dm_io_virtual_file_stats (NULL,NULL) AS [vfs]\r\n   JOIN sys.master_files AS [mf]\r\n   ON [vfs].[database_id] = [mf].[database_id]\r\n      AND [vfs].[file_id] = [mf].[file_id]\r\n --WHERE DB_NAME ([vfs].[database_id])='DBA' -- db name\r\nORDER BY [Latency] DESC\r\n-- ORDER BY [ReadLatency] DESC\r\n-- ORDER BY [WriteLatency] DESC;\r\nGO<\/pre>\n<p>The query output is as follows.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter\" src=\"https:\/\/www.sqlekibi.com\/wp-content\/uploads\/2021\/05\/Resim1-1-1.png\" width=\"778\" height=\"407\" \/><\/p>\n<p>The column named \u201cLatency Desc\u201d will help us to make sense of the query result. Subject to the following values of course.<\/p>\n<p id=\"uMEASRe\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-52894 aligncenter\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2022\/11\/img_636144396409a.png\" alt=\"\" width=\"872\" height=\"339\" \/><\/p>\n<p>The thing to note here is actually the values you see above 101 ms. If you see between these values, it means that there is a disk-based bottleneck, no matter how good you can do at the database level.<\/p>\n<p>In our example, we can easily see that the disk latency of tempdb data and log files is problematic. This data is reset when SQL Server is restarted.<\/p>\n<p>In SQL Server, it is important to have the database files on different physical disks as much as possible. The script below shows the traffic on the drives where the database files are located.<\/p>\n<pre class=\"lang:default decode:true\">select left(mf.physical_name, 1) as drive_letter, sample_ms,\r\nsum(vfs.num_of_writes) as total_num_of_writes,\r\nsum(vfs.num_of_bytes_written) as total_num_of_bytes_written,\r\nsum(vfs.io_stall_write_ms) as total_io_stall_write_ms,\r\nsum(vfs.num_of_reads) as total_num_of_reads,\r\nsum(vfs.num_of_bytes_read) as total_num_of_bytes_read,\r\nsum(vfs.io_stall_read_ms) as total_io_stall_read_ms,\r\nsum(vfs.io_stall) as total_io_stall,\r\nsum(vfs.size_on_disk_bytes) as total_size_on_disk_bytes\r\nfrom sys.master_files mf\r\njoin sys.dm_io_virtual_file_stats(NULL, NULL) vfs\r\non mf.database_id=vfs.database_id and mf.file_id=vfs.file_id\r\ngroup by left(mf.physical_name, 1), sample_ms<\/pre>\n<p>As a result of this query, if most of the traffic is flowing on certain drives, it will be beneficial to move some files there to other drives.<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_52891\" class=\"pvc_stats all  \" data-element-id=\"52891\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"excerpt":{"rendered":"<p>There are actually several ways to control disk latency in SQL Server. But in this article, I will be explaining the most frequently used DMV (Dynamic Management View). Microsoft announced in 2005 that a DMV called sys.dm_io_virtual_file_stats was available. SQL Server records data on execution plans, resource usage, physical and logical uses of indexes since &hellip;<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_52891\" class=\"pvc_stats all  \" data-element-id=\"52891\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"author":1414,"featured_media":52898,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[3],"tags":[],"class_list":["post-52891","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-mssql"],"aioseo_notices":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>SQL Server Disk Latency - Database Tutorials<\/title>\n<meta name=\"description\" content=\"There are actually several ways to control disk latency in SQL Server. But in this article, I will be explaining the most frequently used DMV\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/dbtut.com\/index.php\/2022\/11\/01\/sql-server-disk-latency\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Server Disk Latency - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"There are actually several ways to control disk latency in SQL Server. But in this article, I will be explaining the most frequently used DMV\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2022\/11\/01\/sql-server-disk-latency\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2022-11-01T16:16:05+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-11-01T16:28:18+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2022\/11\/Ekran-goruntusu-2022-11-01-192744.png\" \/>\n\t<meta property=\"og:image:width\" content=\"681\" \/>\n\t<meta property=\"og:image:height\" content=\"308\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"\u00c7a\u011flar \u00d6zen\u00e7\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"\u00c7a\u011flar \u00d6zen\u00e7\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2022\/11\/01\/sql-server-disk-latency\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2022\/11\/01\/sql-server-disk-latency\/\"},\"author\":{\"name\":\"\u00c7a\u011flar \u00d6zen\u00e7\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/92baa6fd666fb707d903177fed07d6ab\"},\"headline\":\"SQL Server Disk Latency\",\"datePublished\":\"2022-11-01T16:16:05+00:00\",\"dateModified\":\"2022-11-01T16:28:18+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2022\/11\/01\/sql-server-disk-latency\/\"},\"wordCount\":268,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2022\/11\/01\/sql-server-disk-latency\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2022\/11\/Ekran-goruntusu-2022-11-01-192744.png\",\"articleSection\":[\"MSSQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2022\/11\/01\/sql-server-disk-latency\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2022\/11\/01\/sql-server-disk-latency\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2022\/11\/01\/sql-server-disk-latency\/\",\"name\":\"SQL Server Disk Latency - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2022\/11\/01\/sql-server-disk-latency\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2022\/11\/01\/sql-server-disk-latency\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2022\/11\/Ekran-goruntusu-2022-11-01-192744.png\",\"datePublished\":\"2022-11-01T16:16:05+00:00\",\"dateModified\":\"2022-11-01T16:28:18+00:00\",\"description\":\"There are actually several ways to control disk latency in SQL Server. But in this article, I will be explaining the most frequently used DMV\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2022\/11\/01\/sql-server-disk-latency\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2022\/11\/01\/sql-server-disk-latency\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2022\/11\/01\/sql-server-disk-latency\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2022\/11\/Ekran-goruntusu-2022-11-01-192744.png\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2022\/11\/Ekran-goruntusu-2022-11-01-192744.png\",\"width\":681,\"height\":308},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2022\/11\/01\/sql-server-disk-latency\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Server Disk Latency\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/dbtut.com\/#website\",\"url\":\"https:\/\/dbtut.com\/\",\"name\":\"Database Tutorials\",\"description\":\"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux\",\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/dbtut.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/dbtut.com\/#organization\",\"name\":\"dbtut\",\"url\":\"https:\/\/dbtut.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"width\":223,\"height\":36,\"caption\":\"dbtut\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/92baa6fd666fb707d903177fed07d6ab\",\"name\":\"\u00c7a\u011flar \u00d6zen\u00e7\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/997658bc236de4f5a0f3f46e64535566e31ba96824c77c01165e863fc38fd1ba?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/997658bc236de4f5a0f3f46e64535566e31ba96824c77c01165e863fc38fd1ba?s=96&d=mm&r=g\",\"caption\":\"\u00c7a\u011flar \u00d6zen\u00e7\"},\"url\":\"https:\/\/dbtut.com\/index.php\/author\/caglarozenc\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SQL Server Disk Latency - Database Tutorials","description":"There are actually several ways to control disk latency in SQL Server. But in this article, I will be explaining the most frequently used DMV","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/dbtut.com\/index.php\/2022\/11\/01\/sql-server-disk-latency\/","og_locale":"en_US","og_type":"article","og_title":"SQL Server Disk Latency - Database Tutorials","og_description":"There are actually several ways to control disk latency in SQL Server. But in this article, I will be explaining the most frequently used DMV","og_url":"https:\/\/dbtut.com\/index.php\/2022\/11\/01\/sql-server-disk-latency\/","og_site_name":"Database Tutorials","article_published_time":"2022-11-01T16:16:05+00:00","article_modified_time":"2022-11-01T16:28:18+00:00","og_image":[{"width":681,"height":308,"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2022\/11\/Ekran-goruntusu-2022-11-01-192744.png","type":"image\/png"}],"author":"\u00c7a\u011flar \u00d6zen\u00e7","twitter_card":"summary_large_image","twitter_misc":{"Written by":"\u00c7a\u011flar \u00d6zen\u00e7","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2022\/11\/01\/sql-server-disk-latency\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2022\/11\/01\/sql-server-disk-latency\/"},"author":{"name":"\u00c7a\u011flar \u00d6zen\u00e7","@id":"https:\/\/dbtut.com\/#\/schema\/person\/92baa6fd666fb707d903177fed07d6ab"},"headline":"SQL Server Disk Latency","datePublished":"2022-11-01T16:16:05+00:00","dateModified":"2022-11-01T16:28:18+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2022\/11\/01\/sql-server-disk-latency\/"},"wordCount":268,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2022\/11\/01\/sql-server-disk-latency\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2022\/11\/Ekran-goruntusu-2022-11-01-192744.png","articleSection":["MSSQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2022\/11\/01\/sql-server-disk-latency\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2022\/11\/01\/sql-server-disk-latency\/","url":"https:\/\/dbtut.com\/index.php\/2022\/11\/01\/sql-server-disk-latency\/","name":"SQL Server Disk Latency - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2022\/11\/01\/sql-server-disk-latency\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2022\/11\/01\/sql-server-disk-latency\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2022\/11\/Ekran-goruntusu-2022-11-01-192744.png","datePublished":"2022-11-01T16:16:05+00:00","dateModified":"2022-11-01T16:28:18+00:00","description":"There are actually several ways to control disk latency in SQL Server. But in this article, I will be explaining the most frequently used DMV","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2022\/11\/01\/sql-server-disk-latency\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2022\/11\/01\/sql-server-disk-latency\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2022\/11\/01\/sql-server-disk-latency\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2022\/11\/Ekran-goruntusu-2022-11-01-192744.png","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2022\/11\/Ekran-goruntusu-2022-11-01-192744.png","width":681,"height":308},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2022\/11\/01\/sql-server-disk-latency\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"SQL Server Disk Latency"}]},{"@type":"WebSite","@id":"https:\/\/dbtut.com\/#website","url":"https:\/\/dbtut.com\/","name":"Database Tutorials","description":"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux","publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dbtut.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/dbtut.com\/#organization","name":"dbtut","url":"https:\/\/dbtut.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","width":223,"height":36,"caption":"dbtut"},"image":{"@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/dbtut.com\/#\/schema\/person\/92baa6fd666fb707d903177fed07d6ab","name":"\u00c7a\u011flar \u00d6zen\u00e7","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/997658bc236de4f5a0f3f46e64535566e31ba96824c77c01165e863fc38fd1ba?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/997658bc236de4f5a0f3f46e64535566e31ba96824c77c01165e863fc38fd1ba?s=96&d=mm&r=g","caption":"\u00c7a\u011flar \u00d6zen\u00e7"},"url":"https:\/\/dbtut.com\/index.php\/author\/caglarozenc\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/52891","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/users\/1414"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/comments?post=52891"}],"version-history":[{"count":2,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/52891\/revisions"}],"predecessor-version":[{"id":52897,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/52891\/revisions\/52897"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media\/52898"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=52891"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=52891"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=52891"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}