1. Überprüfen Sie auf Updates

Please check regularly for updates, as most of them offer performance improvements. We recommend you to apply ServerGenius updates out of Working Hours since the update may perform long running background operations on the database.

ServerGenius la dernière mise à jour est toujours disponible à partir de ce qui suit enlace directo .

2. Appliquer la configuration recommandée

Una base de datos siempre utilizará todos los recursos informáticos disponibles para completar las solicitudes lo antes posible. Por lo tanto, se recomienda dimensionar el servidor ServerGenius de acuerdo con su uso.

Veuillez trouver ci-dessous nos recommandations en fonction du nombre de serveurs surveillés :

Serveurs surveillés	CPU	Memoria (RAM)
1-2	2	8
3-4	4	16
5+	8	32

Installing ServerGenius sur un disque dur de type SSD est recommandé pour de meilleures performances.

Also, you may need to allocate additional disk space for ServerGenius Server, depending on the number of servers and websites monitored, and coincidentally the amount of data collected and stored in the PostgreSQL database.

Finally, please note that it is generally a good idea to run a monitoring application such as Server Genius on a dedicated server. This prevents other applications from reducing available resources.

3. Personnaliser la configuration de la base de données

ServerGenius se basa en PostgreSQL database engine. The PostgreSQL database configuration file can be customized based on the server’s hardware configuration to enable optimal performance.

The following information is required to build your custom configuration file:

• Memoria (RAM)
• Nombre de CPUs
• Tipo de almacenamiento (HDD, SSD o SAN)

Varios sitios web pueden generar el archivo de configuración más relevante basado en esta información, como https://pgtune.leopard.in.ua .

Pour exemple, veuillez trouver ci-dessous une configuration recommandée pour un serveur avec 2 CPU et 8 Go de RAM utilisant un stockage HDD :

DB Version: 10

Total Memory (RAM): 8 GB

CPUs num: 2

Data Storage: hdd

max_connections = 20 shared_buffers = 512MB effective_cache_size = 6GB maintenance_work_mem = 512MB checkpoint_completion_target = 0.7 wal_buffers = 16MB default_statistics_target = 100 random_page_cost = 4 work_mem = 128MB min_wal_size = 1GB max_wal_size = 2GB max_worker_processes = 2 max_parallel_workers_per_gather = 1 max_parallel_workers = 2

Note: ServerGenius uses PostgreSQL version 10

These settings should be replaced in the database configuration file located at: C:\Program Files (x86)\RDS-Tools\ServerGenius\pgsql\data\postgresql.conf Then, the service ServerGeniusDatabase must be restarted for the changes to take effect.

4. Reconstruir índices de base de datos

A database index is a data structure that improves the speed of data retrieval operations on a database. Indexes are used to quickly locate data without having to search every row in a database table every time a database table is accessed.

We recommend you to rebuild database indexes periodically in order to speed up data access. This maintenance task may take a while and we recommend you to proceed outside of Working Hours. From an elevated command prompt, navigate to the ServerGenius\pgsql\bin directory and enter the following command:

C:\Program Files (x86)\RDS-Tools\ServerGenius\pgsql\bin> psql -U postgres -p 7779 -d servergenius -c “REINDEX DATABASE servergenius”

Cuando se le pida una contraseña, escriba mot de passe Esta operación puede tardar hasta una hora y puede aumentar drásticamente el rendimiento.

5. Contactez notre support client

If all the above recommendations failed to provide you an acceptable experience with ServerGenius, please do not hesitate to contact our customer support and raise a ticket at https://terminalserviceplus.freshdesk.com We will be happy to help you regain control of your ServerGenius installation.

In order to facilitate our technical support and to reproduce your issue, we might ask you for an export of your database.

In order to do so, from an elevated command prompt, navigate to the ServerGenius\pgsql\bin directory and enter the following command:

C:\Program Files (x86)\RDS-Tools\ServerGenius\pgsql\bin> pg_dump.exe -p 7779 -U postgres servergenius export1.dump

Cuando se le pida una contraseña, escriba mot de passe .

Once the export has finished, please share the file located at C:\Program Files (x86)\RDS-Tools\ServerGenius\pgsql\export1.dump con cualquier servicio de transferencia de archivos.