Foglight for Sybase 5.7.5.40 - User and Reference Guide

Managing database groups

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.

To filter the list of databases by selecting services:

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

1	To create a Sybase service, using the Service Builder, create a new category with a DB tier and add the applicable Sybase objects to it. For more information about Foglight services, see the Foglight User Help.

2	On the navigation panel, under Databases, click the box on the right of Group by and choose Services.

The Databases view refreshes, showing groups of monitored resources created using the Service Builder dashboard, and containing the Foglight for Sybase database topology. The SLC column, also appearing in this view, indicates the current availability of each service over a given period of time.

3	Select the services that are associated with the database instances that you want to see listed.

The display area refreshes, showing the database instances whose objects are monitored with the selected services.

Figure 44. Selected Services

To create a database sub-group:

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

The Add Sub Group dialog box appears.

2	In the Name box, type the name of the sub-group. Optionally, provide the sub-group’s description in the Description box.

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.

4

Click Ok.

The sub-group name appears in the list and the database instances you selected in Step 3 appear in the list of databases.

To manage database groups:

•	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

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.

Figure 45. Cue Card details

The cue card displays the following information.

 

Table 68. Cue Card Description

Data	Description
General
DB type	Specifies the type of the monitored database instance.
Sampling interval	The length of time between data samples.
Last sample time	The time when the last data sample occurred.
Alarms
	The number of Fatal alarms associated with the selected database instance.
	The number of Critical alarms associated with the selected database instance.
	The number of Warning alarms associated with the selected database instance.
Configuration
Online engines	The number of engines associated with the selected database instance that are currently online.
Physical memory	The amount of physical memory available to the selected database instance.
Performance
Connection in use	The number of connections handled by the selected database instance.
Active processes	The number of processes associated with the selected database instance that are currently taking place.
Engines vs. Host Utilization
Avg. Engine Utilization	The percentage of average engine utilization.
Host CPU Load	The percentage of the host’s CPU usage.
Host Memory Utilization	The amount of memory consumed by all OS processes (including the database instance process). This includes both RAM resident memory and swapped memory.
Storage
Number of devices	The number of devices associated with this database instance.
Number of databases	The number of databases running on the host.
Total	The total amount of the space allocated to the devices.
Usage	The percent of the space allocated to the devices that is currently being used.
Total Wait Events
Graph	The wait time for this event in seconds plotted over time.
Home Page	Links to the MDA Home Page Dashboard.

 

Manage Thresholds Dashboard

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.

Figure 46. Manage Thresholds Dashboard

Manage Thresholds Table

 

Table 69. Manage Thresholds Table Description

Name	Description
Metric	The metric threshold name. You can edit a threshold by clicking on this name.
Topology Type	The topology type to which this threshold is assigned.
Summary	The summary of the threshold properties.

About the Sybase_MDA Agent

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.