Hey Jim,

you are right about the data being in the memory for tables that are accessed regularly. But what about the write speed? Even when the data is persisted, the way the changes are written to the T-log is slightly different for In-memory object when compared to Disk based tables. There is less write operation for In-Memory objects.

Regarding SSD's, I see a big gain in performance on write operations when compared to disks. Our new server has Disks just for the OS. All the DB's are on SSD's. We have seen a very big improvement on IO. Our DB is not large, just 1.5TB but it is very active. At any given moment we have more than 6000 batch request per second.