Application is noticeably slower when running on Terminal Server 2019 than on RDP session to Windows Server 2019

Alastair Davie 1 Reputation point
2023-02-10T18:38:58.77+00:00

We have a Terminal Server 2019 farm, (2 servers) and a lone Terminal Server 2019 for UAT. We run Dynamics GP as a published app, or via desktop session on the Terminal Servers. This is new infrastructure to us having upgraded Dynamics GP. The users have reported a noticeable drop in performance recently. Have compared performance using an RDP session to a Windows 2019 that's part of the setup.

Posting same large batch multiple times, restoring DB in between, UAT Terminal server is 16min. PRD TS farm 15min. In both cases using desktop session during quite period. RDP session took 10min.

Switching company, 45 to 60sec for Terminal server. 25sec for RDP.

All testing against the same SQL Server. All servers in the same data centre and virtual machines (VMWare) and sub 1ms Ping between boxes.

Profiling of the DB traffic shows most time spent waiting for next query. When switching Company, it's a total of 5sec of query time, even for when it takes 60s on the client.

What sort of settings should be examined?? What profiling, monitoring or tracing should be done?? I'm a DBA, not a Windows Server admin.

Thanks in advance for any thoughts or advice.

Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
13,714 questions
0 comments No comments
{count} votes

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.