Event ID 6398 and 5586 : Could not find stored procedure 'dbo.Search_GetRecentStats'.

Issue Description

On checking the SharePoint server event viewer, I was seeing the below errors every minute.

Event 6398

The Execute method of job definition Microsoft.Office.Server.Search.Monitoring.HealthStatUpdateJobDefinition (ID 67ac9b25-4559-4847-849f-16f05cee73c9) threw an exception. More information is included below.

Could not find stored procedure 'dbo.Search_GetRecentStats'.

Event 5586

Unknown SQL Exception 2812 occurred. Additional error information from SQL Server is included below.

Could not find stored procedure 'dbo.Search_GetRecentStats'.

Fix

Go to Central Administration -> Monitoring -> Configure usage and health data collection -> Enable health data collection