Trying to troubleshoot resource usage (e.g. Memory) for the past, how can I view/run reports to analyze what resources were used? Trying to detect spikes...
You will have to monitor your memory usages through SSH using the "top" and "ps aufx" command., With these command your can find out which process is using the memory on your server
If you have sysstat installed you can run sar commands to save and view performance history and mrtg is another good tool if you want to display it on a web interface and view it in graphs ..