SCOM SQL alerts are created every hour on SQL secondary replica server if "Always On" for Monitoring server is set in Skype for Business Server 2015

Aplícase a: Skype for Business Server 2015

Symptoms


In Microsoft Skype for Business Server 2015, if you set the SQL Always On Availability for the Monitoring server, the SCOM SQL alerts are generated every hour on the SQL secondary replica server.

Resolution


To fix this issue, do the following steps:
  1. Install the July 2019 cumulative update 6.0.9319.559 for Skype for Business Server 2015, Core Components.
  2. Fail over the database to a secondary database.
  3. Run Install-CsDatabase -Update -SqlServerFqdn <SqlServerFqdn> -Configured Databases.
  4. Run step 3 by failing over the primary database to each secondary database one at a time.