CODEWITHSUNDEEP
sql-serverdatabasesql-server-2016database-administrationmemory-optimized-tables
Sohail Hameed
Sohail Hameed

Reputation: 988

Memory optimized data base and table variable

After looking into different groups/discussions i didn't found any satisfactory answer of my question,

I have around 1.5 TB size Sql server database in production, and there is also a transaction replication set on this database, In order to add/migrate disk based to memory optimized table we have to only create a file group with memory optimized data or any other setting on whole database?

If we only use memory optimized table variables only that will be not durable, do we need to apply same setting on complete database?

And is there will be any performance gain to use in memory table variables in non-native compile store procedure?

And most important, What will be effect on replication? we can not add durable memory optimized table in replication? but what about file group or any other setting on database if only made on primary database?

Thank you

Upvotes: 1

Views: 196

Answers (1)

Tarun
Tarun

Reputation: 59

If I'm understanding your question correctly, you want to move your whole 1.5 TB of data in In Memory? If yes - it is not advised because of its size. Further, settings directly at DB levels, will not help. There are certain steps to follow. Refer MSDN.

Are you on replication or Always On?

.

Upvotes: 1

Related Questions