I'm looking for a software tool, preferably free , that can monitor CPU and memory usage for individual processes, specifically for SQL, for 10-second intervals. The tool should generate an alert, such as an email or popup notification, if the CPU usage for the entire 10 seconds exceeds say 75%.
I've researched some tools such as Process Explorer and Process Monitor from Sysinternals, but they don't have an alerting feature. Process Lasso (whose features matches my requirement) and SysGauge have alerting options, but they are only available in the paid version. I also tested ManageEngine OpManager, but it didn't work properly and was difficult to configure. Additionally, I tried using the Performance Monitor (perfmon.exe) and added the counter, but it didn't generate an alert.
I have also tried using Event Sentry free edition, it meets the same requirement but works using Event-logs. When I set the threshold for the process counter to generate an alert , it did not work. Not easy to configure and use as well.
Can you recommend any free or paid tools that meet these requirements? Any assistance would be greatly appreciated. Thank you.