Author Topic: Degraded performance of client to AWS hosted SQL server  (Read 1842 times)

Ron Beernink

  • EA User
  • **
  • Posts: 24
  • Karma: +1/-0
    • View Profile
Degraded performance of client to AWS hosted SQL server
« on: February 01, 2022, 06:45:44 pm »
Kia ora good Sparx people.  We recently migrated our EA repository from our New Zealand based data centre to AWS EC2 Sydney (VM running SQL Server 2008).  We expected performance degradation using our desktop based Sparx EA version 14.1 client, but testing indicated that this was acceptable and in the first few weeks things worked OK.  Since then things have got signifantly slower to the point of not being able to use Sparx.    Our technical service team has checked things out but can't see any unusual performance stats for the server or for the network connection.   We are continuing to investigate and I appreciate that it depends on a number of variables, but I thought I check if anyone on this forum may have had a similar experience?    And yes, I appreciate that we may have to go down the Sparx Pro Cloud Server path.

Geert Bellekens

  • EA Guru
  • *****
  • Posts: 12996
  • Karma: +544/-33
  • Make EA work for YOU!
    • View Profile
    • Enterprise Architect Consultant and Value Added Reseller
Re: Degraded performance of client to AWS hosted SQL server
« Reply #1 on: February 01, 2022, 07:53:36 pm »
Hi Ron,

PCS might help, but will probably not solve the performance issues completely.

I would recommend to install the client on AWS as well. You can use something like RDS or Citrix to run the application from your local desktop (it actually run on the server, but it looks like it's a local application)
There are a few downsides (file access) but a lot of my clients are happy users in such a setup.

Added advantage is that is simplifies the maintenance burden of the EA Client. You only need to install the client once on the server.