지금 지원 담당자와 채팅
지원 담당자와 채팅

Foglight for Sybase 5.9.3.10 - 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

Configuring Sybase Login Privileges

The Sybase_MDA agent collects performance metrics using the Sybase MDA tables. This requires the Sybase login to have only the role mon_role assigned to it, as described above. The Sybase login does not need to have the role sa_role assigned to it. From Cartridge for Sybase version 5.5.8.39, the agent installs the Foglight for Sybase stored procedures during the initial activation. Therefore, if you are upgrading the Cartridge for Sybase, no action is required regarding the stored procedures. If you are installing the agent for the first time, you must perform the following pre-requisite procedure.

TIP: The file setup_mon_tables.sql contains all of the required parameters with sample values.
3
Run the rapsAdmin.sql script as the sa user.
The scripts included with the Foglight for Sybase can be found in the directory <FglAM_Home>/agents/SybaseCartridge/<version>/config/Sybase/scripts.
The above command creates two helper stored procedures: sp_fgl_addgrant and sp_fgl_adduser. In addition, the script drops previously installed stored procedures and previously created temporary tables.
4
Run the sp_fgl_adduser procedure as the sa user. For example:
The above command creates a group named foglightGroup and a user named fog123 in each database, and in the sybsystemprocs database, it grants the permission for creating procedures to that user account.
IMPORTANT: The group and user names used here (foglightGroup and fog123) are just examples, you can substitute them with more appropriate values.

The above procedure results in the new user being created (fog123 in this example) in the group foglightGroup in each database, including the model database. Having that user and group in the model database causes a creation of a temporary database using these credentials when the Sybase server is restarted.

Using a secondary database to store collected data

Foglight stores data collected by monitoring an ASE server in the default tempdb database. In case the default database fills up, it is possible to store the collected metrics in another database. The cartridge includes a set of scripts that enable this feature:

The following code block shows how to create a temporary database (questdb_temp), and bind a Foglight user (fogqdb) to that database.

Configuring the Sybase_MDA Agent for Remote Monitoring

The Sybase_MDA Agent can be configured for remote monitoring. Remote monitoring does not require a Sybase_MDA Agent instance to run on the monitoring host. The agent instance can run on another machine, provided that you point it to the monitored machine using Sybase_MDA Agent properties.

3
On the Sybase Open Client, use the dsedit tool to add an entry representing the monitored Sybase Server in the interface file.
5
Configure the Sybase_MDA Agent’s Sybase Home property to point to the Open Client home directory: %Sybase% (Windows) or $Sybase (Unix).
6
Configure the Sybase_MDA Agent’s Server Name property to point to the host name or IP address of the monitored server, as defined in dsedit.

Sybase_MDA Agent Properties

When an agent connects to the Foglight Management Server, it is provided with sets of properties that it uses to configure its correct running state.

Each agent is provided with a combination of two types of properties: agent properties and shareable properties.

Default versions of these properties are installed with the Foglight for Sybase. However, you can edit the default shareable and agent properties, configure agent properties that apply only to a specific agent instance, and create edited clones of shareable properties that are used by a subset of the agents of a certain type.

For more information about working with agent properties, see the Foglight Administration and Configuration Guide.

The Sybase_MDA Agent is shipped with default properties that can be modified to suit your system requirements.

Agent properties described in this section comprise:

On the navigation panel, under Dashboards, click Administration > Agents > Agent Properties.
In the Agent Properties dashboard, in the Namespace > Type pane, select DB_Sybase > Sybase_MDA.
On the navigation panel, under Dashboards, click Administration > Agents > Agent Status.
Figure 47. Agent Properties
관련 문서