Store table data into cache memory.

Question

If I have a mostly repeated table which I want to place in cache memory, is there a way to force SQL to do that?Next time get data from cache memory.

Manish Kumar · Answer

I know its an old post but any way. Which sql server version you are using.In Sql server 2014 onwards, there is one new concept is introduced in sql server known as In-Memory OLTP tables and procedures where you can create a table on memory side and even for fetching/manipulating of data on that table new procedure is introduced known as Natively compiled stored procedure. Hope below link will help you. https://www.simple-talk.com/sql/learn-sql-server/introducing-sql-server-in-memory-oltp/ Thanks

Manas Mohapatra · Answer

As per Pradeep, you can use SQLCache dependency concept to catch your data. It means cache memory will create connection with table. If any data modification happened then cache will be reloaded automatically. http://www.dotnetcurry.com/ShowArticle.aspx?ID=263 http://www.srikanthtechnologies.com/blog/dotnet/sqlcachedependency.aspx Secondly, if your data are almost static then you can use simple Cache object. To implement the same create a singleton class which will manage your cache objects. http://stackoverflow.com/questions/11502584/asp-net-cache-singleton-pattern

Mayank · Answer

You can get idea of caching using SQL server by below link: https://www.youtube.com/watch?v=cB9TlZB3pSw

Atul Patil · Answer

I want caching on sql server side not on ASP.NET side.So,how it is implemented in SQL Server?

Pradeep Sahoo · Answer

You can think of usingSqlCacheDependency. The details in the linkhttps://msdn.microsoft.com/en-us/library/9dz445ks(v=vs.110).aspx