Hi All,
SQL Server 2019 instance which is hosting 15 DBs (in-memory optimized) with a total all in-memory tables size (16 GB) in a server(16CPU,64GB RAM ). CPU is at 100% utilization whenever SQL service or server restarts, while all DBs are in in-recovery status. Also this is causing DB recovery time and never completing the recovery process in some times..
I am aware that there is a bug with SQL server 2014 and 2017 for this issue and trace flag 9944 is available as a workaround. However, the recovery process is taking 3 hours with 100% CPU usage. We do not have an option to see recovery % details in SQL server error log as like on-disk dbs.
Any one of you faced this issue with the 2019 version?. Please let me know if you have a fix\workaround to reduce the recovery time and 100% CPU utilization?
I tried ADR ( Accelerated database recovery) too but no luck for in-memory tables.
In-simple words: 250 in-memory tables with small size (all together approx. 1GB) in one DB
one SQL Instance is hosting 15 DBs (15*1GB approx. = approx. 16 GB total memory data size) in server (configurations 16CPUs and 64GB RAM)
Thanks in advance.