question

SreeniG-7743 avatar image
0 Votes"
SreeniG-7743 asked Cathyji-msft edited

XTP_THREAD_POOL- lot of spids running in background when no sql workload is there.

In our L&P systems, before the actual run kickoffs we have a SOP to run rebuild indices and update statistics job. Recently we are seeing SQL memory consumption is great than 80 % even after the above jobs get completed and there is no SQL workload running behind the scenes.

When we do sp_who2 and run some diagnostic queries to see the current activity we mostly see spids related to XTP_THREAD_POOL (with wait type -DISPATCHER_QUEUE_SEMAPHORE -its count is 53,in our db we have three in-memory tables).

We didn't observe this behavior in our previous runs, can someone please explain what SQL is consuming high memory and not releasing it and why this behavior not seen previously. (we take system utilization for our every run ,we are doing this type of load testing from past few years)

Note : In few msdn links few MVPs mentioned this behavior is normal but wanted to know if anything related to in-memory tables causing this or any other factors, please share your thoughts.

sql-server-generalsql-server-transact-sql
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

Cathyji-msft avatar image
0 Votes"
Cathyji-msft answered Cathyji-msft edited

Hi @SreeniG-7743,

Quote from the old thread What are all the XTP_THREAD_POOL processes doing

113259-screenshot-2021-07-09-163146.jpg


If the response is helpful, please click "Accept Answer" and upvote it, as this could help other community members looking for similar queries.



5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.