{"id":2834,"date":"2026-08-15T10:45:12","date_gmt":"2026-08-15T02:45:12","guid":{"rendered":"https:\/\/www.jh1999.cn\/?p=2834"},"modified":"2026-08-15T11:45:42","modified_gmt":"2026-08-15T03:45:42","slug":"sql-server%e4%b8%ba-tempdb-%e9%85%8d-8-%e4%b8%aa%e6%95%b0%e6%8d%ae%e6%96%87%e4%bb%b6","status":"publish","type":"post","link":"http:\/\/www.jh1999.cn\/?p=2834","title":{"rendered":"\u4e3a tempdb \u914d 8 \u4e2a\u6570\u636e\u6587\u4ef6"},"content":{"rendered":"
\n\n

\u5728 SQL Server \u4e2d\uff0c\u5f53\u521b\u5efa\u4e34\u65f6\u8868\u3001\u8fdb\u884c\u6392\u5e8f\u3001\u54c8\u5e0c\u8fde\u63a5\u7b49\u64cd\u4f5c\u65f6\uff0c\u9700\u8981\u5728\u00a0tempdb<\/code>\u00a0\u4e2d\u5feb\u901f\u5206\u914d\u7a7a\u95f4\uff0c\u8fd9\u4e2a\u5206\u914d\u8fc7\u7a0b\u7531\u51e0\u79cd\u7279\u6b8a\u7684\u7cfb\u7edf\u9875\u9762\u8fdb\u884c\u7ba1\u7406\uff1a<\/p>\n\n\n\n

PFS (Page Free Space)<\/strong>: \u8ddf\u8e2a\u6bcf\u4e00\u9875\u7684\u4f7f\u7528\u60c5\u51b5\u3002<\/p>\n\n\n\n

GAM (Global Allocation Map)<\/strong>: \u8ddf\u8e2a\u54ea\u4e9b\u533a\uff08Extent\uff09\u662f\u53ef\u7528\u7684\u3002<\/p>\n\n\n\n

SGAM (Shared Global Allocation Map)<\/strong>: \u8ddf\u8e2a\u54ea\u4e9b\u533a\u662f\u6df7\u5408\u4f7f\u7528\u7684\u3002<\/p>\n\n\n\n

\u5f53\u53ea\u6709\u4e00\u4e2a tempdb<\/code> \u6570\u636e\u6587\u4ef6\u65f6\uff0c\u6240\u6709\u4f1a\u8bdd\u7684\u5206\u914d\u8bf7\u6c42\u90fd\u4f1a\u96c6\u4e2d\u5728\u8fd9\u4e00\u4e2a\u6587\u4ef6\u7684 PFS\/GAM\/SGAM \u9875\u4e0a\uff0c\u5f62\u6210\u4e25\u91cd\u7684 \u95e9\u9501 (Latch) \u4e89\u7528<\/strong>\uff0c\u6210\u4e3a\u6027\u80fd\u74f6\u9888\u3002<\/p>\n\n\n\n

\u6dfb\u52a0\u591a\u4e2a tempdb \u6570\u636e\u6587\u4ef6\u540e\uff0cSQL Server \u5bf9 tempdb \u591a\u4e2a\u6570\u636e\u6587\u4ef6\u91c7\u7528 \u8f2a\u8a62\uff08Round-Robin\uff09<\/strong>\u5206\u914d\u7b97\u6cd5\uff0c<\/strong>\u6240\u6709 8 \u4e2a\u6587\u4ef6\u4ece\u4e00\u5f00\u59cb\u5c31\u4f1a\u540c\u65f6\u88ab\u5199\u5165\uff0c\u4ece\u800c\u6781\u5927\u5730\u7f13\u89e3\u4e86\u4e89\u7528\uff0c\u63d0\u5347\u4e86\u5e76\u53d1\u5904\u7406\u80fd\u529b\u3002<\/p>\n\n\n\n

\u4e0b\u9762\u662f\u9488\u5bf9\u4e00\u53f08\u6838CPU\u7684\u670d\u52a1\u5668\uff0c\u7ed9 tempdb \u914d\u7f6e 8 \u4e2a\u6570\u636e\u6587\u4ef6\u7684\u5b8c\u6574\u4ee3\u7801\uff1a<\/p>\n\n\n\n

-- =====================================================\n-- \u6b65\u9a5f\u4e00\uff1a\u8abf\u6574\u9ed8\u8a8d\u6578\u64da\u6587\u4ef6 tempdev\n-- \u7576\u524d 1421MB\uff0c\u8abf\u6574\u70ba 1536MB\uff0c\u589e\u9577\u91cf\u5f9e 512MB \u6539\u70ba 128MB\n-- =====================================================\nUSE master\nGO\n\nALTER DATABASE tempdb \nMODIFY FILE \n(\n    NAME = tempdev,\n    SIZE = 1536MB,\n    FILEGROWTH = 128MB\n)\nGO\n\n-- =====================================================\n-- \u6b65\u9a5f\u4e8c\uff1a\u6dfb\u52a0 7 \u500b\u984d\u5916\u6578\u64da\u6587\u4ef6\u5230 F \u76e4\n-- \u6bcf\u500b\u6587\u4ef6 1536MB\uff0c\u589e\u9577\u91cf 128MB\uff0c\u8207 tempdev \u5b8c\u5168\u4e00\u81f4\n-- =====================================================\n\n-- \u6dfb\u52a0\u7b2c 2 \u500b\u6578\u64da\u6587\u4ef6\nALTER DATABASE tempdb \nADD FILE \n(\n    NAME = tempdev2,\n    FILENAME = 'F:\\SQLlog\\tempdb2.ndf',\n    SIZE = 1536MB,\n    FILEGROWTH = 128MB\n)\nGO\n\n-- \u6dfb\u52a0\u7b2c 3 \u500b\u6578\u64da\u6587\u4ef6\nALTER DATABASE tempdb \nADD FILE \n(\n    NAME = tempdev3,\n    FILENAME = 'F:\\SQLlog\\tempdb3.ndf',\n    SIZE = 1536MB,\n    FILEGROWTH = 128MB\n)\nGO\n\n-- \u6dfb\u52a0\u7b2c 4 \u500b\u6578\u64da\u6587\u4ef6\nALTER DATABASE tempdb \nADD FILE \n(\n    NAME = tempdev4,\n    FILENAME = 'F:\\SQLlog\\tempdb4.ndf',\n    SIZE = 1536MB,\n    FILEGROWTH = 128MB\n)\nGO\n\n-- \u6dfb\u52a0\u7b2c 5 \u500b\u6578\u64da\u6587\u4ef6\nALTER DATABASE tempdb \nADD FILE \n(\n    NAME = tempdev5,\n    FILENAME = 'F:\\SQLlog\\tempdb5.ndf',\n    SIZE = 1536MB,\n    FILEGROWTH = 128MB\n)\nGO\n\n-- \u6dfb\u52a0\u7b2c 6 \u500b\u6578\u64da\u6587\u4ef6\nALTER DATABASE tempdb \nADD FILE \n(\n    NAME = tempdev6,\n    FILENAME = 'F:\\SQLlog\\tempdb6.ndf',\n    SIZE = 1536MB,\n    FILEGROWTH = 128MB\n)\nGO\n\n-- \u6dfb\u52a0\u7b2c 7 \u500b\u6578\u64da\u6587\u4ef6\nALTER DATABASE tempdb \nADD FILE \n(\n    NAME = tempdev7,\n    FILENAME = 'F:\\SQLlog\\tempdb7.ndf',\n    SIZE = 1536MB,\n    FILEGROWTH = 128MB\n)\nGO\n\n-- \u6dfb\u52a0\u7b2c 8 \u500b\u6578\u64da\u6587\u4ef6\nALTER DATABASE tempdb \nADD FILE \n(\n    NAME = tempdev8,\n    FILENAME = 'F:\\SQLlog\\tempdb8.ndf',\n    SIZE = 1536MB,\n    FILEGROWTH = 128MB\n)\nGO\n\n-- =====================================================\n-- \u6b65\u9a5f\u4e09\uff1a\u8abf\u6574\u65e5\u8a8c\u6587\u4ef6 templog\n-- \u7576\u524d 179MB \u904e\u5c0f\uff0c\u8abf\u6574\u70ba 512MB\uff0c\u589e\u9577\u91cf\u6539\u70ba 128MB\n-- =====================================================\nALTER DATABASE tempdb \nMODIFY FILE \n(\n    NAME = templog,\n    SIZE = 512MB,\n    FILEGROWTH = 128MB\n)\nGO<\/code><\/pre>\n\n\n\n
\u6dfb\u52a0 ndf \u6587\u4ef6\u65f6\uff0c\u786c\u76d8\u4f1a\u7d27\u5f20\uff0cERP\u7b49\u5e94\u7528\u7cfb\u7edf\u4f1a\u6709\u5361\u987f\uff0c\u7b2c\u4e09\u6b65\u6267\u884c\u5b8c\u540e\uff0c\u8981\u91cd\u542fSQL SERVER\uff0c\u5426\u5219\u65b0\u52a0\u7684 ndf \u6587\u4ef6\u4e0d\u4f1a\u751f\u6548\u3002<\/p>\n\n\n\n
\"\"<\/figure>\n\n<\/div>","protected":false},"excerpt":{"rendered":"
\u5728 SQL Server \u4e2d\uff0c\u5f53\u521b\u5efa\u4e34\u65f6\u8868\u3001\u8fdb\u884c\u6392\u5e8f\u3001\u54c8\u5e0c\u8fde\u63a5\u7b49\u64cd\u4f5c\u65f6\uff0c\u9700\u8981\u5728\u00a0tempdb\u00a0\u4e2d\u5feb\u901f\u5206\u914d\u7a7a\u95f4\uff0c … \u9605\u8bfb\u66f4\u591a<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5],"tags":[],"class_list":["post-2834","post","type-post","status-publish","format-standard","hentry","category-kfbj"],"_links":{"self":[{"href":"http:\/\/www.jh1999.cn\/index.php?rest_route=\/wp\/v2\/posts\/2834","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.jh1999.cn\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.jh1999.cn\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.jh1999.cn\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.jh1999.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2834"}],"version-history":[{"count":11,"href":"http:\/\/www.jh1999.cn\/index.php?rest_route=\/wp\/v2\/posts\/2834\/revisions"}],"predecessor-version":[{"id":2853,"href":"http:\/\/www.jh1999.cn\/index.php?rest_route=\/wp\/v2\/posts\/2834\/revisions\/2853"}],"wp:attachment":[{"href":"http:\/\/www.jh1999.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2834"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.jh1999.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2834"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.jh1999.cn\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2834"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}