Tchater maintenant avec le support
Tchattez avec un ingénieur du support

Foglight for SQL Server (Cartridge) 5.9.7.10 - Deployment Guide

Install a single SQL Server or Oracle agent

To install a single SQL Server or Oracle agent:
1
On the Foglight navigation panel, click Homes > Databases.
2
Click Monitor > <DB type> in the lower left corner of the Databases View.
The Monitor Instance dialog box appears.
3
Choose the agent manager on which the agent is running. The default is the agent manager with the least agents installed.
4
On the Monitor Instance pane, provide connection details.
5
Select an Alarm Sensitivity Level to determine what level of alarms the system stores and displays for this instance.
6
Optional SQL PI- In the Monitoring Extensions pane, click the SQL PI monitoring extension. You are prompted to choose the Agent Manager on which the SQL PI repository is installed.
7
Optional OS. In the Monitoring Extensions pane, click the Operating System link. To configure the extension, choose the connection details of the host on which the SQL Server instance is running.
8
Optional VM. In the Monitoring Extensions pane, click Collect VM statistics. To configure the extension, select the connection details of the vCenter® or ESX® on which the SQL Server instance is running.
9
Click Monitor.

Install a single DB2 agent

To install a DB2 agent:
1
On the Foglight navigation panel, click Homes > Databases.
2
Click Monitor > DB2 in the lower left corner of the Databases View.
The Monitor Instance dialog box appears.
3
Follow the prompts to configure an agent to monitor the DB2 host, instance, and databases. For help with options, click the 'i' icon.
IMPORTANT:
1. When DB2 authentication type is CLIENT, the login credentials provided during installing for the database agent are overwritten with the fglAM user. Ensure that the fglAM user can connect to the DB2 instance and has all the relevant permissions as described in the Permissions section.
2. When trying to connect to DB2 instance with SSL, import SSL certificate into FglAM first. Go to directory <FglAM_HOME>/agents/DB_DB2/<DB2_version>-<DB2_version>-<BUILD_ID>/lib/, run command certificate-<DB2_version>-ksh.ksh(certificate-<DB2_version>-bat.bat)

Install a single SAP ASE agent

After installing the cartridge, update the SAP ASE account for Foglight by manually downloading and running the scripts DB_Sybase_FirstRun_Scripts located under Foglight > Dashboards > Administration > Agents > Cartridges > Components for Download.

1
Run script rapsAdmin.sql as sa user. This script creates only two helper stored procedures:
•
sp_fgl_addgrant and sp_fgl_adduser
•
isql -Usa -Ppassword -SserverName -i rapsAdmin.sql -o rapsAdmin.out
2
Run these scripts to complete the upgrade and to display the correct information on the new dashboards. For script execution instructions, see “Configuring SAP ASE Login Privileges” in the Foglight for SAP ASE User and Reference Guide. Failed to upgrade the user account will result in broken agent instances.
3
Once you have installed the cartridge, deploy the agent package. For complete information, see “Deploying agent packages to monitored hosts” in the Foglight Administration and Configuration Help. After upgrading the cartridge and starting the agent, the Agent log will display the database version, cartridge version, EBF level, and so on.
•
When you start using a new SAP ASE user or when the SAP ASE cartridge is upgraded with a new version, the stored procedures will be automatically reinstalled.
•
For monitoring Replication Server (RS) instance, you need to configure the path to the sql.ini file in the ASP with all the servers participating in the RS Agent. You can take the sql.ini file which exists in the Replication Server as an example.
•
When creating a new agent, it is recommended to clone all the default lists to new lists which will be used only for this agent – in the same way you did with the legacy cartridge.
Post Installation Instructions

After installing the Cartridge for SAP ASE, perform the configuration steps below:

To create a new SAP ASE user, run the following scripts as sa user (use your username and password).

exec sp_addlogin 'username' , 'password' , sybsystemprocs
exec sp_fgl_adduser 'username' , 'foglightGroup'

Grant mon_role to 'username'

* 
NOTE: The new user should have only one role: mon_role.

Install an Azure SQL DB agent

To install an Azure SQL DB agent:
1
On the Foglight navigation panel, click Homes > Databases.
2
Click Monitor > Azure SQL in the lower left corner of the Databases View.
The Monitor Azure SQL Database dialog box appears.
3
Follow the prompts to configure an agent to monitor the Azure SQL host, instance, and databases. For help with options, click the 'i' icon.
Documents connexes

The document was helpful.

Sélectionner une évaluation

I easily found the information I needed.

Sélectionner une évaluation