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

Products

• Control Compliance Suite

Issue/Introduction

When hovering over "i" next to 'Infrastructure Health' on CCS console Home dashboard we get the following message: "Needs attention" for Database health. No further details given.

Environment

CCS 12.5.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 need attention indicates that the Database maintenance is pending and alert appears if the index fragmentation in CCS databases goes above 90% and when 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 performance of the activities that depend on the databases.

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