Critical Unknown SQL Exception 297 occurred.

OWSTIMER.EXE (0x1EF0) 0x17D4 SharePoint Foundation Database 5586 Critical Unknown SQL Exception 297 occurred. Additional error information from SQL Server is included below.  The user does not have permission to perform this action.

Solução:

Execute a seguinte query na instância do SQL do SharePoint. Você precisará mudar o usuário paro o usuário que executa o serviço do SharePoint Timer, conforme imagem.

GRANT VIEW SERVER STATE TO "contoso\administrator"

[]