HI

Yesterday the server running the SQL2005 database was running very slowly. Simple tasks in the application using the database where taking a long time.

My question is apart from the activity monitor what other tools are there that I can use to find out whats happening. The activity monitor didn't seem to show me what was using all the resources up.,

Thanks