I noticed a problem with the console performance in the new version of Veeam Backup & Replication for VMware vSphere 12.2 when the PostgreSQL database is located on an external server.
The essence of the problem: when switching to the list of backup jobs, the console wait for jobs for several seconds (about 5-6 seconds). Everything else works fine. However, the slowness of the console interface is annoying.
In version 12.1, there is no such delay - neither when using an external PostgreSQL server, nor when using a local PostgreSQL server.
In version 12.2, there is a delay when using PostgreSQL on an external server. When using a local PostgreSQL server, there is no delay.
The problem is not in the settings and characteristics of the external PostgreSQL server, since I migrated the Veeam Backup v12.2 database to the server where Veeam Backup v12.1 is running (to a new database) - the situation was repeated.
Installed Veeam Backup on Windows 2022 Server. The situation does not cause any errors or problems (other than the initial reading of jobs), so there is nothing to leave for technical support
Hello
It’s hard to tell exactly why this is happening. I would start investigating the resources available on PostgreSQL server and VBR server. If everything is good, then you can check the Powershell Set-VBRSQLDatabaseServerLimits.
This cmdlet configure a few settings for VBR database on PostgreSQL to follow the best practices: https://helpcenter.veeam.com/docs/backup/powershell/set-vbrpsqldatabaseserverlimits.html?ver=120
If ater this the problem still persists, then it’s better to open a suppor case with Veeam because they will able to help to identify why this is happening.
It is important to set the Postgres optimizations as noted by Wesley above. I have not had the problem with the jobs loading using Postgres at all even before that but you need to make sure resources are allocated especially to the box with the Console.
it could be they changed the way sessions are queried, external DB always adds latency and if the queries are not parallel it get slow, fast.
If you checked the limits/settings I would definitely create a case, maybe even create a forum post on forums.veeam.com so the PM's can also check in if needed.
Glad you guys pointed this out. If you’re using the default install, it’s all good….it’s automatic. But using an external database or if you make changes to the CPU and RAM of the server, you have to run the command to update, and I have added more RAM and CPU to my server and had forgotten about this.
Comment
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.