Sachi's Greenplum database maintenance and monitoring scripts

To get the script email us gpdba@greenplumdba.com

==Greenplum database maintenance and monitoring Option ==

##############################################################################################

 Please read the menu options carefully before selection as our menu option may have changed. #

##############################################################################################

Choose one of the following option:

1  - Run Daily Maintenance

2  - Run Weekly Maintenance

3  - Run Catalog Maintenance

4  - Check and fix catalog corruption

5  - DCA Health Report

6  - Database State Monitoring Report

7  - Database Alert Log Monitoring Report

8  - DCA Space Monitoring Report

9  - Missing Table Statistics Report

10 - Bloat Check 

11 - Skew Check 

12 - Check locks on table

13 - Check tables with RANDOM distribution policy

14 - Check GUC parameter value

15 - Backup database using ddboost

16 - Archive log files older than threshold limit

17 - Cleanup orphaned temp schema

18 - Display DCA master Disk Usage

19 - Display DCA master CPU Utilization

20 - Display DCA master Memory Utilization

21 - Schema Space Monitoring Report 

22 - DCA, Database, OS version Report 

23 - Check tables distribution policy

24 - Check table skew

25 - Check running queries

26 - Check resource queue settings

27 - TOP 20 resource intensive SQL 2 days

28 - Most active users

29 - Most used resource queues

##############################################################################################

97 - Help and Support

98 - Show configuration setting

99 - Logout 

##############################################################################################

Enter your option: