Chuzoi's tool is excellent if you can look at the snapshot data and interpret it yourself ... I use it extensively whenever there is a performance related problem reported or if some performance test in progress ... In addition, I do take snapshots are regular intervals at these times for analyzing at a later time ...
But, if you want a general monitoring tool, then obviously you need $$$$. Quest has a limited version of its Quest Central monitoring available for free on their website ....
www.quest.com .
Cheers
Sathyaram