Database health check reports

verticadba2

Hello All, We are doing a health check and generating reports manually as of now. We want to make this process automated. Please suggest is there any script which we can schedule to get database health report . We want to capture server health (cpu,mememry,disk) and database health like AHM, K-safty etc.... Thank you.

RaghavA

Hi,

I would suggest you incorporate 2 scripts which can be used as your health check. One could gather your OS level from SAR reports and for database section, have to look Norbert Krupa's effort shared in following link:

https://github.com/NorbertKrupa/vertica-kit

Regards,
Raghav Agrawal

verticadba2

Thanks Ragha , will check it.