after update Octopus Deploy to 2022.1 (2278) in Diagnostics section I see some error logs:
An error occurred while trying to trying fetch the number of active SQL transactions: "Error while executing SQL command in transaction 'SqlTransactionMetricsProducer.UpdateMetrics': VIEW SERVER STATE permission was denied on object 'server', database 'master'. The user does not have permission to perform this action.
I found this issue on GitHub and seems to be related to An error occurred while trying to trying fetch the number of active SQL transactions · Issue #7403 · OctopusDeploy/Issues · GitHub
Checks are made very frequently. Could you help resolve this issue?