Foglight for SQL Server (Cartridge) 5.9.3.20

SQL PI configured SQL PI not configured Manual configuration required by all users

Supported monitoring platforms Supported monitored databases Supported monitored BI services PI aggregation and retention Permissions for monitored databases

Permissions for Oracle databases

Additional configurations for Amazon Oracle RDS instances

Permissions for SQL Server databases Permissions for Sybase databases Permissions for DB2 for LUW databases

Permissions for monitored operating systems

Install the DB cartridge and DB agent

Install the DB cartridge Install a single DB agent

Install a single SQL Server or Oracle agent Install a single DB2 agent Install a single Sybase agent

Special configurations

Foglight Upgrades High Availability Federation Concentrator (Proxy)

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.

Figure 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. Sizing requirements are exclusively for Foglight components and these resources should not compete with any other resources required for the OS or applications installed on the same system.

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 1. 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 2. 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 installed. One PI repository can only be attached by at most three Foglight Agent Managers at a time.

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


	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.

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

Self Service Tools: Knowledge Base; Notifications & Alerts; Product Support; Software Downloads; Technical Documentation; User Forums; Video Tutorials; RSS Feed

Contact Us: Licensing Assistance; Technical Support; View All

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.9.3.20 - Deployment Guide

Deployment pre-requisites

Architecture

Hardware requirements

SQL PI configured