Monitoring Existing Infrastructure Using MC
Use the Management Console Existing Infrastructure tab to monitor the health of your Vertica databases and clusters. Click the cluster of interest to view the health of the nodes in that cluster and the key information associated with the cluster such as:
- Vertica version
- Number of hosts
- CPU type
- Last updated date
- Node list.
You can also zoom in and out for better view of this page.
Click the database which you want to monitor to go to its Overview page:
Tip: You can also view the Overview page by clicking on the desired database on the MC Home Page.
You can perform the following tasks from the Overview page:
- View Quick Stats to get instant alerts and information about your cluster's status.
- View Status Summary that provides a general overview of the status of your cluster (as shown in preceding figure).
- Analyze System Health using a comprehensive summary of your system resource usage and node information, with configurable statistics that allow you to specify acceptable ranges of resource usage.
- Use Query Synopsis to monitor system query activity and resource pool usage.
Additionally, you can perform the following tasks from the Overview page:
Monitoring System Resources
On the main window, you can click the database, and navigate to the MC Activity tab to monitor system resources such as:
- Queries
- Internal Sessions
- User Sessions
- Memory Usage
- System Bottlenecks
- User Query Phases
- Table Treemap
- Query Monitoring
- Resource Pool Monitoring
Monitoring Node and MC User Activity
You can use the MC Manage page to monitor node activity. When you click the node you want to investigate, the Node Detail page opens and provides:
- Summary information for the node
- Resources consumed by the node for last three hours
You can also browse and export log-level data from AgentTools and Vertica log files. MC retains a maximum of 2000 log records. See Monitoring Node Activity for further details.
Use MC Diagnostics tab and navigate to Audit Log page to manage MC User activity. See Monitoring MC User Activity Using Audit Log.
Monitoring messages in Databases managed by MC
You can view critical database related messages from MC Message Center. The MC Message Center reports on several critical database-related conditions using a color code to indicate the message severity. See Monitoring Database Messages in MC for further details.
You can also search and sort database messages, mark messages read or unread and delete them. You can filter messages by message type, and export messages. Refer to Searching Database Messages Managed by MC and Exporting MC-managed Database Messages and Logs.
Monitoring and Configuring Resource Pools
Use the MC Activity page to monitor resource pools. Select the resource pool you want to monitor. MC displays the following charts for the selected pool:
- Resource Usages in Pool
- Memory Usage in Node
- Average Query Execution and Query Time in Pool
- Resource Rejections in Pool
If you are a database administrator, you can click the database you want on the main window. You can then use the MC Settings tab to view and edit the resource pool parameters. Only the database administrator can monitor and configure the resource pools in Management Console.
See Monitoring Resource Pools for further information.