Chat now with support
Chat with Support

Foglight for DB2 (Cartridge) 5.9.3.20 - Hardware Sizing Guide

Recommended Hardware Settings for Running Foglight for DB2 LUW

The Monitoring DB2 LUW Database Systems: Hardware Sizing Guide is intended to assist in determining the optimal hardware requirements and product configurations to ensure the best possible user experience.

This guide provides the minimal hardware settings required for the proper functioning of the Management Server (FMS) with Foglight for DB2 LUW operation platform, when monitoring a predefined number of instances, databases, and partitions.

The guide is intended for users who want to customize Foglight for DB2 LUW’s default settings for sampling and collecting data, to suit specific requirements.

Parameters Used for Hardware Sizing

When sizing hardware, the following considerations should be taken into account:

In Number of Foglight for DB2 LUW Agents Per Management Server , the number of agents depends on the amount of memory available to the Management Server. Memory size is set in the following file:
Management Server 5.6.2 and later —
File location:
...Quest_Software\Foglight|config\server.config
Property name: server.vm.option1
Management Server version 5.5.8 and earlier —
File location:
...Quest_Software\Foglight|config\foglight.config
Property name: foglight.vm.option1
In Number of Foglight for DB2 LUW Agents Per Agent Manager , the number of agents depends on the amount of memory available to the Agent Manager. Memory size is set in the following file:
Agent Manager 5.6.10 and later —
File location:
...Quest_Software\Foglight|FglAM\state\default\baseline.jvmargs
Agent Manager versions earlier than 5.6.10 —
File location:
...Quest_Software\Foglight|FglAM\state\default\config\vm.config

Determining Requirements

First assess the size of the environment to be monitored. Then use the size of the monitored environment to identify how many Foglight for DB2 LUW agents can be hosted on an Agent Manager and a Management Server.

Determining the Size of the Monitored Environment

Environments are categorized into small, medium, and large based on the concurrent SQLs load on instances, databases, and members. To find out the number of concurrent SQLs, run the following SQL statement:

500

5,000

> 20,000

Now you can determine the number of Agent Managers and Management Servers you require.

Self Service Tools
Knowledge Base
Notifications & Alerts
Product Support
Software Downloads
Technical Documentation
User Forums
Video Tutorials
Contact Us
Licensing Assistance
Technical Support
View All
Related Documents