SQL Server Performance

SQL-Server data Cache

Discussion in 'Performance Tuning for DBAs' started by nrkumar, Mar 5, 2003.

  1. nrkumar New Member

    Is there any way change the SQL-Server data Cache memory settings?
    ie any stored procs to increase the data cache ?
  2. satya Moderator

  3. bradmcgehee New Member

    In SQL Server 7.0 and 2000, you can't directly modify the components of the SQL Server data cache, this is done automatically by SQL Server. The only real control you have is to allocate or add more memory to your server.

    ------------------
    Brad M. McGehee
    Webmaster
    SQL-Server-Performance.Com

Share This Page