Critical error “Microsoft.SharePoint.Diagnostics.SPDatabaseServerDiagnosticsPerformanceCounterProvider“

Reason behind this error

We are using Alias name of SQL server and using SPDiag studio to analysis SharePoint.

Fix

Add SQL alias name with IP (is you are using cluster than cluster IP) in host file in every App server and Front end server.

Add farm administrator(User account that is responsible to run SPTimer service) in Performance Monitor Users group (Local VM/Server).

Note:-If you are using cluster based SQL server that you need to add this in every SQL node.

Now restart the SPTimer service.

:)