SQL Server Performance

my server squeezing memory [urgent]

Discussion in 'Performance Tuning for DBAs' started by raheel, Mar 4, 2004.

  1. raheel New Member

    Folks I am facing a problem related To Sql server
    2000.

    There is 2 GB available on sever, but this area gets
    filled very quickly, hardly 200 MB of space remains
    and when we restart the server or refresh the Sql
    server services it frees the memory, but within 12 to
    14 hours it again fills the memory. What is this, any
    idea? Can anyone give me a clue, what to look for?

    I know that when sql sever grabs the memory it does
    not release it until any other application demands
    more ram. We are using many stored procedures does
    this have to do any thing with it. There is lot of
    network trafic as well in and out of sql server.

    We are using Windows 2000 with service pack 4 and Sql
    server 2000 standard edition with service pack 3, with
    2 GB physical RAM.

    Thanks.

    Raheel.
  2. satya Moderator

    The memory concept of SQL is by default and what are the memory settings on SQL.
    IS the server is a dedicated SQL box or any parallel applications sharing the resources?

    Run PERFMON and capture counters for Memory, PRocessor, Process, Physical disk & other SQL related counters to assess the situation.


    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. Chappy New Member

    Not sure why this is a problem. Youve paid for the memory, may aswell get some use of it!
    Unless as satya suggests the server is not a dedicated one?
  4. satya Moderator

Share This Page