SQL Server Performance Forum – Threads Archive
Memory and SQL Server versionhi 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? Frank
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.
I agree with Satya, Standard Edition can only use 2GB. —————————–
Brad M. McGehee, MVP
To confirm the note even one of my service noted the same issue, just ignore and capture counters if in doubt.[8D] _________
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.
Take a look at the ‘Mem Usage’ column under Task Manager on the server. It will never go beyond 2GB for ‘sqlserver.exe’ process.
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=’‘ />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 />
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.
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=’‘ />]<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>
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
Sorry Luis, I guess it was too early this morning. I didn’t see the post you’ve mentioned. Frank