SQL Server Performance

Memory Problem

Discussion in 'Performance Tuning for DBAs' started by vdavid, Feb 28, 2006.

  1. vdavid New Member

    Hi All,
    I have a database that runs on sql server 7 standard edition on a windows 2000 computer.
    I am getting an error from my sql server logs saying
    "WARNING: Clearing procedure cache to free contiguous memory." During my investigation on how to sort this out,i found i could sort this out by editing the /g parameter in the start up parameters.

    Now my question is how do i edit this parameter and if there is any other way to solve this problem.
  2. dineshasanka Moderator

Share This Page