How to create a SharePoint Usage and Health Data Collection Service Application through PowerShell

Usage and Health Data Collection Service Application collects Data about Usage and Health of your farm. This information is used for Health Monitoring and this is also required for running the Web Analytics Service. If you do not have a Usage and Health Data Collection Service Application or your Usage and Health Data Collection Proxy is stopped, you will not see any data in the Web Analytics Report.

You cannot create Usage and Health Data Collection Service Application from Central Admnistration.

You have to use PowerShell for this :

New-SPUsageApplication -Name �UsageAppName� -DatabaseServer �DBServerName� -DatabaseName �DBName�

$Usage = Get-SPServiceApplicationProxy | where {$_.TypeName -eq �Usage and Health Data Collection Proxy�}

$Usage.provision()

More information

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