Creating a Database with Memory Opt Data

1

Hi there,

when creating a DB with

Auto close= True
Auto shrink= True
Database read only= False

with a memory optimized data file, I receive the following message:

image
image770×200 11.3 KB

Similarly when creating a DB with

Auto close= False

Auto shrink= True

Database read only= True

it would fail.

For this database to be created, I would have to make auto close=false and db read only = false. Can anyone explain why? I have searched and I haven't found a clear answer.

What is the relationship between auto_close and memory optimized file data?

Thanks!

2

The auto_close will clear the plan cache and will cause recompilation.
Memory optimized objects are used for performance and that is why I think this has been restricted.

3

If you close the db, a memory-only table would be gone, dropped automatically. It's not really logical to use memory-only tables with an auto close db. Auto-close is almost never really useful in SQL Server at all.