Skip to main content
G
georgeanderson13-Aquamarine
13-Aquamarine
December 4, 2019
Solved

MSSQL high CPU usage

  • December 4, 2019
  • 2 replies
  • 1384 views

My MSSQL ThingWorx database keeps getting slammed by a query that seems to run very frequently. Here's the query:

 

SELECT COUNT(*) FROM data_table WHERE entity_id = @P0

 

I am not sure what is triggering this query, or why. But, data_table is quite large and this query seems to be consuming resources unnecessarily. Does anyone know what triggers this query, and why.

Best answer by slangley

Hi @georgeanderson.

 

For the benefit of the rest of the community, the fix for this issue was delivered in ThingWorx 8.5.5 released earlier this week.

 

If you agree with the solution, please mark this post as the Accepted Solution.

 

Regards.

 

--Sharon

 

2 replies

T
tmisner16-Pearl
16-Pearl
December 16, 2019

Hello George,

 

I see you have logged a case with Technical Support for this issue. Vanessa who is working with you can post the solution here for other PTC Community Users once the case is resolved.

S
slangleyCommunity ManagerAnswer
Support
April 29, 2020

Hi @georgeanderson.

 

For the benefit of the rest of the community, the fix for this issue was delivered in ThingWorx 8.5.5 released earlier this week.

 

If you agree with the solution, please mark this post as the Accepted Solution.

 

Regards.

 

--Sharon

 

Terms & ConditionsAccessibility statement