SharePoint 2016 - How To Configure Usage And Health Service Application Using PowerShell

Usage & Health Service Application is one of the most important service applications that provides vital information on the health & state of a SharePoint Farm.

In SharePoint 2016, Usage Service collects information on Timer Service Monitoring, Event Logs, Performance Counters, Search Usage, Sandbox Usage, and Site Collection Usage and much more.

This Service application is responsible to keep monitoring the resource, health & state associated with the SharePoint Farm and logs this information to Log Files on a SharePoint Hive or any designated path along with SharePoint Logging Database “WSS_Logging” in SQL Server Database.

Many other components in SharePoint like Developer Dashboard, Search Analytics, Web Analytics Reports use this data to provide a logical User Interface for the end users.

You will get empty reports in Web Analytics reports section if usage and health data collection service application is not configured properly. It is not possible to provision Usage & Health Service using Central Admin, as there is no User Interface available.

Let us first get into Central Admin Site to see if there are options available on the User Interface to provision Usage Service.

Go to “Central Admin” – > “Manage Service Applications”.

SharePoint

Click on “New” menu on the Ribbon and in the existing list of available Service Application Templates, we can see there is no template available for provisioning “Usage & Health Service Application”.

SharePoint

This concludes that we have to provision Usage Service using PowerShell as shown in the following steps-

SharePoint

Launch “SharePoint 2016 Management Shell”.

SharePoint

 Step 1: Provision Service Application Instance

In this step, we will provision the Usage Service using “New- SPUsageApplication” cmdlet, as shown below.

New-SPUsageApplication -Name "Usage and Health Data Collection"

SharePoint

 

Step 2: Provision Service Application Proxy

In this step, we will provision Service Application Proxy for Usage Service by using the following commands.

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

SharePoint

$serviceProxy.Provision()

SharePoint

Step 3 - Verify Service Application

In this step, we will verify the provisioning of service application by looking at “Service Application” Page in “Central Administration” as shown below.

SharePoint

 

Step 4 - Verify Service Application Database

In this step, we will verify the provisioning of service application database by logging into “SQL Server Management Studio” as shown below.

SharePoint

 

SharePoint

This concludes the Service Application Provisioning Process using PowerShell.

Hope you find it helpful.