Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I only see my own connections/processes in the new activity monitor... whereas in the earlier versions of SSMS you could see everyone's. Do I need to change a setting or something?

share|improve this question
What permissions / roles do you have on the server? – squillman Sep 3 '10 at 17:06

You will need the VIEW SERVER STATE permission to view the Activity Monitor in SQL Server 2005 and SQL Server 2008.

Under the processes make sure you have select Login as (All) to show all the processes.

By the way, do you see any of the system processes?

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.