This week I gave a presentation to a client on using SQL Server 2014 in-memory features. This was just an overview session to give them an idea of what it was and how it works. The discussions that acme of out of this were quite interesting. One in particular stands out.

What types of data should we use the new in-memory features for? Some of the best uses are:

  • A set of tables that require extreme performance in an oltp application. Move those tables or parts of them.
  • Caching applications (such as ASP.Net session state or an entity cache)
  • Lookup tables that are loaded from static data (like area codes)
  • Other specific uses that you might find.

There are many other uses for the in-memory cache. The performance this feature brings is mind boggling.