question

a3koopman avatar image
a3koopman asked

Activity monitor not working

Hi,

I have a SQL2019 machine where the SQL Server service account is a Group Managed Service Account. I can start (and make a connection) to this SQL Instance from another client workstation, using integrated security. However, when I start the activity monitor I get the Overview, but when I expand the "Processes" part, that part remains empty and also after some time (30 seconds?) I see "Paused" at the overview bar.

The user that makes the connection is member of the sysadmin group, the Group Managed Service Account (gMSASQL01) is also defined as Login and member of the sysadmin group and is on Windows Server level member of the local Administrators group.

What am I missing to get the Activity monitor running?

Adri

service-accountactivity-monitor
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.