Hi sqluser786,
>> does the SQL has to load the complete 2 tables in to memory first before bringing the DB online?
Unlike disk-based tables, memory-optimized tables must be loaded into memory before the database is available for user access. This requirement adds a new step in the database recovery.
>> 40 seconds (2 *20 seconds for each table) + regular recovery process of analysis,redo and undo phases for DB recovery?
As Liweiyin mentioned, SQL Server Loads in-memory tables and does disk-tables recovery parallelly.
Suggest you read MS document
Restore and recovery of memory-optimized tables to get detail information.
Best regards,
Cathy
""SQL Server related"" forum will be migrated to a new home on
Microsoft Q&A SQL Server!
We invite you to post new questions in the "SQL Server related" forum’s new home on
Microsoft Q&A SQL Server
!
For more information, please refer to the
sticky post.