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

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.

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)* — 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)* — 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.

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.

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:

Supported monitoring platforms

Supported Platforms for the Foglight Management Server -

http://support.quest.com/technical-documents/foglight/5.9.3/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.3/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.