Sparx Systems Forum

Enterprise Architect => General Board => Topic started by: GrantC on April 10, 2020, 01:24:33 am

Title: What's the best way to make this faster for remote working?
Post by: GrantC 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.

Title: Re: What's the best way to make this faster for remote working?
Post by: Geert Bellekens 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

Title: Re: What's the best way to make this faster for remote working?
Post by: Prolaborate Support 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.