Clarity Health – SQL

The Clarity Health portlet provides a quick glance into the health of key components and critical jobs in the Clarity environment.

 

The following metrics are monitored:

 

Process Engine 

Heartbeat should refresh itself every 10 minutes. Process Engine is responsible for the triggering of processes.

Green <= 10 Minutes, Yellow 11-15 Minutes, Red > 15 Minutes

 

Time Slices

Time Slices are required for accurate reporting. Best practice is for the Time Slicing job to run every minute. Please note there are some jobs that will cause the time slicing to delay so a momentary delay is normal.

Green <= 10 Minutes, Yellow 11-15 Minutes, Red > 15 Minutes

 

Datamart Extraction

Green <= 24 Hours, Yellow 24-48 hours, Red > 48 hours

 

Datamart Rollup

Green <= 24 Hours, Yellow 24-48 hours, Red > 48 hours

 

 

 

Rate Matrix – Full

Best practice is to run a full rate matrix nightly

Green <= 24 Hours, Yellow 24-48 hours, Red > 48 hours

 

Rate Matrix – Incremental

Green <= 24 Hours, Yellow 24-48 hours, Red > 48 hours

 

Load Data Warehouse – Full Load

Green <= 24 Hours, Yellow 24-48 hours, Red > 48 hours

 

Load Data Warehouse – Incremental                     

Green <= 24 Hours, Yellow 24-48 hours, Red > 48 hours

 

Load Data Warehouse Access Rights

Green <= 24 Hours, Yellow 24-48 hours, Red > 48 hours

The Clarity Health portlet provides a quick glance into the health of key components and critical jobs in the Clarity environment.

 

The following metrics are monitored:

 

Process Engine 

Heartbeat should refresh itself every 10 minutes. Process Engine is responsible for the triggering of processes.

Green <= 10 Minutes, Yellow 11-15 Minutes, Red > 15 Minutes

 

Time Slices

Time Slices are required for accurate reporting. Best practice is for the Time Slicing job to run every minute. Please note there are some jobs that will cause the time slicing to delay so a momentary delay is normal.

Green <= 10 Minutes, Yellow 11-15 Minutes, Red > 15 Minutes

 

Datamart Extraction

Green <= 24 Hours, Yellow 24-48 hours, Red > 48 hours

 

Datamart Rollup

Green <= 24 Hours, Yellow 24-48 hours, Red > 48 hours

 

 

 

Rate Matrix – Full

Best practice is to run a full rate matrix nightly

Green <= 24 Hours, Yellow 24-48 hours, Red > 48 hours

 

Rate Matrix – Incremental

Green <= 24 Hours, Yellow 24-48 hours, Red > 48 hours

 

Load Data Warehouse – Full Load

Green <= 24 Hours, Yellow 24-48 hours, Red > 48 hours

 

Load Data Warehouse – Incremental                     

Green <= 24 Hours, Yellow 24-48 hours, Red > 48 hours

 

Load Data Warehouse Access Rights

Green <= 24 Hours, Yellow 24-48 hours, Red > 48 hours