Foglight for SQL Server (Cartridge) 5.7.5.5

Table 2. Foglight Management Server with SQL PI configured
Number of Agents	<5	<50	<100	<200	<400	<600	<800
CPUs (2.4GHz)*	2 cores	4 cores	4 cores	4 cores	4 cores	6 cores	8 cores
RAM*	6GB	8GB	8GB	10GB	12GB	16GB	18GB
JVM Settings**	4096MB	4096MB	4096MB	6144MB	8192MB	10240MB	14336MB
Hard Drive Space	10GB	100GB	200GB	400GB	800GB	1200GB	1600GB

CPUs (2.4GHz)* — for a virtual machine the CPU allocation must be reserved. The reservation is expressed in MHz

RAM*- for a virtual machine the memory allocation must be reserved.

Foglight Agent Manager

Table 3. Foglight Agent Manager


Number of Agents	<5	<50	<100	<200	<400	<600	<800
CPUs (2.4GHz)*	1 core	4 cores	8 cores	8 cores	10 cores	12 cores	14 cores
RAM*	2GB	8GB	12GB	16GB	20GB	26GB	34GB
JVM Settings**	1024MB	6144MB	8192MB	12288MB	16384MB	22528MB	30720MB
Hard Drive Space	2GB	5GB	10GB	20GB	40GB	60GB	80GB


	IMPORTANT: If you are monitoring more than 70 agent running on Windows system, the monitored hosts should be configured to use WinRM. Monitoring Analysis services is supported only on Agent Managers running on Windows which must have a version of .NET 3.5 or higher installed.

CPUs (2.4GHz)* — for a virtual machine the CPU allocation must be reserved. The reservation is expressed in MHz

RAM*- for a virtual machine the memory allocation must be reserved.

SQL PI Repository

Table 4. SQL PI Repository


Number of Agents	<5	<50	<100	<200	<400	<600	<800
CPUs (2.4GHz)*	1 core	4 cores	4 cores	6 cores	8 cores	12 cores	16 cores
RAM*	4GB	10GB	14GB	20GB	24GB	30GB	36GB
Hard Drive Space	10GB	100GB	200GB	400GB	800GB	1200GB	1600GB

CPUs (2.4GHz)* — for a virtual machine the CPU allocation must be reserved. The reservation is expressed in MHz

RAM*- for a virtual machine the memory allocation must be reserved.

SQL PI not configured

The table defines the Hardware requirements based on the number of monitoring agents.

After locating your hardware requirements in the tables, ensure that you complete the manual JVM Setting configuration as described in:

•

Manual Configuration Required by all Users

Foglight Management Server

Table 5. Foglight Management Server


Number of Agents	<5	<100	<200	<400	<600	<800
CPUs (2.4GHz)*	2 cores	4 cores	4 cores	4 cores	6 cores	8 cores
RAM*	6GB	8GB	10GB	12GB	16GB	18GB
JVM Settings**	4096MB	4096MB	6144MB	8192MB	10240MB	14336MB
Hard Drive Space	10GB	200GB	400GB	800GB	1200GB	1600GB

CPUs (2.4GHz)* — for a virtual machine the CPU allocation must be reserved. The reservation is expressed in MHz

RAM*- for a virtual machine the memory allocation must be reserved.

Foglight Agent Manager

Table 6. Foglight Agent Manager


Number of Agents	<5	<100	<200	<400	<600	<800
CPUs (2.4GHz)*	1 core	2 cores	4 cores	4 cores	6 cores	8 cores
RAM*	1GB	4GB	6GB	10GB	14GB	18GB
JVM Settings**	256MB	2048MB	4096MB	8192MB	12288MB	16384MB
Hard Drive Space	2GB	5GB	10GB	20GB	30GB	40GB


	IMPORTANT: If you are monitoring more than 70 agent running on Windows system, the monitored hosts should be configured to use WinRM.

CPUs (2.4GHz)* — for a virtual machine the CPU allocation must be reserved. The reservation is expressed in MHz

RAM*- for a virtual machine the memory allocation must be reserved.

SQL PI not configured

Identify your hardware requirements, which are determined by whether SQL PI is configured and by the number of monitoring agents.

•

SQL PI configured

•

SQL PI not configured


	NOTE: The Numbers of agent refers to DB agents. The IC agents resources are calculated within the DB agents.

SQL PI configured

SQL PI is available only for Oracle, SQL Server and SQL Server BI (Analysis services). These tables define the Hardware requirements for each server based on the number of monitoring agents

After locating your hardware requirements in the tables, ensure that you complete the manual JVM Setting configuration as described in:

•

Manual Configuration Required by all Users

Foglight Management Server

Table 2. Foglight Management Server with SQL PI configured
Number of Agents	<5	<50	<100	<200	<400	<600	<800
CPUs (2.4GHz)*	2 cores	4 cores	4 cores	4 cores	4 cores	6 cores	8 cores
RAM*	6GB	8GB	8GB	10GB	12GB	16GB	18GB
JVM Settings**	4096MB	4096MB	4096MB	6144MB	8192MB	10240MB	14336MB
Hard Drive Space	10GB	100GB	200GB	400GB	800GB	1200GB	1600GB

CPUs (2.4GHz)* — for a virtual machine the CPU allocation must be reserved. The reservation is expressed in MHz

RAM*- for a virtual machine the memory allocation must be reserved.

Foglight Agent Manager

Table 3. Foglight Agent Manager


Number of Agents	<5	<50	<100	<200	<400	<600	<800
CPUs (2.4GHz)*	1 core	4 cores	8 cores	8 cores	10 cores	12 cores	14 cores
RAM*	2GB	8GB	12GB	16GB	20GB	26GB	34GB
JVM Settings**	1024MB	6144MB	8192MB	12288MB	16384MB	22528MB	30720MB
Hard Drive Space	2GB	5GB	10GB	20GB	40GB	60GB	80GB


	IMPORTANT: If you are monitoring more than 70 agent running on Windows system, the monitored hosts should be configured to use WinRM. Monitoring Analysis services is supported only on Agent Managers running on Windows which must have a version of .NET 3.5 or higher installed.

CPUs (2.4GHz)* — for a virtual machine the CPU allocation must be reserved. The reservation is expressed in MHz

RAM*- for a virtual machine the memory allocation must be reserved.

SQL PI Repository

Table 4. SQL PI Repository


Number of Agents	<5	<50	<100	<200	<400	<600	<800
CPUs (2.4GHz)*	1 core	4 cores	4 cores	6 cores	8 cores	12 cores	16 cores
RAM*	4GB	10GB	14GB	20GB	24GB	30GB	36GB
Hard Drive Space	10GB	100GB	200GB	400GB	800GB	1200GB	1600GB

CPUs (2.4GHz)* — for a virtual machine the CPU allocation must be reserved. The reservation is expressed in MHz

RAM*- for a virtual machine the memory allocation must be reserved.

The table defines the Hardware requirements based on the number of monitoring agents.

After locating your hardware requirements in the tables, ensure that you complete the manual JVM Setting configuration as described in:

•

Manual Configuration Required by all Users

Foglight Management Server

Table 5. Foglight Management Server


Number of Agents	<5	<100	<200	<400	<600	<800
CPUs (2.4GHz)*	2 cores	4 cores	4 cores	4 cores	6 cores	8 cores
RAM*	6GB	8GB	10GB	12GB	16GB	18GB
JVM Settings**	4096MB	4096MB	6144MB	8192MB	10240MB	14336MB
Hard Drive Space	10GB	200GB	400GB	800GB	1200GB	1600GB

CPUs (2.4GHz)* — for a virtual machine the CPU allocation must be reserved. The reservation is expressed in MHz

RAM*- for a virtual machine the memory allocation must be reserved.

Foglight Agent Manager

Table 6. Foglight Agent Manager


Number of Agents	<5	<100	<200	<400	<600	<800
CPUs (2.4GHz)*	1 core	2 cores	4 cores	4 cores	6 cores	8 cores
RAM*	1GB	4GB	6GB	10GB	14GB	18GB
JVM Settings**	256MB	2048MB	4096MB	8192MB	12288MB	16384MB
Hard Drive Space	2GB	5GB	10GB	20GB	30GB	40GB


	IMPORTANT: If you are monitoring more than 70 agent running on Windows system, the monitored hosts should be configured to use WinRM.

CPUs (2.4GHz)* — for a virtual machine the CPU allocation must be reserved. The reservation is expressed in MHz

RAM*- for a virtual machine the memory allocation must be reserved.

Manual Configuration Required by all Users

Foglight Management Server, JVM Settings **

Edit the server.config file located under the <Foglight installation directory>\config directory.

For 4096MB, add the following lines:

server.vm.option0 = "-Xms4096m";

server.vm.option1 = "-Xmx4096m";

Foglight Agent Manager, JVM Settings **

Edit the baseline.jvmargs.config file located under the <Agent Manager installation directory>\state\default\config\ directory

For 2048MB, add the following lines:

vmparameter.0 = "-Xms2048m";

vmparameter.1 = "-Xmx2048m";

Other settings

For number of agents > 50, edit these settings:

•

Data submission channel — edit the fglam.config.xml file located under the <Agent Manager installation directory>\state\default\config\ directory

Alter the following lines:

config:upstream attribute max-disk-space="102400"

config:downstream attribute max-disk-space="102400"

•

Number of OS connections — Increase the number of allowed OS connections

vmparameter.2 = “Dcom.quest.connection.regulator.maxActiveConnectionsCap=1024”;

Supported Monitoring Platforms

Supported Platforms for the Foglight Management Server -

http://documents.quest.com/foglight/5.7.5/system-requirements-and-platform-support-guide/supported-platforms/supported-platforms-for-the-management-server#

Supported Platforms for Foglight Agent Manager

http://documents.quest.com/foglight/5.7.5/system-requirements-and-platform-support-guide/supported-platforms/supported-platforms-for-the-agent-manager#

Supported Platforms for SQL PI Repository


	NOTE: Linux is the recommended platform for both Oracle and SQL Server monitoring. Exclude the SQL PI repository directory (named InfoBright) from real-time scanning (for example, Antivirus software).

Table 7. Supported Platforms for SQL PI Repository
Operating System	Version	OS Architecture	32-bit	64-bit
CentOSLinux	6.x 7.x	x86-64 x86-64		+ +
Red Hat Enterprise Linux	6.x 7.x	x86-64 x86-64		+ +
SUSE Linux	11 12	x86-64 x86-64		+ +
Microsoft Windows	Server 2008 and above	x86-64 x86-64		+ +

Please select your product:

To serve you better, please complete the Purpose of your Chat:

Recommended Solutions for Your Problem

Foglight for SQL Server (Cartridge) 5.7.5.5 - Deployment Guide

SQL PI configured

SQL PI not configured

Manual Configuration Required by all Users

Supported Monitoring Platforms