Foglight for Sybase 6.1.0.10 - User and Reference Guide

Managing database groups

In large monitored environments that include a high number of database instances it might be useful to create separate groups of database instances that share some common attributes, and to monitor the individual groups separately. Using the Databases view on the navigation panel, it is possible to group database instances either by identifying specific database instances, or services that contain specific database objects, and adding them to the group. This view allows you to create, edit, and remove database groups, thereby serving as a filter for the list of database instances.

When grouping database instances by services, you first need to associate the database instances with services and then identify the services that contain one or more objects used by the monitored databases. For more information about services in Foglight, see the Foglight User Help.

IMPORTANT: Ensure that you already have Sybase services defined in Foglight, and that they include Sybase components.

1	On the navigation panel, under Databases, select Database Groups and click .

3	Select one or more database instances in the Available list and click to move them to the Selected list.

Alternatively, click to select all of the databases instances.

TIP: To remove database instances from Selected, use and , as required.

•	To remove a database group, select it on the navigation panel and click . When prompted, click Remove.

•	To edit the list of database instances associated with a database group, select it on the navigation panel and click . Make your changes, as required.

Exploring the state of selected database instances

Clicking a database instance in the databases table opens a cue card, which gives you more details about the selected database.

The cue card displays the following information.

Manage Thresholds Dashboard

The Manage Thresholds dashboard provides access to the list of thresholds. A topology filter is available to search for a specific set of thresholds. For more information about this dashboard, see the Administration and Configuration Help.

About the Sybase_MDA Agent

The Sybase_MDA Agent monitors the performance of the Sybase Adaptive Server Enterprise 12.5.1 and above. A unique characteristic is the ability for a user to select a “monitoring level” (called Availability Performance and Diagnostic). Each level is associated with a group of tables and their associated collection. By default, Availability and Performance tables are activated and all others are turned off. You can optionally select or clear Configuration, Performance or Space Trending to tune the agent to collect the metrics important to your environment.

In addition, all tables that can return multiple rows have a corresponding entry in the agent properties to limit the incoming data (see the Data Retrieval properties). The Limit Incoming Rows property displays a set of criteria developed to limit the amount of data written to the Foglight database. These values are used strictly to manage the amount of data written to the Foglight database and NOT to configure the Rules. Rules are still configured by registry variables.