Skip to main content
1-Visitor
August 30, 2017
Solved

Azure SQL + Thingworx 8 the performance is low! Help!

  • August 30, 2017
  • 1 reply
  • 1338 views

Hi  everyone,

I want to discuss the performance about the configuration below:

  • Azure Sql database : S0 standard 10 DTU

  • Azure Virtual machine: Basic A4 (8 vcpus, 14 GB memory)





I noticed a lower performance, for example, get the things entities, than the Local MSQL database.

When I click on Things, Thingworx give me back all the things:

the response is very different here is the result:

1) Thingworx 8 + Azure Sql   (very slow!!!!)    (5715 ms )

2) Thingworx 8 + Local MSQL  (157 ms !!)


I belive that exist a solution to increase performance ..Do you have any suggestion?



Thanks

    Best answer by gbrentegani

    Hi,

    I found the solution:

    My Azure Virtual machine was in North Europe location

    My Azure Sql DB was in West Europe


    So I moved the azure SQL DB to North Europe and now the performance is great!!!!

    Bye

    1 reply

    gbrentegani1-VisitorAuthorAnswer
    1-Visitor
    September 6, 2017

    Hi,

    I found the solution:

    My Azure Virtual machine was in North Europe location

    My Azure Sql DB was in West Europe


    So I moved the azure SQL DB to North Europe and now the performance is great!!!!

    Bye