SQL Server Performance

SQL Server with 1 Gig Memory

Discussion in 'Performance Tuning for Hardware Configurations' started by redzinja, Aug 8, 2005.

  1. redzinja New Member

    Hi All,
    im a newbie here and a newbie dba.
    We have a sql server 2000 running on windows advanced server with dual processor of xeon 2.4mhz and 1gig of memory. now my problem is when i check on the task manager the remaining memory of our sql server is 30mb. sometimes querying takes some time to get the result. can someone explain to me what happend to our memory? is there a way for us to enhance the performance of our sql server? do we have to upgrade our server memory? btw, i did not design the database. we just bought a system and requires a sql server. please do help me.

    Bon
  2. benwilson New Member

    my understanding is that SQL server will grab on to as much memory as it can and hold on to it for as long as it can. Adding more RAM would more than likely improve performance!

    'I reject your reality and substitute my own' - Adam Savage
  3. FrankKalis Moderator

    RDBMS like SQL Server tend to be very memory-hungry applications. Usually the more RAM you have, the better. SQL Server in specific tends to grab almost all available memory and releases it only when other apps request it. So, you don't see anything unusual. Can I assume you're running Standard Edition of SQL Server 2000? If so, this version supports up to 2 GB of RAM. It might be worth considering adding another GB of RAM to your server. Take your time and read closely through BOL about memory. It covers it all.

    But as you say, you bought a system that uses SQL Server as the underlying database system, I would contact the vendor of that system and see what he suggests.

    --
    Frank Kalis
    Microsoft SQL Server MVP
    http://www.insidesql.de
    Ich unterstütze PASS Deutschland e.V. http://www.sqlpass.de)
  4. satya Moderator

    True and also ensure to continue the database consistency checks and reindexing job in order to keepup the performance. You can easily add another 1GB memory as it is cheaper now a days.

    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.
  5. redzinja New Member

    thanks for the info.
  6. FrankKalis Moderator

    You're welcome! [<img src='/community/emoticons/emotion-1.gif' alt=':)' />]<br /><br />--<br />Frank Kalis<br />Microsoft SQL Server MVP<br /<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a><br />Ich unterstütze PASS Deutschland e.V. <a target="_blank" href=http://www.sqlpass.de>http://www.sqlpass.de</a>) <br />

Share This Page