{"id":465,"date":"2025-07-09T08:20:53","date_gmt":"2025-07-08T23:20:53","guid":{"rendered":"https:\/\/sejiwon.com\/?p=465"},"modified":"2025-07-09T08:31:01","modified_gmt":"2025-07-08T23:31:01","slug":"mssql-%ec%97%90%ec%84%9c-%eb%94%94%ec%8a%a4%ed%81%aci-o-%ed%99%95%ec%9d%b8%ed%95%98%eb%8a%94-%ec%bf%bc%eb%a6%ac","status":"publish","type":"post","link":"https:\/\/sejiwon.com\/?p=465","title":{"rendered":"mssql \uc5d0\uc11c \ub514\uc2a4\ud06ci\/o \ud655\uc778\ud558\ub294 \ucffc\ub9ac"},"content":{"rendered":"\n<p>MSSQL\uc5d0\uc11c \ub514\uc2a4\ud06c I\/O \uc0ac\uc6a9\ub7c9\uc744 \ud655\uc778\ud558\ub824\uba74 <code>sys.dm_io_virtual_file_stats<\/code> \ubc0f <code>sys.master_files<\/code> \ubdf0\ub97c \ud65c\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc544\ub798\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ubcc4\ub85c \ud30c\uc77c I\/O \ud1b5\uacc4\ub97c \ubcf4\uc5ec\uc8fc\ub294 \ucffc\ub9ac\uc785\ub2c8\ub2e4:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\"><code>SELECT\n    DB_NAME(vfs.database_id) AS database_name,\n    mf.physical_name,\n    mf.type_desc,\n    vfs.num_of_reads,\n    vfs.num_of_writes,\n    vfs.io_stall_read_ms,\n    vfs.io_stall_write_ms,\n    vfs.size_on_disk_bytes \/ 1024 \/ 1024 AS size_on_disk_MB,\n    vfs.num_of_reads + vfs.num_of_writes AS total_io,\n    vfs.io_stall_read_ms + vfs.io_stall_write_ms AS total_io_stall_ms\nFROM sys.dm_io_virtual_file_stats(NULL, NULL) AS vfs\nJOIN sys.master_files AS mf\n    ON vfs.database_id = mf.database_id\n    AND vfs.file_id = mf.file_id\nORDER BY total_io_stall_ms DESC;\n<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">\uc8fc\uc694 \uceec\ub7fc \uc124\uba85:<\/h3>\n\n\n\n<ul>\n<li><code>database_name<\/code>: \ud574\ub2f9 \ud30c\uc77c\uc774 \uc18d\ud55c \ub370\uc774\ud130\ubca0\uc774\uc2a4<\/li>\n\n\n\n<li><code>physical_name<\/code>: \uc2e4\uc81c \ubb3c\ub9ac\uc801 \uacbd\ub85c<\/li>\n\n\n\n<li><code>type_desc<\/code>: \ub370\uc774\ud130 \ud30c\uc77c \ub610\ub294 \ub85c\uadf8 \ud30c\uc77c \uc5ec\ubd80<\/li>\n\n\n\n<li><code>num_of_reads<\/code>, <code>num_of_writes<\/code>: \uc77d\uae30\/\uc4f0\uae30 \ud69f\uc218<\/li>\n\n\n\n<li><code>io_stall_read_ms<\/code>, <code>io_stall_write_ms<\/code>: \uc77d\uae30\/\uc4f0\uae30 \ub300\uae30 \uc2dc\uac04(ms)<\/li>\n\n\n\n<li><code>size_on_disk_MB<\/code>: \ub514\uc2a4\ud06c \uc0c1 \ud30c\uc77c \ud06c\uae30<\/li>\n\n\n\n<li><code>total_io<\/code>: \ucd1d I\/O \ud69f\uc218<\/li>\n\n\n\n<li><code>total_io_stall_ms<\/code>: \ucd1d I\/O \ub300\uae30 \uc2dc\uac04(ms)<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">\ucc38\uace0:<\/h3>\n\n\n\n<ul>\n<li>\uc774 \ucffc\ub9ac\ub294 \ub204\uc801 \uac12\uc774\ubbc0\ub85c SQL Server \uc778\uc2a4\ud134\uc2a4\uac00 \uc2dc\uc791\ub41c \uc774\ud6c4\ubd80\ud130\uc758 \ub370\uc774\ud130\ub97c \ubcf4\uc5ec\uc90d\ub2c8\ub2e4.<\/li>\n\n\n\n<li>\uc815\ud655\ud55c \uc131\ub2a5 \ubd84\uc11d\uc744 \uc704\ud574 \uc8fc\uae30\uc801\uc73c\ub85c \ub370\uc774\ud130\ub97c \ucea1\ucc98\ud558\uace0 \ube44\uad50\ud558\ub294 \ubc29\uc2dd\uc774 \uc88b\uc2b5\ub2c8\ub2e4.<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>MSSQL\uc5d0\uc11c \ub514\uc2a4\ud06c I\/O \uc0ac\uc6a9\ub7c9\uc744 \ud655\uc778\ud558\ub824\uba74 sys.dm_io_virtual_file_stats \ubc0f sys.master_files \ubdf0\ub97c \ud65c\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc544\ub798\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ubcc4\ub85c \ud30c\uc77c I\/O \ud1b5\uacc4\ub97c \ubcf4\uc5ec\uc8fc\ub294 \ucffc\ub9ac\uc785\ub2c8\ub2e4: SELECT DB_NAME(vfs.database_id) AS database_name, mf.physical_name, mf.type_desc, vfs.num_of_reads, vfs.num_of_writes, vfs.io_stall_read_ms, vfs.io_stall_write_ms, vfs.size_on_disk_bytes \/ 1024 \/ 1024 AS size_on_disk_MB, vfs.num_of_reads + vfs.num_of_writes AS total_io, vfs.io_stall_read_ms + vfs.io_stall_write_ms AS total_io_stall_ms FROM sys.dm_io_virtual_file_stats(NULL, NULL) AS vfs JOIN sys.master_files AS mf\u2026 <span class=\"read-more\"><a href=\"https:\/\/sejiwon.com\/?p=465\">Read More &raquo;<\/a><\/span><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[11],"tags":[],"_links":{"self":[{"href":"https:\/\/sejiwon.com\/index.php?rest_route=\/wp\/v2\/posts\/465"}],"collection":[{"href":"https:\/\/sejiwon.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sejiwon.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sejiwon.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/sejiwon.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=465"}],"version-history":[{"count":2,"href":"https:\/\/sejiwon.com\/index.php?rest_route=\/wp\/v2\/posts\/465\/revisions"}],"predecessor-version":[{"id":477,"href":"https:\/\/sejiwon.com\/index.php?rest_route=\/wp\/v2\/posts\/465\/revisions\/477"}],"wp:attachment":[{"href":"https:\/\/sejiwon.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=465"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sejiwon.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=465"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sejiwon.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=465"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}