{"id":2096,"date":"2012-05-04T06:33:25","date_gmt":"2012-05-04T06:33:25","guid":{"rendered":"http:\/\/enjoyasp.net\/?p=2096"},"modified":"2012-05-07T03:50:20","modified_gmt":"2012-05-07T03:50:20","slug":"relog%e5%90%88%e5%b9%b6%e5%a4%9a%e4%b8%aablg%e6%96%87%e4%bb%b6","status":"publish","type":"post","link":"https:\/\/enjoyasp.net\/index.php\/2012\/05\/04\/relog%e5%90%88%e5%b9%b6%e5%a4%9a%e4%b8%aablg%e6%96%87%e4%bb%b6\/","title":{"rendered":"relog\u5408\u5e76\u591a\u4e2ablg\u6587\u4ef6"},"content":{"rendered":"

\u7528relog\u5408\u5e76perfmon\u751f\u6210\u7684\u591a\u4e2ablg\u6587\u4ef6\u65f6\uff0c\u82e5\u76f4\u63a5relog 1.blg,relog 2.blg -f bin -o result.blg\uff0c\u5f53blg\u6587\u4ef6\u6bd4\u8f83\u591a\u65f6\uff0c\u6709\u4e00\u4e2a\u65e0\u6cd5\u7406\u89e3\u7684\u73b0\u8c61\u4ea7\u751f\uff0c\u751f\u6210\u7684\u6587\u4ef6\u53ea\u662f\u6293\u53d6\u6700\u8fd165\u5206\u949f\u5185\u7684\u6570\u636e\uff0c\u5176\u4ed6\u6570\u636e\u4e22\u5931[\u7ecf\u4e86\u89e3,\u8fd9\u662f\u56e0relog\u5408\u5e76\u591a\u4e2a\u6587\u4ef6\uff0c\u6700\u5927\u6570\u91cf\u4e3a32\u9020\u6210]\uff0c\u4e3a\u907f\u514d\u8fd9\u79cd\u60c5\u51b5\uff0c\u73b0\u5c06blg\u4e24\u4e2a\u4e24\u4e2a\u5408\u6210\uff0c\u4e0d\u4e00\u6b21\u5408\u6210\u591a\u4e2a\uff0cpowershell\u811a\u672c\u5982\u4e0b\uff1a<\/p>\n

\r\n$logPath = "E:\\\u6559\u7a0b\\\u6280\u672f\u8d44\u6599\\\u8bd5\u9a8c\u5382\\powershell\\perfmon\\211\\SqlDiag"\r\n$SavePath = "E:\\\u6559\u7a0b\\\u6280\u672f\u8d44\u6599\\\u8bd5\u9a8c\u5382\\powershell\\perfmon\\211\\"\r\n\r\n$RunTime = ((Get-Date).ToString("MMddhhmmss"))\r\n$Prefix = "Temp_"\r\n$tmpFileNameBase = $SavePath + $Prefix + ((Get-Date).ToString("MMddhhmmss"))\r\n$FileNameBase = $SavePath + ((Get-Date).ToString("MMddhhmmss"))\r\n\r\n$fileList = Get-ChildItem  $logPath -recurse *.BLG | %{$_.FullName}\r\n$relog = "relog " + $fileList[0]  + " -f bin -o  " + $tmpFileNameBase +"[0]"  + ".blg"\r\nInvoke-Expression $relog \r\n\r\nfor( $i = 1; $i –lt $fileList.Length; $i++  ){\r\n\t$FileName = $tmpFileNameBase +"["+($i-1)+"]"  + ".blg" + "  " + $fileList[$i]\r\n\t$relog = "relog " + $FileName  + " -f bin -o  " + $tmpFileNameBase +"["+($i)+"]"  + ".blg"\r\n\t$relog\r\n\tInvoke-Expression $relog \r\n}\r\n$relog = "relog " + $tmpFileNameBase +"["+($i-1)+"]" + ".blg"  + " -y -f bin -o " + $FileNameBase+ ".blg"\r\nInvoke-Expression $relog\r\n$relog = "relog " + $FileNameBase + ".blg"  + " -y -f csv -o " + $FileNameBase+ ".csv"\r\nInvoke-Expression $relog\r\n\r\n#\u5220\u9664\u4e34\u65f6\u6587\u4ef6\r\n$del = " Remove-Item " + $SavePath + $Prefix + "*.blg"\r\nInvoke-Expression $del\r\n\r\n\r\n<\/pre>\n
relog \/?:
\n\u67e5\u770b\u8bb0\u6570\u5668 relog sqldiag.blg -q -o counter.txt<\/p>\n","protected":false},"excerpt":{"rendered":"
\u7528relog\u5408\u5e76perfmon\u751f\u6210\u7684\u591a\u4e2ablg\u6587\u4ef6\u65f6\uff0c\u82e5\u76f4\u63a5relog 1.blg,relog 2.blg – […]<\/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-2096","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\/2096","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=2096"}],"version-history":[{"count":0,"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/posts\/2096\/revisions"}],"wp:attachment":[{"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/media?parent=2096"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/categories?post=2096"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/tags?post=2096"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}