Thanks... However I already used the Activity Monitor in SQL Management Studi 2005.

My problem here is that how would I know if a certain application is consuming more CPU, Phsyical I/O, etc.. in connecting SQL basing with Acitivity Monitor. Are there any basis or recommended values?