ThingWorx becomes very slow after couple of months

[seanccc]

Hi ,

I installed a ThingWorx testing environment in a virtual machine. I have about 100 Things in my system.  Recently the performance of Composer become very slow when I do any operation, especially for opening a mashup .   

Checking the Tomcat's monitor (http://localhost:8080/manager/status) , I noticed that lots of irrelevant requests when I open a entity(mashup, data table, or a thing). For example,  If I try to open a Data Table called "DeviceStationInfoTable ",  then I see the following irrelevant  requests : 

• 1084 ms 0 KB 0 KB 192.168.152.1 192.168.152.1 192.168.152.142 GET /Thingworx/Mashups/MultipleCollaspseTest5/Avatar HTTP/1.1
• 106 ms 0 KB 0 KB 192.168.152.1 192.168.152.1 192.168.152.142 GET /Thingworx/Mashups/MultipleCollapseTest5_1/Avatar HTTP/1.1
• 2707 ms 0 KB 0 KB 192.168.152.1 192.168.152.1 192.168.152.142 GET /Thingworx/Things/poc.njhtzd.thing.ViewModel/Avatar HTTP/1.1
• 776 ms 0 KB 0 KB 192.168.152.1 192.168.152.1 192.168.152.142 GET /Thingworx/MediaEntities/poc.njhtzd.image.CompareArrow/Avatar HTTP/1.1
• 69 ms 0 KB 0 KB 192.168.152.1 192.168.152.1 192.168.152.142 GET /Thingworx/Menus/poc.njhtzd.menu.compare.SubOperation/Avatar HTTP/1.1

I'm sure the above requests are irrelevant  because they're not even in the same project with the Data Table . 

During the period,  the CPU is 100% occupied  and the Composer has no response.  The usage of memory is about 40% .   

-------------------------------------------------------------

ThingWorx 8.4.2

Windows Server 2016

CPU:  i7-8750H 2 cores

Memory: 4G

Disk:  SSD 

[tcoufal · Accepted solution]

How much memory is assigned to JVM with -Xmx -Xms parameters. 

Try increase machine's memory and assign about 75 percent what you have left when Tomcat is not running to JVM. 

With 16GB machine we use about 10GB for JVM. 

Before that we had a lot of problems with stability. 

Try increase number of CPU cores as well. Thingworx Platform is getting greedier and greedier.

Number of Things is not that relevant, depends what is in them. You can have tens of thousands of things if you have like 2 numeric properties. Or you can have 100 things with 100 infotable properties with 10k records in them.  

[seanccc]

@tcoufal ,

Thank you, I increased the -Xmx -Xms to 7000m and assigned 4 cores to the VM , not the performance is much better. 

Regards,

Sean