Foglight for SQL Server (Cartridge) 5.7.5.5

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

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

Table 1. Foglight for Databases Components


	NOTE: The product components can be either distributed over different machines — preferable in large or growing environments — or centralized.

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

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.

セルフ・サービス・ツール: ナレッジベース; 通知および警告; 製品別サポート; ソフトウェアのダウンロード; 技術文書; ユーザーフォーラム; ビデオチュートリアル; RSSフィード

お問い合わせ: ライセンスアシスタンスの取得; Technical Support; すべて表示

製品を選択してください:

サービス向上のために、「Purpose of your Chat（チャットの目的）」を記入してください。

お客様の不具合に推奨されるソリューション

Foglight for SQL Server (Cartridge) 5.7.5.5 - Deployment Guide

Foglight for Database Monitoring

Deployment Prerequisites

Architecture

Hardware Requirements