The performance of your ThingWorx application 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 application and the database. Generally, the expected latency between ThingWorx and the databases should be 10-15 ms. It is recommended that queries from your application to the database should complete in under a minute under normal load conditions.

Any slowdown in your ThingWorx application 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.