Chatee ahora con Soporte
Chat con el soporte

Foglight for SQL Server (Cartridge) 5.9.3.10 - Deployment Guide

Deployment pre-requisites

Welcome to the Foglight for Databases Deployment Guide. This guide provides the pre-requisites for optimal deployment, to ensure the best user experience possible.

This section describes important deployment information required to monitor the leading RDBMS: Oracle®, SQL Server®, Sybase®, and DB2 for LUW. The information in this guide applies to all 5.7.5.x and 5.9.3.10 releases.

Architecture

There are three main components:

Foglight Management Server and Foglight Database Repository — Responsible for managing, alerting and viewing the collected data. Both components can be set to run on the same machine or reside on separate machines.
Agent Manager — Hosts the monitoring database agents.
SQL PI Repository — An embedded repository which stores the SQL PI data that the monitoring agents collect. Currently available on Oracle and SQL Server monitoring only.

Hardware requirements

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 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.

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.

Herramientas de autoservicio
Base de conocimientos
Notificaciones y alertas
Soporte de productos
Descargas de software
Documentación técnica
Foros de usuarios
Tutoriales en video
Aviso de actualizaciones de páginas web (RSS)
Comuníquese con nosotros
Obtenga asistencia con las licencias
Soporte Técnico
Ver todos
Documentos relacionados

The document was helpful.

Seleccionar calificación

I easily found the information I needed.

Seleccionar calificación