{"id":2111,"date":"2012-05-09T00:15:14","date_gmt":"2012-05-09T00:15:14","guid":{"rendered":"http:\/\/enjoyasp.net\/?p=2111"},"modified":"2012-05-18T09:08:17","modified_gmt":"2012-05-18T09:08:17","slug":"sql%e5%9f%ba%e7%ba%bf%e5%bb%ba%e7%ab%8b-%e6%ad%a5%e9%aa%a4","status":"publish","type":"post","link":"https:\/\/enjoyasp.net\/index.php\/2012\/05\/09\/sql%e5%9f%ba%e7%ba%bf%e5%bb%ba%e7%ab%8b-%e6%ad%a5%e9%aa%a4\/","title":{"rendered":"sql\u57fa\u7ebf\u5efa\u7acb-\u6b65\u9aa4"},"content":{"rendered":"<p>1\uff0c\u5728\u76ee\u6807\u673a\u4e0a\u6536\u96c6\u6027\u80fd\u6307\u6807\uff1a<br \/>\n&nbsp;&nbsp; \u8fd0\u884c\uff1a<br \/>\n&nbsp;&nbsp;&nbsp; <a href=\"http:\/\/www.enjoyasp.net\/enjoytools\/Perf\/sqldiag.zip\">\u914d\u7f6e\u6587\u4ef6<\/a><br \/>\n&nbsp;&nbsp;&nbsp; \u6267\u884c\u4ee5\u4e0b\u547d\u4ee4\uff1a<br \/>\n&nbsp;&nbsp;&nbsp; \u4ee5\u670d\u52a1\u8fd0\u884c<br \/>\n&nbsp;&nbsp;&nbsp; \u65e9\u4e0a8\u70b9\u5230\u665a18\u70b9\u3002<br \/>\n&nbsp;&nbsp;&nbsp; SQLDIAG -P&quot;C:\\sqldiag&quot; -B 08:00:00 -E 18:30:00 -N2 -R<br \/>\n&nbsp;&nbsp;&nbsp;&nbsp; net start sqldiag<\/p>\n<p>&nbsp;&nbsp;&nbsp;&nbsp; \u5378\u8f7d\uff1a<br \/>\n&nbsp;&nbsp;&nbsp;&nbsp; net stop sqldiag<br \/>\n&nbsp;&nbsp;&nbsp;&nbsp; sqldiag -u<br \/>\n2\uff0c\u5c06\u6700\u540e\u751f\u6210\u7684sqldiag.blg\u6587\u4ef6\u7528PAL\u5de5\u5177\u8f6c\u5316\uff0c\u751f\u6210\u5206\u6790\u7ed3\u679c\uff0c\u89c2\u5bdf\u6b64\u7ed3\u679c\uff0c\u5e76\u91cd\u70b9\u89e3\u51b3\u95ee\u9898\u5904\u3002<br \/>\n&nbsp;&nbsp;&nbsp; \u5c06sqldiag.blg\u901a\u8fc7 relog sqldiag.blg -f csv -o sqldiag.csv \u8f6c\u6210csv,\u5bfc\u5165\u5230sqlserver\u4e2d\uff0c\u4ee5\u505a\u6570\u636e\u5206\u6790\uff0c\u5982\u5e73\u5747\u6570\u7b49\u3002<br \/>\n3,\u6253\u5f00\u6536\u96c6\u7684sqlserver trc\u6587\u4ef6\uff0c\u6587\u4ef6-\u5bfc\u5165\u6027\u80fd\u6570\u636e\uff0c\u9009\u62e9\u751f\u6210\u7684blg\u6027\u80fd\u8ba1\u6570\u5668\u6587\u4ef6\uff0c\u8fd9\u6837\u5c31\u53ef\u5bf9\u6bd4\u6027\u80fd\u8ba1\u6570\u5668\u4e0e\u5177\u4f53\u7684sql\u6765\u67e5\u770b\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>1\uff0c\u5728\u76ee\u6807\u673a\u4e0a\u6536\u96c6\u6027\u80fd\u6307\u6807\uff1a &nbsp;&nbsp; \u8fd0\u884c\uff1a &nbsp;&nbsp;&nbsp; \u914d\u7f6e\u6587\u4ef6 [&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-2111","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\/2111","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=2111"}],"version-history":[{"count":0,"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/posts\/2111\/revisions"}],"wp:attachment":[{"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/media?parent=2111"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/categories?post=2111"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/tags?post=2111"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}