Introduction to the SMC

This section describes the main features and functions of the SMC. The main menu has the following tabs:

The Dashboard is the first screen you see in the SMC (after logging in). It displays eight different panels that show the current state of the system. These panels are updated dynamically and mainly focus on resource utilization at the cluster and worker level.
Connect to existing databases and create new databases. Look at database users and groups and the data distribution statistics for tables.

Monitor active queries, users, and bulk loads, and monitor resource utilization in terms of memory and storage. Drill down into specific queries to look at performance statistics and query plans. Monitor the behavior of your workload management strategy and activity per resource pool.

For example, here is the graphical query plan for a specific query that was run by a client user (Monitor > Query Performance > Query Details > Plan):

Manage cluster resources, including the manager and worker nodes, hardware components, and network connectivity. Manage and configure the profiles, resource pools, and rules that define your workload management strategy. Look at system events, alerts, and database logs, using filters to find the information you need.

Configure system settings.

Configure alerts.

Download the following drivers and tools:
  • JDBC driver
  • ODBC driver
  • ADO.NET driver
  • ybtools (including ybsql, ybload, and so on)

Manage users and roles, and configure LDAP access.

Note: Yellowbrick Data recommends that you log into the SMC only with a database superuser account that is configured as a member of the Administrator role (sys_ybd_smc_admin). Use of the other SMC roles (Manager, Reporter, and Viewer) is not recommended and may result in unpredictable behavior.

Passwords for SMC users must be at least 8 characters long and contain at least one uppercase character, one lowercase character, one numeric character, and one punctuation character. Special characters are also allowed (such as @ and $).