带电子邮件的 Windows 服务器性能监控工具
我们在 Windows Server 2008 上有一个 SQL Server 2005。SQL Server 的性能全天不一致。例如，通常需要不到 5 秒的过程，有时需要大约 30 到 45 秒。在少数情况下，此过程甚至需要 180 秒。当我们进行一些故障排除时，我们感觉（尽管不确定）服务器上几乎没有任何负载。
因此，为了了解是什么导致服务器变慢，我们想到了 24/7 监控磁盘空间、内存、杯子负载等。我们在此链接找到了powershell脚本并使用了它们。但它们没有经过打磨，看起来效果不太好。任何帮助我们监控该服务器健康状况的想法和指示都值得赞赏。
We have an SQL server 2005 on Windows Server 2008. SQL server performance is not consistent through out the day. For example, a procedure that takes less than 5 seconds usually, takes around 30 to 45 seconds sometimes. In a few cases, this procedures has taken even 180 seconds. When we did a little bit of troubleshooting, we felt, though not sure, that the was hardly any load on the server.
So to understand what is/are causing the server become slow, we thought of monitoring disk space, memory, cup load etc for 24/7. We found powershell scripts at this link and used them. But they are not polished and do not seem work well. Any ideas, pointers to help us monitor this server for its heath is appreciated.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
可能有点晚了，但你应该看看 PAL
Probably a Bit Late but you should have a look at PAL
您应该能够使用 Windows 性能监视器来执行此操作。请参阅https://support.microsoft.com/en-us/kb/2424491
还有大量其他工具可用于监控 Windows 服务器性能。我编制了一份广泛的列表： https://checkpanel.com/resources/windows -服务器性能监控工具
You should be able to do this with Windows Performance Monitor. See https://support.microsoft.com/en-us/kb/2424491
There is also a wide array of other tools for monitoring windows server performance. I have compiled an extensive list: https://checkpanel.com/resources/windows-server-performance-monitoring-tools