Post reply

In Memory Database

  • May 28, 2012 at 11:57 am

    #274705

    recently i read about In memory database. is sql server support this technology?

    and it is realy very effective for performance.

    comment expected..

    Regards,

    Dhirju

  • May 29, 2012 at 1:09 am

    #1493986

    You can't specifically create an in memory table in SQL Server.

    Why??

    Because, SQL Server uses an advanced caching mechanism that ensures that frequently accessed data will normally remain in the data cache. A table can remain in cache as long as there is no pressure on the data cache and the LRU algorithms do not age the pages for the table out for non-use.

    So, if the table, you want to work as an In Memory table, is already In Memory if it is being used regularly.

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

  • May 29, 2012 at 3:10 am

    #1494034

    Take a look at this link: http://blogs.technet.com/b/dataplatforminsider/archive/2012/04/09/the-coming-in-memory-database-tipping-point.aspx

    This was written by David Campbell (MS SQL Technical Fellow) - very interesting read.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply