立即与支持人员聊天
与支持团队交流

Foglight for Sybase 5.7.5.40 - User and Reference Guide

Using Foglight for Sybase
Exploring the Sybase Dashboards About the Sybase_MDA Agent About the Sybase_RS Agent Generating SybaseMDA Reports
Reference About us

Managing database groups

Previous Next



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:
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.

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

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:

Exploring the state of selected database instances

Previous Next


Using Foglight for Sybase > Exploring the Sybase Dashboards > Databases Dashboard > 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

Previous Next



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

Previous Next


Using Foglight for Sybase > 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.

相关文档

The document was helpful.

选择评级

I easily found the information I needed.

选择评级