Depends on what you want to monitor. Install the profiler if you want to monitor what the sql server is doing. If you want to view cpu usage you can always add the remote counters in the perf mon.

>Is there some type of tool out there where I can monitor the server activity from my desktop?