I created In-Memory OLTP Non-Durable Tables in 4 different SQL servers.Lately one of the server performance has degraded and I see lot of processes (Almost 200-300) running with command XTP THREAD_POOL.I don't see any such processes running on other 3 servers and there isn't any performance issues on them either.

Does anybody have any idea how to resolve it.

enter image description here enter image description here

  • 1
    Curious if all servers are the same patch level. – NedOtter May 16 '18 at 19:02
  • I was running batch and it completed in 4 hours with physical tables and took me 4hrs 30mins with in-memory tables.As i mentioned earlier I dont see such issue with other 3 servers and I dont see such process either.I have output for your query but how can i attach that file? – Aamir Zargar May 17 '18 at 2:13
  • @RandolphWest added picture to question.Let me know if you need more fields. Thanks – Aamir Zargar May 17 '18 at 3:18
  • Nothing exciting there. I'm going to clean up my comments above, and ask for you to have a look at Windows Performance Monitor for the XTP storage counters to look for any correlation there. Important to remember that disk I/O still happens irrespective of your durability settings. More info here: docs.microsoft.com/en-us/sql/relational-databases/… – Randolph West May 17 '18 at 3:30
  • 1
    @RandolphWest - not sure how the link you supplied relates to disk I/O for memory-optimized tables that are schema-only. Other than file pre-creation, I would expect 0 disk I/O. – NedOtter May 17 '18 at 14:37

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.