cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

MSSQL high CPU usage

Highlighted

MSSQL high CPU usage

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.

1 REPLY 1

Re: MSSQL high CPU usage

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.

Announcements

Thingworx Navigate content has a new home! Click here to access the new Thingworx Navigate forum! ______________________________