Converse agora com nosso suporte
Chat com o suporte

Foglight for SQL Server (Cartridge) 5.9.5.20 - Deployment Guide

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®, SAP ASE®, DB2 for LUW, and Azure® SQL.

Architecture

There are three main components:

•
Foglight Management Server and Foglight 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 (also known as DB Agent) and SQL PI agents (PI repository manager agent, PI domain manager agent).
•
SQL PI Repository — A logical group which contains at most 3 PI databases (one for SQL Server, one for Oracle, and one for SSAS) under same SQL Server instance. Those PI databases are managed by the same SQL PI agent manager*. The total number of monitored instances in a single PI repository cannot exceed 300 instances.
* 
NOTE: SQL PI agent manager: The agent manager that holds PI domain manager agent(s) and PI repository manager agent. It can be the same agent manager that holds DB agents, or a dedicated one.
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 is highly recommended to reserve CPU and Memory for better performance.

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 agents refers to DB agents. The Infrastructure Cartridge (IC) agent’s resources are included within the DB agent resource calculations. Sizing requirements are exclusively for Foglight components and these resources should not compete with any other resources required for the operation system (OS) or applications installed on the same system.
Ferramentas de autoatendimento
Base de conhecimento
Notificações e alertas
Suporte a produtos
Downloads de software
Documentação técnica
Fóruns de usuário
Tutorial em vídeo
Feed RSS
Fale conosco
Obtenha assistência de licenciamento
Suporte técnico
Visualizar tudo
Documentos relacionados

The document was helpful.

Selecione a classificação

I easily found the information I needed.

Selecione a classificação