After upgrading to Foglight 6.0.0 and SQL Server cartridge 6.0.0.10 the following messages are frequently logged in the Foglight Management Server logs.
YYYY-MM-DD hh:mms:ss.SSS VERBOSE [Data-4-thread-1783] STDOUT - Exception in calculation DBSS_Individual_CPU_Usage_OS_For_Rule derived metric.
WORKAROUND
Complete the following steps to replace the derived metric expression "DBSS_Individual_CPU_Usage_OS_For_Rule":
3. Backup to a text file, replace the current expression with the one below and save changes.
try {
result = #utilization#;
exceptionsValue = registry("DBSS-RulesException_IndividualCPUUsage");
if (exceptionsValue != null) {
exceptionsList = exceptionsValue.split(",");
for(exception in exceptionsList) {
if(exception.equals(scope.name)) {
result = 0;
break;
}
}
}
return result;
} catch (Exception e) {
Dbwc_Common_SQL_Server_ExceptionInvestigation ("DBSS_Individual_CPU_Usage_OS_For_Rule", e,
[
"scope.name"
],
[
"#utilization#" : #utilization#
]
);
}
STATUS
This issue has been logged as defect FOG-2570 and has been fixed in the 6.1.0.10 and higher releases of the Foglight Cartridge for SQL Server.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center