March 19, 2019 at 7:07 am
Hello community,
I have a problem with the activity monitor on a sql server 2016 cluster. The processor time in the activity monitor is grayed out.
So the connecting account is in the local administrators group, is sysadmin.
I havn't found any hint why this happens. I have other sql server 2016 clusters equally configured. No problem at all!
Cheers
Marcus
March 23, 2019 at 1:01 pm
try using FQDN.
March 24, 2019 at 11:21 pm
Hi there,
I have a possible solution. Found this post about the performance counters (CPU Usage in SSMS is just an performance counter) https://social.technet.microsoft.com/Forums/windowsserver/de-DE/cb66af1c-0e3f-440b-9480-b94b4b8c4c38/event-id-2004-error-source-perfnet?forum=exchangesvradmin
I havn't tried it yet. But our servers are HPE servers with the HPE agent on them.
April 12, 2019 at 6:14 am
Finally I found the problem and solution.
The reason why the processor pane of the activity monitor was greyed out was:
the remote registry service has to run. On my cluster it kept stopping every 10 min. This bevaviour is intended by design of the service.
If you want the service to run all the time one has to set a registry key (https://social.technet.microsoft.com/Forums/office/en-US/65276840-b282-495c-b919-c95fd3b4f63a/remote-registry-service-stops-automatically-if-we-do-not-use-it-above-10-minutes?forum=w8itprogeneral).
Also this service is essential to do upgrades of the SQL Server on a cluster. Otherwise the patches will fail.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply