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.

 
* 
NOTE: The document provides requirements for 32-bit and 64-bit environments.

Parameters Used for Hardware Sizing

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

•
The maximum number of agents (that is, instances) that a single Management Server can accommodate in version 5.5.8 and later is 400.
•
The ratio between Foglight for DB2 LUW agents and units in the Foglight unit system depends on the version of the Management Server as follows:
•
Management Server 5.6.10 and later — see Number of Foglight for DB2 LUW Agents Per Management Server .
•
Management Server 5.6.2 up to 5.6.7.x — each agent represents 10 units
•
Management Server 5.5.8 up to 5.6.0 — each agent represents 6 units
•
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:

select
dbpartitionnum, sum(total) as total_agents,
sum(active) as active
from
(
select
dbpartitionnum,
sum(num_assoc_agents) as total,
sum(case when appl_status not in ('CONNECTED','DECOUPLED','UOWWAIT') then num_assoc_agents else 0 end) as active
from
TABLE(SNAP_GET_APPL_INFO(CAST(current server AS VARCHAR(128)),CAST(-2 AS INT))) AS T
group by dbpartitionnum
) as agents
group by dbpartitionnum
 
 
Environment Size
Concurrent SQL statements
Small

500

Medium

5,000

Large

> 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
RSS Feed
Contact Us
Licensing Assistance
Technical Support
View All
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating