Application is noticeably slower when running on Terminal Server 2019 than on RDP session to Windows Server 2019
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.