-
Titre
SQL Server Based PI architecture and Sizing Guide -
Description
This document focus on the architecture and sizing for SQL Server Based PI Repository. The sizing for other Foglight for Databases components should refer to current Foglight for Database Deployment Guide.
-
Résolution
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.
- Foglight Agent Manager — Hosts the monitoring database agents (a.k.a DB Agent) and SQL PI agent.
- SQL PI Database Repository — An SQL Server database that stores the SQL PI data that the monitoring agents collect. Currently available on Oracle and SQL Server monitoring only.
Hardware Requirements
Foglight Management Server
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*
9GB
11GB
11GB
13GB
15GB
19GB
21GB
JVM Settings**
4096MB
4096MB
4096MB
6144MB
8192MB
10240MB
14336MB
Hard Drive Space
10GB
100GB
200GB
400GB
800GB
1200GB
1600GB
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*
5GB
11GB
15GB
19GB
23GB
29GB
37GB
JVM Settings**
2048MB
7168MB
9216MB
13312MB
17408MB
23552MB
31744MB
Hard Drive Space
2GB
5GB
10GB
20GB
40GB
60GB
80GB
SQL PI Database Repository
Microsoft SQL Server Version and Edition
SQL Server 2016 SP1 or higher Standard or Enterprise SQL Server sizing
Number of Agents <50 <100 <200 <300 CPUs (2.4GHz)* 4 cores 4 cores 6 cores 6 cores RAM* 20GB 32GB 42GB 60GB Maximum SQL Server Memory 16384MB 26624MB 36864MB 55296MB Hard Drive Space** Total 110GB
One disk
- Raw Data*: 10GB
- Long-Term Data*: 100GB
Total 220GB
Two disks
- Disk 1 for raw data: 20GB
- Disk 2 for long-term data: 200GB
Total 375GB
Two disks
- Disk 1 for raw data: 25GB
- Disk 2 for long-term data: 350GB
Total 535GB
Two disks
- Disk 1 for raw data: 35GB
- Disk 2 for long-term data: 500GB
RAM*- for a virtual machine the memory reservation is highly recommended for better performance.
Hard Drive Space* - the disk RPM is 15K. For 100 DB agents or above, RAID 5 disk (IOPS is above 1.2K) is required if the performance is downgraded. The transaction log and operation system storage are not included. Normally the transaction long file size is 2GB and it depends on a database maintenance job.
Raw Data* - raw performance data which is stored in 1-minute SQL PI tables.
Long-Term Data* - the low granularity data roll-up from raw data. Long-term (non 1-minute) data is stored in the primary filegroup in the SQL PI repository database. It is highly recommended to store database transaction log and temp database in a different disk with long-term data for better disk IO.Antivirus Exclusions
Antivirus exclusions is required for the Microsoft SQL Server. Please reference Microsoft’s official article How to choose antivirus software to run on computers that are running SQL Server for more details.
All-in-One Installation
This section is new added. In the All-in-One installation, the Foglight Agent Manager is embedded. The Foglight Database Repository and SQL PI Database Repository are in the same SQL Server instance.
Number of Agents <20 CPUs (2.4GHz)
6 cores RAM*
36GB FMS JVM Settings 4096MB FGLAM JVM Settings 6144MB Maximum SQL Server Memory
20480MB
Hard Drive Space*
Total 160GB
Two disks
- Disk 1 for SQL PI Repository: 60GB
- Disk 2 for Foglight Repository: 100GB
RAM*- for a virtual machine the memory reservation is highly recommended for better performance.
Hard Drive Space* - the disk RPM is 15K. Extra hard drive space is needed for operating system storage.
Manual configuration required by all users
SQL Server Based PI Repository, Maximum SQL Server Memory
Login the SQL Server through SSMS client. Edit the "Maximum server memory" in Server Properties dialog.
Permissions for SQL Server Based PI Repository Database
If you are using SQL Server Based PI Repository®, ensure that these permissions are set.
Table 11. SQL Server Permissions for Create a New PI Repository Database
Server Role Granted for dbcreator Creating PI Repository Database Table 12. SQL Server Permissions for Using an Existing PI Repository Database
Instance Level Database Role VIEW ANY DATABASE Granted for:Select Existing Database db_ownerGranted for:Insert/delete PI records -
Identifiant du défaut
FOG-7654