SQL Server Performance Forum – Threads Archive

main memory database

Hi all,
I have a project for designing an in memory database by using SQL Server, i.e I want prior to client specify query to load the whole database into memory to speed up the query request i mean to cach the database so that when client post a query he/she will find it as if it request it before and never need to access the disk (I/O)for cache missed data.
how can I do this is anyone know how can start dowing so at least can any one give be a prototype of how can i acheive this.
thanks

http://www.sql-server-performance.com/q&a121.asp – for all your doubts. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

thanks 4 ur reply,
but this is my project aim is to design and develop an in memory database technique by using SQL Server database when a client requests a query he already find it on memory and no need for disk accessing, my question is that how can i design such system and manage database into memory to avoid data lost.
thanks..

I believe you haven’t read the referred link, SQL server manages the data in memory depending upon the design and accessibility of database and server resources. The bufferpool is the main primary memory cache used by the basic data access routines in the SQL database management and contains data pages from the databank files. It is a local memory area in the database server process. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

]]>