Database Scripts

This script will show you what is the size of you Database Catalog.

Use this information to set your General Resource Pool accordingly by keeping in mind that the Vertica Catalog is not loaded in the General Pool allocated Memory and is loaded into the memory that is outside the  General Pool allocated Memory threshold.

 

Database Scripts

The script will list all requests that ended up in a error message. This is part of the daily monitoring and will help you identify bad sql that needs to be resolved.

Database Scripts

The script will list all the projections that were not refreshed in the last month.