Monitoring SQL and CPU usage

[Pagemakers]

Is there any way I can see what the current CPU and SQL usage is?

Each day our CPU seems to max out at 100% requiring us to re-start SQL and once done it is fine again until the next day.

 

[wsani]

You can install net-snmp, and use it along with CACTI to keep track of things or you can use HTOP to see what's going on with your OS.

 

[Pagemakers]

Every morning I have to restart SQL because the CPU is running at 100% and the entire server grinds to a halt. It can take 5 minutes to open the CP. As far as I see there are no Cron jobs running to cause this issue.