SQL Server Performance

main memory database

Discussion in 'Non-Transact SQL Developer Performance Tuning' started by hoodirash, Jul 31, 2005.

  1. hoodirash New Member

    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
  2. satya Moderator

    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.
  3. hoodirash New Member

    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..
  4. satya Moderator

    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.

Share This Page