{"id":2155,"date":"2012-05-30T11:10:56","date_gmt":"2012-05-30T11:10:56","guid":{"rendered":"http:\/\/enjoyasp.net\/?p=2155"},"modified":"2012-05-30T11:17:28","modified_gmt":"2012-05-30T11:17:28","slug":"%e8%a1%a8%e7%a9%ba%e9%97%b4%e4%bc%98%e5%8c%96","status":"publish","type":"post","link":"https:\/\/enjoyasp.net\/index.php\/2012\/05\/30\/%e8%a1%a8%e7%a9%ba%e9%97%b4%e4%bc%98%e5%8c%96\/","title":{"rendered":"\u8868\u7a7a\u95f4\u4f18\u5316"},"content":{"rendered":"<p>\u8868\u7a7a\u95f4\u4f18\u5316\u539f\u56e0\uff1a\u8868\u884c\u6570\u636e\u8d8a\u5c11\uff0c\u4e00\u4e2a\u9875\u5b58\u50a8\u7684\u884c\u4e5f\u5c31\u8d8a\u591a\uff0cI\/O\u5c31\u4f1a\u51cf\u5c11\uff0c\u63d0\u9ad8\u4e86\u6027\u80fd\u3002<br \/>\n\u65b9\u6cd5\u6709\uff1a1\uff0c\u57fa\u8868\u7528int,\u81ea\u589e\uff0c\u8868\u4e2d\u591a\u7528int<br \/>\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2\uff0c\u5b58\u50a8\u5927\u7684\u6570\u636e\u653e\u5728\u53e6\u5916\u8868\u4e2d\u3002<\/p>\n<p>\u6548\u679c\u8bc4\u4f30\uff1a\u67e5\u770b\u4f18\u5316\u524d\u4e0e\u540e\u6bcf\u9875\u5b58\u50a8\u7684\u5e73\u5747\u884c\u6570\uff0c\u8d8a\u5927\u8d8a\u597d\u3002<\/p>\n<pre class=\"brush:sql;first-line:1;pad-line-numbers:true;highlight:null;collapse:false;\">\r\nSELECT m.tablename \u8868\u540d,m.indexname \u7d22\u5f15\u540d,m.total_pages \u603b\u9875\u6570,m.ROWS \u603b\u884c\u6570,m.AvgPerPage \u6bcf\u9875\u5e73\u5747\u884c\u6570 ,\r\nCONVERT(VARCHAR(5),8060\/AvgPerPage) + &#39;\u5b57\u8282&#39;&nbsp;&nbsp; \u6bcf\u884c\u5e73\u5747\u5b57\u8282\u6570\r\nFROM (\r\n&nbsp;&nbsp; &nbsp;SELECT OBJECT_NAME(idx.OBJECT_ID) tablename,idx.NAME indexname,\r\n&nbsp;&nbsp; &nbsp;SUM(total_pages) total_pages,SUM(ptt.rows) ROWS,SUM(rows)\/SUM(total_pages) AvgPerPage\r\n&nbsp;&nbsp; &nbsp;FROM sys.indexes idx\r\n&nbsp;&nbsp; &nbsp;JOIN sys.partitions ptt ON idx.index_id = ptt.index_id AND idx.object_id = ptt.object_id\r\n&nbsp;&nbsp; &nbsp;JOIN sys.allocation_units au ON au.container_id = ptt.partition_id\r\n&nbsp;&nbsp; &nbsp;WHERE idx.object_id = object_id(&#39;bdorder&#39;)\r\n&nbsp;&nbsp; &nbsp;GROUP BY OBJECT_NAME(idx.OBJECT_ID),idx.name\r\n)m\r\n\r\n\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>\u8868\u7a7a\u95f4\u4f18\u5316\u539f\u56e0\uff1a\u8868\u884c\u6570\u636e\u8d8a\u5c11\uff0c\u4e00\u4e2a\u9875\u5b58\u50a8\u7684\u884c\u4e5f\u5c31\u8d8a\u591a\uff0cI\/O\u5c31\u4f1a\u51cf\u5c11\uff0c\u63d0\u9ad8\u4e86\u6027\u80fd\u3002 \u65b9\u6cd5\u6709\uff1a1\uff0c\u57fa\u8868\u7528int, [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[36],"tags":[],"class_list":["post-2155","post","type-post","status-publish","format-standard","hentry","category-sql-server"],"blocksy_meta":[],"_links":{"self":[{"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/posts\/2155","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/comments?post=2155"}],"version-history":[{"count":0,"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/posts\/2155\/revisions"}],"wp:attachment":[{"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/media?parent=2155"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/categories?post=2155"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/tags?post=2155"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}