Speed problem on servers

Hello,
we have installed ATE on PCs and on servers. When menu items are called, the speed at which the data is displayed is acceptable on a PC. It takes only a few seconds. On servers, depending on the menu item, it is very slow.
For example, we have a record where an estimated 80 to 90 fields are loaded. On a PC it takes about 7 seconds to display, on a server it takes about 3 minutes. Measured from clicking the icon to the display of all database fields. The display of the form takes a long time and also the retrieval or display of the data from the database. It also does not retrieve an excessive amount of data via SQL. When I enter the SQL command of the above mentioned record into the Microsoft Management Studio, I get 24 rows with 92 columns within 0 seconds (displayed in the SQL Studio).
We have tried the whole thing with different PCs and servers. On the servers we have already increased the number of processors and also the memory. However, this did not bring any change in speed.
The problem that the speed is significantly slower on servers does not only exist with the above-mentioned record. It is generally much slower on servers than on a PC.
Is this a known problem? What can be the reason that the calls on servers are so much slower than on a PC and what can we do about it?

ATE Version 5.3.1.27
MS-SQL: 16.0.1000.6
PC: Windows 10
Server for example: 2019

When I enter the SQL command of the above-mentioned record into the Microsoft Management Studio, I get 24 rows with 92 columns within 0 seconds (displayed in the SQL Studio).

I assume you're doing it on the server where ATE is slow?

Can you publish the table creation script, please?

I have executed the query via the sql statement from my computer. On my PC I have installed the management studio. If I am to run this on a server from which ATE is very slow, I would still need to install that there.
I have attached the select statement (Select.txt) and the scripts for table creation.

Please install Microsoft Management Studio on the server and run it there.

ok, i have now installed the managementstudio on a server where i can recreate the speed problem. Then executed the query.
I have of course only replaced <ATEUsername> with administrator in the penultimate line.
I got the SQL result from the server via the managementstudio also within less than 1 second.

Hi Christian.

We would like to connect remotely and investigate.

Please email connection details to support@etl-tools.com