Perfmon 文件分析工具
我有一堆 perfmon 文件,它们捕获了一段时间内的信息。 处理这些信息的最佳工具是什么? 理想情况下,我希望能够查看已监控的对象计数器每小时的平均统计数据。
I have a bunch of perfmon files that have captured information over a period of time. Whats the best tool to crunch this information? Idealy I'd like to be able to see avg stats per hour for the object counters that have been monitored.
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(4)
看看 SmartMon (www.perfmonanalysis.com)。 它分析 CSV 和 SQL Server 数据库中的 Perfmon 数据。
Take a look at SmartMon (www.perfmonanalysis.com). It analyzes Perfmon data in CSV and SQL Server databases.
这是 Codeplex 上提供的免费工具,提供图表功能以及不同服务器角色的内置阈值(也可以修改)。 生成 HTML 报告。
http://www.codeplex.com/PAL/Release/ProjectReleases。 aspx?ReleaseId=21261
This is a free tool provided on Codeplex, provides charting capabilities, and inbuilt thresholds for differnt server roles, which can also be modified. Generates HTML reports.
http://www.codeplex.com/PAL/Release/ProjectReleases.aspx?ReleaseId=21261
根据我的经验,如果您将数据重新记录到 CSV 或 TSV,即使只是 Excel 也是一个非常好的工具,可以快速绘制性能监控图。 您可以只绘制滚动平均值和 看到进展。 Excel 并不奇特,但如果您的数据不超过 30-40 兆,它可以完成相当快的工作。 我发现 Excel 2007 在使用表格和数据时往往会变得不稳定。 超过 50 兆数据:在某一时刻,“撤消”导致其消耗 100% 的 cpu 和 1.3 GB 内存。
附录 - relog 不是最知名的工具,但它非常有用有用。 我不知道任何 GUI 前端,所以你只需要从命令行运行它。 我使用它的两个最常见的情况是从
From my experience, even just Excel makes a pretty good tool for quickly whipping up graphs of perfmon if you relog the data to CSV or TSV. You can just plot a rolling average & see the progression. Excel isn't fancy, but if you don't have more than 30-40 megs of data it can do a pretty quick job. I've found that Excel 2007 tends to get unstable when using tables & over 50 megs of data: at one point an 'undo' caused it to consume 100% cpu & 1.3 GB of RAM.
Addendum - relog isn't the best known tool but it is very useful. I don't know of any GUI front ends, so you just have to run it from the command line. The two most common cases I've used it for are
也许可以考虑使用 LogParser< /a>.
这取决于信息的记录方式(Perfmon 并不缺乏灵活性)
如果它们是 CSV,您甚至可以使用 ODBC 文本驱动程序并对它们运行查询!
(性能将是“有趣的”)
这是关于 CodingHorror 文章 的必要链接话题 ;-)
Perhaps look into using LogParser.
It depends on how the info was logged (Perfmon doesn't lack flexibility)
If they're CSV you can even use the ODBC Text drivers and run queries against them!
(performance would be 'intriguing')
And here's the obligatory link to a CodingHorror article on the topic ;-)