立即与支持人员聊天
与支持团队交流

Foglight for SQL Server (Cartridge) 5.9.3.20 - 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. 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.

自助服务工具
知识库
通知和警报
产品支持
下载软件
技术说明文件
用户论坛
视频教程
RSS订阅源
联系我们
获得许可 帮助
技术支持
查看全部
相关文档

The document was helpful.

选择评级

I easily found the information I needed.

选择评级