How to Grant Read-Only Access to Activity Monitors
May 15, 2018

Give your clients the ability to view activity monitor, without handing over full sys-admin rights into your managed SQL server environments;
use [master] GO GRANT VIEW SERVER STATE TO [DomainUsername] GO