You could do a Windows Server Terminal Server, we have quite a few, and it would be fairly straightforward to get going and test. You could add more if needed; you'll need additional Office licenses, one for every user that "can" access the Terminal Server, but they work great for us in our environment. TSCALs for every user but you can do without for testing; I think you get 90 days before you actually need TSCALs. Not sure. We've got one hosting developers that routinely has many as 30 users connected and it sits in the DataCenter close to the data they access so works great. Worth a test.
rob From: [email protected] [mailto:[email protected]] On Behalf Of David Tobias Sent: Thursday, August 24, 2017 11:31 AM To: [email protected] Subject: [NTSysADM] Performance issues working on large shared files over VPN Hi all- As a junior sysadmin I've been tasked with reviewing a solution to the following problem. Users that work from home (traditionally out of state from where our file server is located) are experiencing performance issues when having to VPN in and work on larger files (traditionally shared Excel workbooks that can range from 15MB to 45MB in size). As anticipated, users are experiencing performance issues, time-outs, and instability when having to open and work on these workbooks across the VPN. Users on the LAN in the same location where the file server is operate normally without issue, as expected. A few suggestions that have been tossed around have been setting up some type of VDI solution to present them with a virtualized desktop where they can go to work on the files. Immediate downside is that we don't have an infrastructure for this in place and it may be overkill if this is just affecting a few users working on a few files. We've also discussed about setting up a SharePoint or Teams site as a collaboration area for them to work (not going across VPN) but there are concerns about hosting files with sensitive information as well as for users needing potentially needing to store more and more files as time goes on leading to a split of our files being located on a file server as well as on an online site. This is still a very early stage project and nothing is necessarily off the table at this point. Would very much enjoy hearing from others who may have had to deal with a similar situation and how they worked through it. Appreciate this great list! Thank you. ~Dave CONFIDENTIALITY NOTICE: This communication and its attachments may contain non-public, confidential, or legally privileged information including HIPAA-protected PHI. The interception, use or disclosure of such information is prohibited. If you are not the intended recipient, or have received this information in error, please notify the sender immediately by reply email and delete all copies of this message and attachments without reading, saving, or further distributing them.

