{"id":115,"date":"2015-07-10T17:04:19","date_gmt":"2015-07-10T09:04:19","guid":{"rendered":"https:\/\/blog.freesilo.com\/?p=115"},"modified":"2015-07-10T17:04:19","modified_gmt":"2015-07-10T09:04:19","slug":"%e6%b5%8b%e8%af%95sql%e8%af%ad%e5%8f%a5%e6%80%a7%e8%83%bd","status":"publish","type":"post","link":"https:\/\/freesilo.com\/?p=115","title":{"rendered":"\u6d4b\u8bd5sql\u8bed\u53e5\u6027\u80fd"},"content":{"rendered":"<p>\u6709\u65f6\u5019\u6211\u4eec\u7ecf\u5e38\u4e3a\u6211\u4eec\u7684sql\u8bed\u53e5\u6267\u884c\u6548\u7387\u4f4e\u4e0b\u53d1\u6101\uff0c\u53cd\u590d\u4f18\u5316\u540e\uff0c\u53ef\u8fd8\u662f\u5f97\u4e0d\u5230\u63d0\u9ad8\u90a3\u4e48\u4f60\u5c31\u7528\u8fd9\u6761\u8bed\u53e5\u627e\u51fa\u4f60sql\u5230\u5e95\u662f\u5728\u54ea\u91cc\u6162\u4e86<\/p>\n<p>\u793a\u4f8b\uff1a<\/p>\n<pre class=\"toolbar:2 lang:tsql decode:true \">SET STATISTICS io ON\nSET STATISTICS time ON\ngo\n    ---\u4f60\u8981\u6d4b\u8bd5\u7684sql\u8bed\u53e5\ngo\nSET STATISTICS profile OFF\nSET STATISTICS io OFF\nSET STATISTICS time OFF<\/pre>\n<p>\u663e\u793a\u4fe1\u606f\uff1a<\/p>\n<p>SQL Server\u00a0\u5206\u6790\u548c\u7f16\u8bd1\u65f6\u95f4:<\/p>\n<p>CPU\u00a0\u65f6\u95f4\u00a0= 0\u00a0\u6beb\u79d2\uff0c\u5360\u7528\u65f6\u95f4\u00a0= 59\u00a0\u6beb\u79d2\u3002<\/p>\n<p>(100\u00a0\u884c\u53d7\u5f71\u54cd)\u00a0\u8868\u00a0&#8216;TBL_Cot_RecStaticList&#8217;\u3002\u626b\u63cf\u8ba1\u6570\u00a01\uff0c\u903b\u8f91\u8bfb\u53d6\u00a014\u00a0\u6b21\uff0c\u7269\u7406\u8bfb\u53d6\u00a02\u00a0\u6b21\uff0c\u9884\u8bfb\u00a0992\u00a0\u6b21\uff0clob\u00a0\u903b\u8f91\u8bfb\u53d6\u00a00\u00a0\u6b21\uff0clob\u00a0\u7269\u7406\u8bfb\u53d6\u00a00\u00a0\u6b21\uff0clob\u00a0\u9884\u8bfb\u00a00\u00a0\u6b21\u3002<\/p>\n<p>SQL Server\u00a0\u6267\u884c\u65f6\u95f4: CPU\u00a0\u65f6\u95f4\u00a0= 0\u00a0\u6beb\u79d2\uff0c\u5360\u7528\u65f6\u95f4\u00a0= 306\u00a0\u6beb\u79d2\u3002<\/p>\n<p>SQL Server\u00a0\u5206\u6790\u548c\u7f16\u8bd1\u65f6\u95f4: CPU\u00a0\u65f6\u95f4\u00a0= 0\u00a0\u6beb\u79d2\uff0c\u5360\u7528\u65f6\u95f4\u00a0= 1\u00a0\u6beb\u79d2\u3002<\/p>\n<p>SQL Server\u00a0\u6267\u884c\u65f6\u95f4: CPU\u00a0\u65f6\u95f4\u00a0= 0\u00a0\u6beb\u79d2\uff0c\u5360\u7528\u65f6\u95f4\u00a0= 1\u00a0\u6beb\u79d2\u3002<\/p>\n<p>SQL Server\u00a0\u6267\u884c\u65f6\u95f4: CPU\u00a0\u65f6\u95f4\u00a0= 0\u00a0\u6beb\u79d2\uff0c\u5360\u7528\u65f6\u95f4\u00a0= 1\u00a0\u6beb\u79d2\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u6709\u65f6\u5019\u6211\u4eec\u7ecf\u5e38\u4e3a\u6211\u4eec\u7684sql\u8bed\u53e5\u6267\u884c\u6548\u7387\u4f4e\u4e0b\u53d1\u6101\uff0c\u53cd\u590d\u4f18\u5316\u540e\uff0c\u53ef\u8fd8\u662f\u5f97\u4e0d\u5230\u63d0\u9ad8\u90a3&#8230;<br \/><a class=\"read-more-button\" href=\"https:\/\/freesilo.com\/?p=115\">Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7],"tags":[],"class_list":["post-115","post","type-post","status-publish","format-standard","hentry","category-sql"],"_links":{"self":[{"href":"https:\/\/freesilo.com\/index.php?rest_route=\/wp\/v2\/posts\/115","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/freesilo.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/freesilo.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/freesilo.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/freesilo.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=115"}],"version-history":[{"count":0,"href":"https:\/\/freesilo.com\/index.php?rest_route=\/wp\/v2\/posts\/115\/revisions"}],"wp:attachment":[{"href":"https:\/\/freesilo.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=115"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/freesilo.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=115"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/freesilo.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=115"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}