I'm testing SQL 2014 - in particular, memory optimized tables. We loaded the memOptimized tables (2 Billion rows) from replica conventional tables. For clarity sake - we have conventional tables and memory optimized tables with the exact data set.
The specific table(s) we're testing has 5 columns (int, int, bigint, bigint and timestamp). We've created non-clustered and non-clustered hash indexes on the in-memory tables, performed dropCleanBuffers on the conventional table to purge tables from memory, etc. We're seeing index seeks in the execution plan on the InMem tables - but the performance is still lacking. Performance for simply count queries is terrible. For Count queries, we're getting results in 26 seconds on convetional tables, and 5+ minutes on the memory optimized tables.
Now the really interesting part - memory optimized tables to not support parallel plans.
The lack of parallel execution is what is causing such degradation.
Any advice? Anyone leveraging this functionality yet?