SQL Server Performance

Memory and SQL Server version

Discussion in 'Performance Tuning for Hardware Configurations' started by FrankKalis, Nov 17, 2003.

  1. FrankKalis Moderator

    hi there,

    this should be a rather simple question.

    SQL Server 2000 standard edition
    Server 3 GB of RAM

    Now when our network admin clicks in EM on the SQL Server Properties and then on Memory, he has configured SQL Server to dynamically allocate memory within a minimum and a maximum range. Now this range has as a maximum a value of 3071 MB RAM.

    I thought the standard edition supports only up to 2 GB of RAM.
    Nonetheless can the maximum value be set beyond this specification?
    And if so, I guess SQL Server will not take notice beyond the 2 GB RAM, right?

  2. satya Moderator

    I think by default it (SE) will only 2Gb and it could be another flaky impression of EM.
    Try capturing the counters for SQL Server: Memory Manager Object on this server to get optimum information.

    Satya SKJ
  3. bradmcgehee New Member

    I agree with Satya, Standard Edition can only use 2GB.

    Brad M. McGehee, MVP
  4. satya Moderator

    To confirm the note even one of my service noted the same issue, just ignore and capture counters if in doubt.[8D]

    Satya SKJ
  5. FrankKalis Moderator

    Thanks guys,

    the problem is much simpler than you might think. Basically I was wondering, if SQL will shown the total physical memory of 3GB (and will 'allow' to configure it), although it can not take advantage of it. It seem so.

  6. ykchakri New Member

    Take a look at the 'Mem Usage' column under Task Manager on the server. It will never go beyond 2GB for 'sqlserver.exe' process.
  7. negeue New Member

    i have w2kserver and sql2000server and its too slow all my users (30 users) are complaining.<br />memory: 1,310,184KB<br />dual processor <img src='/community/emoticons/emotion-4.gif' alt=':p' />III 667MH<br /><br />avail harddisk space : 3.75GB<br />consumed memory: almost 1 GB<br /><br />how to set the limit for memory for sql? <br /><br />
  8. Luis Martin Moderator

    Why do you want to set limit for memory?.
    Best choice is use leave SQL to use dynamic memory.

    To find perfomance problem, run Monitor Performance and Profiler to find what's goin on with resources and what SQL's take long time.

    Suggestion: Next time open a new post.

    Luis Martin

    ...Thus mathematics may be defined as the subject in which we never know what we are talking about, nor whether what we are saying is true.
    Bertrand Russell
  9. FrankKalis Moderator

    Hey Luis,<br />a little bit late, or [<img src='/community/emoticons/emotion-1.gif' alt=':)' />]<br />Basically my question was, when we have SQL 2000 Standard Edition (limited to 2GB RAM), and have irrationally a box with 3 GB RAM, why is EM showing these 3 GB available when SQL Server cannot address it fully?<br /><br />I guess the answer is as always don't use and never trust EM [<img src='/community/emoticons/emotion-2.gif' alt=':D' />]<br /><br />Frank<br /<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a><br /<a target="_blank" href=http://www.familienzirkus.de>http://www.familienzirkus.de</a>
  10. Luis Martin Moderator

    Hi Frank:<br /><br />My post was for Nequeu, (see before my answer) not for you question.<br />Futhermore, my answer was to basic for you[<img src='/community/emoticons/emotion-1.gif' alt=':)' />].<br /><br /><br /><br />Luis Martin<br /><br />...Thus mathematics may be defined as the subject in which we never know what we are talking about, nor whether what we are saying is true. <br />Bertrand Russell
  11. FrankKalis Moderator

Share This Page