Chat now with support
Chat mit Support

Foglight for SQL Server (Cartridge) 5.9.5.10 - Deployment Guide

Install the DB cartridge

Foglight for database cartridges run on the Foglight Management Server, which is the operation framework. Therefore, Foglight Management Server must be installed before installing a database cartridge.

To install the Foglight for <database> cartridge:
1
Copy the cartridge car file included in the installation media to your local computer. This file is named as follows:
•
For Foglight for DB2 LUW: DB_DB2-5_9_5_10.car
•
For Foglight for Oracle: DB_Oracle-5_9_5_10.car
•
For Foglight for SQL Server: DB_SQL_Server-5_9_5_10.car
•
For Foglight for Azure SQL Database: DB_Azure-5_9_5_10.car
2
Log in to the Foglight browser interface.
3
On the navigation panel, click Dashboards > Administration > Cartridges > Cartridge Inventory.
4
On the Cartridge Inventory dashboard, click Install Cartridge to find the CAR file on your local computer.
5
Click Install Cartridge.

Install a single DB agent

For details, see the following topics:

•
Install a single SQL Server or Oracle agent
•
Install a single DB2 agent
•
Install a single Sybase agent
•
Install an Azure SQL DB agent

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)
Verwandte Dokumente

The document was helpful.

Bewertung auswählen

I easily found the information I needed.

Bewertung auswählen