I have a client with about 10 or so 'super' users who often work remotely. When they need to use the application (PB 2021), they RDP into a Windows 2019 Server desktop, launch the app that is deployed there and go about their daily work. The application uses SQL Server 2019. In mid-June, they moved to new servers and upgraded to SQL Server 2019 from 2014. At first performance seemed fine. In the last few weeks however, users have been reporting sporadic/intermittent performance issues. I've looked in Task Manager/Performance Monitor/Event Viewer and don't see anything obvious. Their network folks have checked things and don't seem anything amiss. The client application connects to the SQL Server database using the new MSOLEDBSQL driver.
It doesn't explain the timing of the onset of performance issues, but it seems like it would be good idea to limit the number of users who can run this application on the this machine. This made me think of PowerClient. Would using PowerClient be a potential performance improvement over connecting to a VPN or Citrix and running the app from their office computers or laptops?
So, two questions:
- Are there any performance tuning tips or tricks or connection properties to try based on the scenario above?
- Is PowerClient faster than using a VPN, Citrix or RDP?