DBSS - SQL PI: SQL PI Experiencing Errors fires too often (4382642)

The DBSS - SQL PI: SQL PI Experiencing Errors fires too often even though the rule has been changed only to fire if fire if 3 consecutive evaluations are true.

The monitored host sometimes has the instance down for several minutes. The AvailabilityHandler routine (that triggers the Experiencing Errors alarm) collection run every 1 minute , 

WORKAROUND

Change the collection frequency to run every 30 minutes for all of the SQL Server agents by running the following groovy script via the script console 

agentService = server.get("AgentService");
configService = server.get("ConfigService");

def setAspParams(agents, aspName, aspValue) {
	for (agent in agents) {
		def primaryASP = configService.getAgentInstancePrimaryAsp(agent.getAgentNamespace(), agent.getTypeId(), agent.getId());
		primaryASP.setValueByString(aspName, aspValue);		
		configService.saveConfig(primaryASP);
	}
}

def agents = agentService.findByAdapterAndType( "FglAM" , "DB_SQL_Server");

// default false
setAspParams(agents, "paecOlapAvailabilityIntervalMinutes", "30");


return true;

STATUS

Enhancement FOG-12381 has been logged to make improvements to the alarms. This will be considered by Product Management for inclusion in a future release of the SQL Server cartridge.