Operating System and Database Performance Issues
The performance of your ThingWorx solution depends on the performance of your underlying database engine. It is recommended that you closely monitor the health of your database engine. You should work with your DBA team to identify slow queries and address any latency or throughput issues between the ThingWorx solution and the database. Generally, the expected latency between ThingWorx and the databases should be 10-15 ms. It is recommended that queries from your solution to the database should complete in under a minute under normal load conditions.
Any slowdown in your ThingWorx solution should be evaluated against database traffic, locked transactions, and slow queries. Monitoring tool such as PSM help in identifying the slow queries. This helps you to relate them to other events on the server. Additionally, database management tools provide a robust set of diagnostic tools to identify problem queries.
Was this helpful?