Author Topic: What's the best way to make this faster for remote working?  (Read 2946 times)

GrantC

  • EA Novice
  • *
  • Posts: 5
  • Karma: +0/-0
    • View Profile
What's the best way to make this faster for remote working?
« on: April 10, 2020, 01:24:33 am »
Hi, I work at a company with 10 or so architects who use EA fairly heavily.  The speed has never been great but now we're all working remotely over a VPN it's terrible, we're seeing things like package checkouts taking from 5 to 30 minutes, several minutes just opening an entity, lots of SQL timeouts, and so on.

I'm not too familiar with the setup but I know we have:
  • A single, relatively large model
  • SQL Server back end (shared)
  • TFS version control
  • EA version 13.0

We've been investigating a bit, the main cause of the problems seems to be blocking in SQL.

There are a few options we're considering, namely
  • Pro Cloud Server
  • Running EA on VDIs
  • Improving the SQL (e.g. faster box, isolated DB)

Pro Cloud Server seems like it should help by grouping queries together and reducing network traffic.  But before we dive in with that (which may take a little while anyway), I'd like to ask if anyone else has had similar issues and how you solved them.

Geert Bellekens

  • EA Guru
  • *****
  • Posts: 13404
  • Karma: +567/-33
  • Make EA work for YOU!
    • View Profile
    • Enterprise Architect Consultant and Value Added Reseller
Re: What's the best way to make this faster for remote working?
« Reply #1 on: April 10, 2020, 01:56:28 am »
I had the best experience with Remote Desktop/Citrix solutions.

You wanna keep the client as close to the database as possible as that is the bottleneck.

Geert

Prolaborate Support

  • Prolab Moderator
  • EA User
  • *
  • Posts: 318
  • Karma: +22/-0
    • View Profile
    • Visit us
Re: What's the best way to make this faster for remote working?
« Reply #2 on: April 10, 2020, 08:59:51 pm »
As per our experience, the performance with Pro Cloud Server has been far more optimal and reliable than OLE DB or ODBC based connections when connecting to repositories remotely.
« Last Edit: April 10, 2020, 09:02:53 pm by Prolaborate Support »