What privileges are needed to access activity monitor?

_{Wednesday, September 7, 2011 1:03 PM}

I am on SQL Server 2008 R2. What minimum privileges are needed to access activity monitor for database performance? I do not want to have sysamdin privileges which my DBA team will not grant anyway. Just want to know what privileges I can ask for.

_{Wednesday, September 7, 2011 1:58 PM ✅Answered}

Hi Prem,

You need:

VIEW SERVER STATE to view Activity Monitor,

also, you need ALTER ANY DATABASE permission to view "Data File I/O" section in Activity monitor.

If you want to kill a process then you must be a member of the sysadmin or processadmin.

from BOL : http://msdn.microsoft.com/en-us/library/ms175518.aspx

- Vishal

SqlAndMe.com

_{Wednesday, September 7, 2011 1:14 PM}

To view the Activity Monitor in SQL Server 2005 and SQL Server 2008, a user must have VIEW SERVER STATE permission.Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/