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

Foglight for SQL Server (Cartridge) 5.9.5.10 - Deployment Guide

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:

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.

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

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.

WARNING: 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). For a virtual machine the CPU and memory allocations must be reserved. Recommended configuration would be a separate FMS and FglAM where PI repository resides on and a separate FgIAM where DB Agents resides on the different host machine.

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:

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.

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

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

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";

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";

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
Number of OS connections — edit the baseline.jvmargs.config file located under the <Agent Manager installation directory>\state\default\config\ directory

Supported monitoring platforms

Supported Platforms for the Foglight Management Server

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

Supported Platforms for Foglight Agent Manager

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

Supported Platforms for Foglight Agent Manager with PI Configured

Refer to Table 6 Supported Platforms for SQL PI Repository.

Supported Platforms for SQL PI Repository

WARNING: 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). For a virtual machine the CPU and memory allocations must be reserved.

CentOSTM Linux®

6.x

7.x

x86-64

x86-64

 

+

+

Red Hat® Enterprise Linux

6.x

7.x

x86-64

x86-64

 

+

+

SUSE Linux

11

12

13

14

x86-64

x86-64

x86-64

x86-64

 

+

+

+

+

Microsoft® Windows®

Windows Server 2003, 2008, 2012, and 2016

x86-64

x86-64

 

+

+

Documents connexes

The document was helpful.

Sélectionner une évaluation

I easily found the information I needed.

Sélectionner une évaluation