Greenplum database maintenance and monitoring
Regular database monitoring and maintenance is necessary to keep your database optimal for the applications and user activities. There are few things that you need to monitor on daily/weekly basis. We will discuss some of the important activities that you need to monitor actively.
check for FATAL and ERROR log messages from the system - Oct 09, 2014 10:4:9 PM
Basic check to see if the master is up and functioning - Oct 09, 2014 9:55:22 PM
Check the state of the master mirroring. - Oct 09, 2014 9:50:34 PM
Check if distributed query is functional on all segments - Oct 09, 2014 9:47:14 PM
Check segments that are in a non-optimal role - Oct 09, 2014 9:43:49 PM
Check segments that are currently resyncing - Oct 09, 2014 9:41:5 PM
Check segments that are currently in change tracking mode - Oct 09, 2014 9:38:14 PM
Check if one or more Greenplum segments are down - Oct 09, 2014 9:12:17 PM