Foglight for SQL Server (Cartridge) 5.9.4.10

Chatee ahora con Soporte

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

Deployment in Centralized vs Distributed

In monitoring environments that exceed a total of 20 agents, a distributed installation is necessary:

•

The FMS should be installed on a dedicated server.

•

External FglAMs should be used for DB Agents and with each installed on a dedicated server.

•

Each instance of the SQL PI repository should be installed on a separate server.

In All-in-One installations on virtual machines (VMs), the machine must have all of the CPU and Memory requirements fully reserved.

Once the total number of agents exceeds 20, All-in-One installations are no longer supported.

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.