SQLRNNR, There are only 50 active connections.....so, I don't think this is the issue.

Joie Andrew, Had complains that everything is running slow and I coudn't find anything else other than SQL using all the memory which is allocated to it.

GilaMonster, I am not 100% sure if it's only memory related, however, I am stuck as to what's the next step....not an exper on performance tuning.

Grant Fritchey, I did select * from sys.dm_os_wait_stats, now which column should I focus.

I really appreciate all of you for giving me valid inputs as to where/what should I be checking. Could this be a CPU issue as well?

Thanks,

SueTons.