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.
3 |
4 |
IMPORTANT: The group and user names used here (foglightGroup and fog123) are just examples, you can substitute them with more appropriate values. |
1 |
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.
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.
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. |
For more information about working with agent properties, see the Foglight Administration and Configuration Guide.
Agent properties described in this section comprise:
• |
On the navigation panel, under Dashboards, click Administration > Agents > Agent Properties. |
• |
On the navigation panel, under Dashboards, click Administration > Agents > Agent Status. |
© ALL RIGHTS RESERVED. Termini di utilizzo Privacy Cookie Preference Center