arrjay (11/11/2014)
I think we will start with all new tables should go into in-memory with the view of migrating the existing tables over time.
Are you intentionally trying to destroy that application? If so, good start.
In-memory means exactly that. IN MEMORY. They aren't normal tables which live on disk and are read into memory as needed. They have to be in memory always. If there isn't enough memory for all of the data of all of the in-memory tables, the DB will stop working.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability