How to give permission to someone to use SQL Server Activity Monitor or to use DMV
Use below steps to give some permission to use Activity Monitor or to use DMV.
1.Give the use login permission
2.Give the user view server state permission using below code:
GRANT VIEW SERVER STATE TO <Login>
Giving this permission is very much needed when you do not wish to give someone high privilege on the server but you need to allow them to execute DMV or use Activity Monitor for their job responsibility.