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?

  • 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?

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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