Aqua Data Studio offers a suite of Vertica DBA Tools for the monitoring, maintaining and tuning of the Vertica server. It includes an Instance Manager, Storage Manager, Security Manager, and Session Manager. These managers allow the monitoring and maintenance of Database Objects, Sessions, Users and Permissions via GUI. A Query History view is also provided.
Aqua Data Studio Vertica Administration Tools
Vertica Instance Manager
Provides GUI view and search access for:
Instance Summary (Database State, Value)
Configuration Parameters
Session Parameters
Nodes Details
Query History (DDL, Query, UTILITY SQL executed on Server within Last 1/3/6/12/24 hours,3 days,1/2 weeks,Custom)
Vertica Session Manager
Provides GUI view and search access for:
Session Details, Kill Session
Session Statistics
Session Locks
Session Grouping (By Session ID, Client PID, and more)