{"id":2683,"date":"2019-05-08T14:57:45","date_gmt":"2019-05-08T06:57:45","guid":{"rendered":"http:\/\/jason695.why3s.tw\/wordpress\/?p=2683"},"modified":"2019-05-10T18:27:08","modified_gmt":"2019-05-10T10:27:08","slug":"sql%e5%95%8f%e9%a1%8c%e8%99%95%e7%90%86%e8%82%a5%e5%be%97%e8%a6%81%e6%ad%bb%e7%9a%84-tempdb-%e5%a6%82%e4%bd%95%e7%b8%ae%e6%b8%9b","status":"publish","type":"post","link":"https:\/\/jason695.why3s.tw\/wordpress\/2019\/05\/08\/sql%e5%95%8f%e9%a1%8c%e8%99%95%e7%90%86%e8%82%a5%e5%be%97%e8%a6%81%e6%ad%bb%e7%9a%84-tempdb-%e5%a6%82%e4%bd%95%e7%b8%ae%e6%b8%9b\/","title":{"rendered":"[SQL][\u554f\u984c\u8655\u7406]\u80a5\u5f97\u8981\u6b7b\u7684 tempdb \u5982\u4f55\u7e2e\u6e1b"},"content":{"rendered":"<p><a href=\"https:\/\/dotblogs.com.tw\/jamesfu\/2014\/05\/20\/shrinktempdb\">https:\/\/dotblogs.com.tw\/jamesfu\/2014\/05\/20\/shrinktempdb<\/a><\/p>\n<p>\u53ef\u4ee5\u53c3\u8003 Technet \u4e0a\u7684\u6587\u7ae0\uff0c\u4e00\u822c\u4f86\u8aaa\u7576\u4f60\u9023\u7dda\u7d50\u675f\u4e4b\u5f8c\uff0c\u6240\u4f54\u7528\u7684\u8cc7\u6e90\u61c9\u8a72\u6703\u88ab\u91cb\u653e\uff0c\u4f46\u76ee\u524d\u4ed6\u5011\u7684 tempdb \u6703\u9577\u5230\u90a3\u9ebc\u5927\u7684\u8a71\uff0c\u6211\u5011\u76f4\u63a5\u4f7f\u7528\u58d3\u7e2e\u6307\u4ee4\u53c8\u7121\u6cd5\u58d3\u7e2e\u7684\u72c0\u6cc1\u4e0b\uff0c\u56e0\u6b64\u5efa\u8b70\u670b\u53cb\u5148\u4f7f\u7528\u4ee5\u4e0b\u7684\u6307\u4ee4\u4f86\u8a66\u8a66\u770b\uff1a<\/p>\n<pre class=\"lang:tsql decode:true \">-- \u907f\u514d\u9084\u6709\u8cc7\u6599\u9084\u5728\u8a18\u61b6\u9ad4\u5167\uff0c\u624b\u52d5\u9032\u884c Checkpoint\nCheckpoint\nGO\n\n-- \u5f37\u5236\u91cb\u653e\u4f54\u7528\u7684\u8a18\u61b6\u9ad4\nDBCC FREESYSTEMCACHE ('ALL')\nDBCC FREEPROCCACHE\nDBCC DROPCLEANBUFFERS\nDBCC FREESESSIONCACHE\nGO<\/pre>\n<p>\u5b8c\u6210\u4e0a\u8ff0\u6307\u4ee4\u4e4b\u5f8c\uff0c\u518d\u91cd\u65b0\u9032\u884c\u4e00\u6b21\u58d3\u7e2e tempdb\uff0c\u679c\u7136\u5c31\u53ef\u4ee5\u9806\u5229\u628a tempdb \u7d66\u58d3\u7e2e\u4e86\u3002<code><\/code><\/p>\n<pre class=\"lang:tsql decode:true \">DBCC SHRINKDATABASE(N'tempdb')<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>https:\/\/dotblogs.com.tw\/jamesfu\/2014\/05\/20\/shrinktempdb &hellip; <a href=\"https:\/\/jason695.why3s.tw\/wordpress\/2019\/05\/08\/sql%e5%95%8f%e9%a1%8c%e8%99%95%e7%90%86%e8%82%a5%e5%be%97%e8%a6%81%e6%ad%bb%e7%9a%84-tempdb-%e5%a6%82%e4%bd%95%e7%b8%ae%e6%b8%9b\/\" class=\"more-link\">\u95b1\u8b80\u5168\u6587 <span class=\"screen-reader-text\">[SQL][\u554f\u984c\u8655\u7406]\u80a5\u5f97\u8981\u6b7b\u7684 tempdb \u5982\u4f55\u7e2e\u6e1b<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[47,5],"tags":[],"class_list":["post-2683","post","type-post","status-publish","format-standard","hentry","category-sql-server","category-5","no-featured-image"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/jason695.why3s.tw\/wordpress\/wp-json\/wp\/v2\/posts\/2683","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jason695.why3s.tw\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jason695.why3s.tw\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jason695.why3s.tw\/wordpress\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/jason695.why3s.tw\/wordpress\/wp-json\/wp\/v2\/comments?post=2683"}],"version-history":[{"count":0,"href":"https:\/\/jason695.why3s.tw\/wordpress\/wp-json\/wp\/v2\/posts\/2683\/revisions"}],"wp:attachment":[{"href":"https:\/\/jason695.why3s.tw\/wordpress\/wp-json\/wp\/v2\/media?parent=2683"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jason695.why3s.tw\/wordpress\/wp-json\/wp\/v2\/categories?post=2683"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jason695.why3s.tw\/wordpress\/wp-json\/wp\/v2\/tags?post=2683"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}