• The easiest way is to just open a connection (i.e. using sqlcmd or Management Studio) using your sysadmin credentials and issue the following statement:

    GRANT VIEW SERVER STATE TO <<login name>>

    This will grant <<login_name>> VIEW ANY STATE permission.

    Sobhan Kishore Chintala