From BOL:
Permissions
--------------------------------------------------------------------------------
Requires VIEW SERVER STATE permission on the server to see all executing sessions on the instance of SQL Server. Otherwise, the user sees only the current session.