EmpowerID HealthCheck SQL Procedure
Run the SQL stored procedure, Z_EmpowerID_Health, to conduct a health assessment of core EmpowerID processes. This procedure is designed to evaluate the performance of standard EmpowerID functionalities and should be used by enterprise monitoring tools to notify IT personnel when intervention is needed. Customization options are available to include additional checks.
It is advised to run this procedure on a regular basis at 5-minute intervals; intervals shorter than 1 minute may cause excessive system load.
Required Configuration Settings
Two settings are needed for certain pre-programmed health checks in this stored procedure to function effectively. Configure these settings via the EID UI: https://<EID-URL>/ui/#custom/EmpowerIDConfigSettings
EmpowerID_Health_EmpowerIDServerRoleNames_ToMonitor: Enter a comma-separated list of EmpowerID Server Roles used in your EID instance. Typically, this value should be "Application Server Full, Web Front-End" to cover the two most common server roles.EmpowerID_Health_EmpowerIDServiceFriendlyNames_ToMonitor: Provide a comma-separated list of EmpowerID Services used in your EID instance. Generally, this value should be "Web Role Service, Worker Role Service" to include the two most frequently utilized services.
Procedure Results
When you run the Z_EmpowerID_Health procedure, you will always receive a single resultset containing at least one result. The resultset includes a single column. If all checks pass, only a default record with the text "Z_EmpowerID_Health Complete (disregard this message)" will be returned. If any checks fail, the default record will be preceded by records indicating the failed checks. This design is intended to facilitate easy integration with most enterprise monitoring tools.
Available Health Checks
The stored procedure contains various built-in health checks, and you have the option to add more checks for use-case-specific logic. Below is a table of potential health checks and the corresponding text returned in case of a failure:
| Health Check | Failure Message |
|---|---|
| Service Heartbeat | EmpowerID Service <ServiceName> Heartbeat Overdue (5 minutes or more elapsed) |
| Server Role Heartbeat | EmpowerID Server Role <RoleName> Heartbeat Overdue (5 minutes or more elapsed) |
| Job Timing | Job Overdue: <JobName> (10 minutes or more elapsed) |
| Job Status | Job Not Succeeding: <JobName> |
| Inventory Progress | Inventory Progress Stalled: <SystemName> |
| Enforcement Progress | Enforcement Progress Stalled: <SystemName> |
| Membership Progress | Membership Progress Stalled: <SystemName> |
| Projection Progress | Projection Progress Stalled: <SystemName> |
| Inventory Timing | Inventory Overdue: <SystemName> |
| Enforcement Timing | Enforcement Overdue: <SystemName> |
| Membership Timing | Membership Overdue: <SystemName> |
| Projection Timing | Projection Overdue: <SystemName> |
| Inventory Status | Inventory Not Succeeding: <SystemName> |
| Enforcement Status | Enforcement Not Succeeding: <SystemName> |
| Membership Status | Membership Not Succeeding: <SystemName> |
| Projection Status | Projection Not Succeeding: <SystemName> |
| Account Store Job Failures | Job <JobName> on AccountStore <SystemName> failed <#Failures> times consecutively from <EarliestFailureDateTime> to <RecentFailureDateTime> |
| Permanent Workflow Status | Permanent Workflow <PermamentWorkflowName> is marked Active but overdue |
| Compiled Set Status | Compiled Set <SetName> is marked Enabled but overdue |
| Cloud Gateway Status | Cloud Gateway Server <ServerName> has not contacted EmpowerID in more than 5 minutes |