Memory-Optimized Table Disk space
-
Comments posted to this topic are about the item Memory-Optimized Table Disk space
-
Too easy thanks.
Hope this helps...
Ford Fairlane
Rock and Roll Detective
-
Had to do some quick searches to get it right, thanx.
Thanks & Best Regards,
Hany Helmy
SQL Server Database Consultant -
Hany Helmy (4/23/2014)
Had to do some quick searches to get it right, thanx.+1
-
This was removed by the editor as SPAM
-
Easy one. Thanks Steve.
Everything is awesome! -
I saw a presentation on this a while back and specifically remembered this. Honestly, I was hoping that it hadn't changed. Thanks for the question. I'm anxious to play with 2014, but I know it's going to be a while.
-
I suspect this 2 times is only a rough estimate, as it appears to be directly contradicted by the BOL page Durability for Memory-Optimized Tables which states
BOL
Storage taken by active CFPs (not all CFPs are being updated) can be up to 2 times larger than the size of durable tables in memorywhich clearly means three times the storage space may be needed on disc (it's two times larger, not just twice as large), which is confirmed towards the end of the same page by the statement
BOL
It is not uncommon for CFPs to be three times the size of the durable memory-optimized tables in memory.Tom
-
Nice question, thanks.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP -
easy one.
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply