1 Reply Latest reply on Sep 6, 2017 8:29 AM by gbrentegani RSS
    gbrentegani Newbie

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

    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?