This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(35.2, 93%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESM%3C/text%3E%3C/svg%3E)
DBA's - I am seeing Processes section under SSMS - Activity monitor is greyed out for one of the windows login
I have granted Performance Monitor Users under lusrmgr
Now I am seeing access is denied and none of the functionalities are working under activity monitor.
I have granted permissions as per below article:
https://sqltimes.wordpress.com/2018/04/24/sql-server-the-activity-monitor-is-unable-to-execute-queries-against-server-activity-monitor-for-this-instance-will-be-placed-into-a-paused-state-use-the-context-menu-in-the-overview-pane-to-resume/
Still the login have access is denied errors, Please help.!
Thanks in advance.
best regards,
Santosh
The permission needed would be VIEW SERVER STATE. Check that you don't have a DENY in the mix.
Then again, "Access is denied" is a Windows message. Can you post a screenshot, so we feel more certain of what you are talking about?
Hello
Below is the error while user trying to access activity monitor. He already have view server state N even sysadmin too.
TITLE: Microsoft SQL Server Management Studio
The Activity Monitor is unable to execute queries against server xxxxDer.
Activity Monitor for this instance will be placed into a paused state.
Use the context menu in the overview pane to resume the Activity Monitor.
Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED)) (mscorlib)
Plz suggest
Thanks
OK, that's a Windows permission error, so you would have to compare the permissions and group memberships for the users where it works with the user where it does not.
I don't know exactly what permissions that would be. I don't use Activity Monitor myself. I prefer my own beta_lockinfo. Many people go by Adam Machanic's sp_WhoIsActive.
I have added that user to group - Performance Monitor Users, under local users & groups.
Any links to post on bugs to MS? Thanks!
I have added that user to group - Performance Monitor Users, under local users & groups.
I don't really see what Performance Monitor Users has to do with Activity Monitor. The blog post you linked to talks about permission for DCOM Config, and that is something completely different. Double-check that you actually followed the instructions in the blog post.
Also beware that the user may be member of an AD group which have been denied a required permission, and that would take precedence over granted permissions. (That is the least the case in SQL Server, and I would suspect that it is the same in Windows.)
Any links to post on bugs to MS? Thanks!
Ronen gave you the link below. However, there is absolutely nothing here that indicates that this is due to a bug.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(108.80000000000001, 46%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAM%3C/text%3E%3C/svg%3E)
Hi SantoshM-2271,
In addition, have you tried to run SSMS as administrator?
Please refer to this similar thread which might be helpful.
Best Regards,
Amelia
Hi,
(1) It is recommended to use Adam Machanic's sp_WhoIsActive (as Erland mantioned) which you can download from here:
https://github.com/amachanic/sp_whoisactive/
Another stored procedure which you should check and probably use to monitor your server activities and configuration is Brent's Ozar sp_BlitzFirst which you can find here together with a few more utilities: https://www.brentozar.com/first-aid/
Any links to post on bugs to MS? Thanks!
(2) To report bugs you should use Microsoft's feedback system https://feedback.azure.com
You can directly use this link to go to the SQL Server reporting place: https://feedback.azure.com/d365community/forum/04fe6ee0-3b25-ec11-b6e6-000d3a4f0da0