I am looking for a tool or easy way to watch the processor/memory usage on multiple Windows 2003 servers. We suspect an App is making it use 100% processor because of large memory usuage and want to confirm by monitoring it. Although it doesn't happen all the time only when we have a higher traffic. Any Recommendations?
Perfmon is great for real-time point-in-time monitoring of this sort of thing. An SNMP collector is a better tool for long-term trending, but if you're trying to solve a problem as it's happening, fire up your Perfmon and go to town.
Also - there's no reason to assume that large RAM usage will automatically correlate with 100% CPU usage. They're independent of each other - although for a given application, they may both be correlated to a single root cause like increased user load or bad queries. I'm sure you'll find that out as you investigate, but don't assume something like that, you'll waste time looking for it.