Chat now with support
Chat with Support

Foglight for SQL Server (Cartridge) 5.7.5.5 - Deployment Guide

Foglight for Database Monitoring

Deployment Guide
Welcome to the Foglight for Databases Deployment Guide. This guide provides the prerequisites for optimal deployment.
This guide refers to monitoring the leading RDBMS: Oracle, SQL Server, Sybase and DB2 for LUW.
Database Deployment Guide
May 2016
Version 5.7.5.x
 
 

Deployment Prerequisites

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

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating