{"id":2039,"date":"2022-08-12T13:53:23","date_gmt":"2022-08-12T04:53:23","guid":{"rendered":"https:\/\/www.mise.sss.fukushima-u.ac.jp\/?p=2039"},"modified":"2022-08-12T13:53:23","modified_gmt":"2022-08-12T04:53:23","slug":"nvme-%e3%82%b9%e3%83%88%e3%83%ac%e3%83%bc%e3%82%b8-m-2-%e3%81%ae-ssd%e3%81%b8%e3%81%aesql-server%e3%82%a4%e3%83%b3%e3%82%b9%e3%83%88%e3%83%bc%e3%83%ab%e3%82%a8%e3%83%a9%e3%83%bc%e3%81%a8%e8%a7%a3","status":"publish","type":"post","link":"https:\/\/www.mise.sss.fukushima-u.ac.jp\/?p=2039","title":{"rendered":"NVMe \u30b9\u30c8\u30ec\u30fc\u30b8 (M.2 \u306e SSD)\u3078\u306eSQL Server\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u30a8\u30e9\u30fc\u3068\u89e3\u6c7a\u7b56"},"content":{"rendered":"\n<p>\u6700\u8fd1\uff0cNVMe \u30b9\u30c8\u30ec\u30fc\u30b8 (M.2 \u306e SSD)\u306bSQL Server\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u3088\u3046\u3068\u3059\u308b\u969b\uff0c\u6b21\u306e\u30a8\u30e9\u30fc\u304c\u767a\u751f\u3057\u307e\u3057\u305f\uff1a<br>\u300cSQL Server \u30c7\u30fc\u30bf\u30d9\u30fc\u30b9 \u30a8\u30f3\u30b8\u30f3 \u30b5\u30fc\u30d3\u30b9 \u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u6a5f\u80fd \u306e\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb \u30a8\u30e9\u30fc<br>\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9 \u30a8\u30f3\u30b8\u30f3\u306e\u5fa9\u65e7\u30cf\u30f3\u30c9\u30eb\u306e\u5f85\u6a5f\u306b\u5931\u6557\u3057\u307e\u3057\u305f\u3002\u8003\u3048\u3089\u308c\u308b\u539f\u56e0\u306b\u3064\u3044\u3066\u306f\u3001SQL Server \u30a8\u30e9\u30fc \u30ed\u30b0\u3092\u53c2\u7167\u3057\u3066\u304f\u3060\u3055\u3044\u3002\u300d<br>SQL Server \u30a8\u30e9\u30fc \u30ed\u30b0\u3092\u8aad\u3093\u3067\u3082\u89e3\u6c7a\u7b56\u306f\u3088\u304f\u308f\u304b\u308a\u307e\u305b\u3093\u3067\u3057\u305f\u3002<\/p>\n\n\n\n<p>\u30a4\u30f3\u30bf\u30fc\u30cd\u30c3\u30c8\u3067\u3044\u308d\u3044\u308d\u3068\u8abf\u3079\u305f\u3068\u3053\u308d\uff0c\u3053\u306e\u30a8\u30e9\u30fc\u306f\u30b7\u30b9\u30c6\u30e0\u30c7\u30a3\u30b9\u306e\u30af\u30bb\u30af\u30bf\u30fc\u30b5\u30a4\u30ba\u304c\u5927\u304d\u3059\u304e\u3066\uff0cSQL Server\u304c\u5bfe\u5fdc\u3057\u3066\u3044\u306a\u3044\u3053\u3068\u304c\u308f\u304b\u308a\u307e\u3057\u305f\u3002\u8a73\u7d30\u306f\u6b21\u306e\u30da\u30fc\u30b8\u3092\u63b2\u8f09\u3057\u3066\u3044\u307e\u3059\uff1a<br><a rel=\"noreferrer noopener\" href=\"https:\/\/docs.microsoft.com\/ja-jp\/troubleshoot\/sql\/admin\/troubleshoot-os-4kb-disk-sector-size\" target=\"_blank\">4 KB \u3092\u8d85\u3048\u308b\u30b7\u30b9\u30c6\u30e0 \u30c7\u30a3\u30b9\u30af \u30bb\u30af\u30bf\u30fc \u30b5\u30a4\u30ba\u306b\u95a2\u9023\u3059\u308b\u30a8\u30e9\u30fc\u306e\u30c8\u30e9\u30d6\u30eb\u30b7\u30e5\u30fc\u30c6\u30a3\u30f3\u30b0<\/a><\/p>\n\n\n\n<p>Windows 11 \/ Windows Server 2022\u3092NVMe\u306b\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3059\u308b\u3068\uff0c\u30b7\u30b9\u30c6\u30e0\u30c7\u30a3\u30b9\u30af\u306e\u30bb\u30af\u30bf\u30fc\u30b5\u30a4\u30ba\u3092\u81ea\u52d5\u7684\u306b\u300c32768\u300d(32KB)\u306b\u8a2d\u5b9a\u3059\u308b\u306e\u306b\u5bfe\u3057\u3066\uff0cSQL Server 2016\uff5e2019\u306f512 \u30d0\u30a4\u30c8\u30684KB\u306e\u30bb\u30af\u30bf\u30fc\u30b5\u30a4\u30ba\u3060\u3051\u3092\u30b5\u30dd\u30fc\u30c8\u3057\u3066\u3044\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u89e3\u6c7a\u7b56\u306f\uff0c\u4e0a\u8a18\u306e\u30de\u30a4\u30af\u30ed\u30bd\u30d5\u30c8\u306eHP\u3092\u53c2\u8003\u306b\u3057\u3066\uff0c\u30b7\u30b9\u30c6\u30e0\u30c7\u30a3\u30b9\u30af\u306e\u30bb\u30af\u30bf\u30fc\u30b5\u30a4\u30ba\u30924KB\u306b\u5909\u66f4\u3059\u308b\u3053\u3068\u3067\u3059\u3002Windows11\u3067\u306f\u300cWindows\u30bf\u30fc\u30df\u30ca\u30eb\uff08\u7ba1\u7406\u8005\uff09\u300d\u3092\u30af\u30ea\u30c3\u30af\u3057\u3066\uff0c\u7ba1\u7406\u8005\u3068\u3057\u3066\u30b3\u30de\u30f3\u30c9 \u30d7\u30ed\u30f3\u30d7\u30c8\u3092\u958b\u3044\u3066\u304b\u3089\uff0c\u6b21\u306e\u30b3\u30de\u30f3\u30c9\u3092\u5b9f\u884c\u3057\u3066\u304f\u3060\u3055\u3044\uff1a<br>REG ADD &#8220;HKLM\\SYSTEM\\CurrentControlSet\\Services\\stornvme\\Parameters\\Device&#8221; \/v &#8220;ForcedPhysicalSectorSizeInBytes&#8221; \/t REG_MULTI_SZ \/d &#8220;* 4095&#8221; \/f<\/p>\n\n\n\n<p>\u306a\u304a\uff0c\u30b9\u30c8\u30ec\u30fc\u30b8\u306e\u30bb\u30af\u30bf\u30fc\u30b5\u30a4\u30ba\u306f\u6b21\u306e\u30b3\u30de\u30f3\u30c9\u3067\u78ba\u8a8d\u3067\u304d\u307e\u3059\uff1a<br>fsutil fsinfo sectorinfo &lt;volume pathname><br>\u4f8b\u3048\u3070\uff0cC\u30c7\u30a3\u30b9\u30af\u306e\u30bb\u30af\u30bf\u30fc\u30b5\u30a4\u30ba\u3092\u78ba\u8a8d\u3057\u305f\u3044\u3068\u304d\uff0c\u300cfsutil fsinfo sectorinfo C:\u300d\u3068\u3044\u3046\u30b3\u30de\u30f3\u30c9\u3092\u5b9f\u884c\u3057\u3066\uff0c<code>PhysicalBytesPerSectorForAtomicity<\/code>\u306e\u5024\u306f\u30d0\u30a4\u30c8\u5358\u4f4d\u3067\u793a\u3055\u308c\u308b\u30bb\u30af\u30bf\u30fc\u30b5\u30a4\u30ba\u3067\u3059\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u6700\u8fd1\uff0cNVMe \u30b9\u30c8\u30ec\u30fc\u30b8 (M.2 \u306e &hellip; <\/p>\n","protected":false},"author":1,"featured_media":865,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_locale":"ja","_original_post":"https:\/\/www.mise.sss.fukushima-u.ac.jp\/?p=2039","footnotes":""},"categories":[7],"tags":[],"class_list":["post-2039","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-7","ja"],"_links":{"self":[{"href":"https:\/\/www.mise.sss.fukushima-u.ac.jp\/index.php?rest_route=\/wp\/v2\/posts\/2039","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.mise.sss.fukushima-u.ac.jp\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.mise.sss.fukushima-u.ac.jp\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.mise.sss.fukushima-u.ac.jp\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.mise.sss.fukushima-u.ac.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2039"}],"version-history":[{"count":1,"href":"https:\/\/www.mise.sss.fukushima-u.ac.jp\/index.php?rest_route=\/wp\/v2\/posts\/2039\/revisions"}],"predecessor-version":[{"id":2040,"href":"https:\/\/www.mise.sss.fukushima-u.ac.jp\/index.php?rest_route=\/wp\/v2\/posts\/2039\/revisions\/2040"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.mise.sss.fukushima-u.ac.jp\/index.php?rest_route=\/wp\/v2\/media\/865"}],"wp:attachment":[{"href":"https:\/\/www.mise.sss.fukushima-u.ac.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2039"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.mise.sss.fukushima-u.ac.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2039"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.mise.sss.fukushima-u.ac.jp\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2039"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}