Skip to main content

Database health check reports

  • May 5, 2017
  • 2 replies
  • 22 views

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.

2 replies

RaghavA
Forum|alt.badge.img
  • Participating Frequently
  • May 5, 2017

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
  • Author
  • New Participant
  • May 5, 2017

Thanks Ragha , will check it.