Servoy Server performance problem

Questions and Answers on installation, deployment, management, locking, tranasactions of Servoy Application Server

Servoy Server performance problem

Postby caspar » Wed Feb 05, 2020 11:19 am

Hi there, I'm starting this topic with a couple of questions as I am completely unknown to Servoy. We are in charge of maintaining servers and hardware. We are facing some performance issues that occur on a regular basis without anyone knowing why it happens. It seems after a server restart everything works Ok again. It could be a days of good running or a couple of hours before everyone experiences a slow responding Servoy again.

Servoy config:
-Windows Server 2019 Standard x64 virtual machine, 4 XEON CPU cores, 32GB RAM, SSD storage. Servoy version 8.1.4 -releaseNumber 3035 + Microsoft SQL Standard 2014 (both on same machine)
-other virtual machines on the same host (Hyper-V) are performing just fine, no problems.

Problem:
We have around 20 to 30 workstations (mostly Windows 10) running Servoy. On a regular basis almost all people at work will experience a non responding Servoy client. If they click somewhere nothing happens. If you wait like 1 or 2 minutes everything pops up again and continues to work. No clear errors on client side.

What we see on the server:
The SQL instance has been checked by a database expert and he concluded that SQL is performing great.Mem and cpu usage is fine. We can rule out SQL for now. However in the Servoy admin page we can see long running queries of random users. Sometimes queries that take up to 3 to 5 minutes. The data requested has already been given back to Servoy by the database. It seems that the data from the SQL database is provided back to Servoy within milliseconds but still these queries are visible in the database performance section in Servoy. We also see that Servoy uses about 25 to 40 percent CPU all the time when the system responds slow. It feels like Servoy has trouble keeping up somehow creating some sort of queue when a lot of users are at work. We don't know if this is even possible but that is how it feels to users.

What we would like to find out:
General tips on improving the speed of the application server. We know Servoy is not multithreaded so it seems to only want to use 1 CPU core.
The SQL database is currently connected as "Cursor" instead of "Direct", as I understand this method might be outdated causing more traffic between the database and the Servoy Application Server. Are there any other things to check and optimize?

At this moment we are unable to update to a newer version as the Servoy dev is unavailable for now.

Hope you can provide us with some handles to look at.
caspar
 
Posts: 2
Joined: Wed Feb 05, 2020 10:38 am

Re: Servoy Server performance problem

Postby rvanderburg » Wed Feb 05, 2020 11:30 am

Caspar,

Which Servoy customer is this for? We can setup a call to look through the setup?
rvanderburg
Site Admin
 
Posts: 68
Joined: Wed May 04, 2011 10:28 am

Re: Servoy Server performance problem

Postby jcompagner » Wed Feb 05, 2020 11:40 am

What clients are you using?
The server part of Servoy is fully multi threaded. One client by itself is for the most part single threaded, but all clients are handled over multiply threads.

Are you sure those hickups are not Java Full Garbage Collection events? Especially with those huge memory heaps (32GB) this should be tweaked correctly
look here: https://wiki.servoy.com/display/DOCS/Memory+Management (under the section big heaps)
Johan Compagner
Servoy
User avatar
jcompagner
 
Posts: 8452
Joined: Tue May 27, 2003 7:26 pm
Location: The Internet

Re: Servoy Server performance problem

Postby caspar » Wed Feb 05, 2020 11:48 am

jcompagner wrote:What clients are you using?
The server part of Servoy is fully multi threaded. One client by itself is for the most part single threaded, but all clients are handled over multiply threads.

Are you sure those hickups are not Java Full Garbage Collection events? Especially with those huge memory heaps (32GB) this should be tweaked correctly
look here: https://wiki.servoy.com/display/DOCS/Memory+Management (under the section big heaps)

Thanks, we will look into that, here is our mem config as stated by the admin page

System Information
Code Cache Non-heap memory: allocated=37376K, used=36777K, max=245760K
Metaspace Non-heap memory: allocated=81152K, used=79679K, max=614400K
Compressed Class Space Non-heap memory: allocated=10496K, used=10066K, max=1048576K
Heap memory: allocated=4093952K, used=2681450K, max=12383744K
Number of Processors: 4
caspar
 
Posts: 2
Joined: Wed Feb 05, 2020 10:38 am


Return to Servoy Server

Who is online

Users browsing this forum: No registered users and 4 guests

cron