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:

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:

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:

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:

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:

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.