Is there a way to alert based on an applications windows service memory or CPU usage levels?
Yes. From SAM Settings, simply use the highlighted option 'Component Monitor Wizard' and choose the service you want to monitor. The wizard will let you set thresholds on CPU, Memory, network and Disk IO for the associated processes.