'Infrastructure Health' shows message 'Needs attention' for Database health on CCS Consoles Home dashboard.

Products

• Control Compliance Suite
• Control Compliance Suite Standards Module
• Control Compliance Suite Standards Server

Issue/Introduction

When hovering over "i" next to 'Infrastructure Health' on the CCS Console's Home dashboard, you get the following message:

"Needs attention" for Database health.

No further details were given.

Environment

CCS 12.6.x

Cause

Enabled "Health and Status Notification" option for page notification for Production and Reporting Database Maintenance Due" and index fragmentation in CCS databases goes above 90%.

Resolution

The 'Needs attention' warning indicates that the CCS Database maintenance is pending and an alert appears if the index fragmentation in CCS databases goes above 90%.  (The alert notification is due as per the number of days specified in the Health and Status Notifications configuration)

Regular database maintenance is required for the following reasons:

- Over time, heavy use of CCS can cause index fragmentation in CCS databases which can negatively affect the performance of the activities that depend on the databases.

- Performance of Reporting sync job, Report generation jobs and the dynamic Dashboards can become slow.