Hi @adil ,
I want to confirm with you that what operations were you executing when this error appeared and Did this error cause any features of your SharePoint to be missing?
Firstly please take a reference to the following solution to provide the View Server State permission to the SharePoint service account.
- Access SQL Server Management Studio via GUI
- Connect to the SQL instance
- Navigate to Security | Logins
- Right Click the SharePoint Service Account | Select Properties
- Select the Securables page
- In the bottom pane, scroll to the bottom and Grant - View Server State
If an Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.