지금 지원 담당자와 채팅
지원 담당자와 채팅

Foglight for SQL Server 5.7.5.1 - Foglight for SQL Server Hardware Sizing Guide

Introduction to this Guide

Welcome to the Foglight for SQL Server Hardware Sizing Guide. This guide is intended to assist with determining the optimal hardware requirements and product configurations to ensure the best user experience possible.

SQL Agents - System Requirements

Use the following to determine the amount of resources required to monitor your SQL Server instances.
Resources need to be allocated over:
•
Foglight Management Server
•
Agent Manager
•
SQL PI Repository
The above monitoring elements can be either distributed over different machines (preferable in large environments) or centralized. For more information, see Deployment Use Cases.
On a VM the following need to be reserved:
•
Memory - the full amount of the required machine memory
•
CPU - the amount of CPU MHz

Foglight Management Server

 
Table 1. Foglight Management Server
Machine
 
Configuration
# of SQL Agents
Memory
CPUs (2.4 GHz)
 
Foglight JVM settings (MB)
1-100
8 GB
4 cores
 
Xms|Xmx=4096
101-200
10 GB
4 cores
 
Xms|Xmx=6144
201-400
12 GB
4 cores
 
Xms|Xmx=8192
Note the following:
•
For more than 100 agents an external repository is recommended.
•
The above sizing takes into consideration the equivalent Infrastructure agents.
•
To change the memory settings, edit the Foglight Management Server JVM settings in the server.config file located under <Foglight installation directory>\config\.
•
The maximum disk space measured is 2GB per SQL agent.

Agent Manager

It is recommended to increase the max-disk-space="102400" for following settings: upstream, upstream-verified, downstream.
Network throughput measured from the Agent Manager to the Monitored host average is 0.36Mbps per SQL agent.
Table 2. SQL Agents without SQL PI enabled.
Machine
 
Configuration
# of SQL Agents
Memory (GB)
CPUs (2.4 GHz)
 
Agent Manager
JVM settings (MB)
1-5
1 GB
1 core
 
Xms|Xmx=256
6-10
2 GB
1 core
 
Xms|Xmx=500
11-100
4 GB
2 cores
 
Xms|Xmx=2048
101-200
6 GB
4 cores
 
Xms|Xmx=4096
201-300
8 GB
6 cores
 
Xms|Xmx=6144
301-400
10 GB
8 cores
 
Xms|Xmx=8192
Note the following:
•
The above sizing takes into consideration the equivalent Infrastructure agents.
•
To change the memory settings, edit the Agent Manager JVM settings in the baseline.jvmargs.config file located under <Agent Manager installation directory>\state\default\config\.
Table 3. SQL Agents with SQL PI monitoring enabled
Machine
 
Configuration
# of SQL Agents
Memory
CPUs (2.4 GHz)
 
Agent Manager
JVM settings (MB)
1-5
4 GB
2 cores
 
Xms|Xmx=2048
6-10
6 GB
2 cores
 
Xms|Xmx=3072
11-50
8 GB
4 cores
 
Xms|Xmx=4096
51-100
12 GB
8 cores
 
Xms|Xmx=8192
Note the following:
•
The above sizing takes into consideration the equivalent Infrastructure agents.
•
The monitoring overhead on the SQL Server instance measured is below 2%
셀프 서비스 도구
지식 기반
공지 및 알림
제품 지원
소프트웨어 다운로드
기술 설명서
사용자 포럼
비디오 자습서
RSS 피드
문의처
라이센싱 지원가져오기
기술 지원
모두 보기
관련 문서

The document was helpful.

평가 결과 선택

I easily found the information I needed.

평가 결과 선택