| Author |
Topic |
|
DBADave
Constraint Violating Yak Guru
366 Posts |
 Posted - 2005-08-09 : 16:50:28
|
| I have always used Enterprise Edition so never had to be concerned with the memory restrictions of Standard Edition. I've read where memory is limitted to 2GB for Standard Edition, but I encountered a server today containing over 3GB of memory. How is that possible? Is the Microsoft documentation incorrect?Thanks, Dave |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2005-08-09 : 17:24:22
|
| The sever can have over 2 GB of physical memory, but SQL Server Standard edition will only use 2 GB.CODO ERGO SUM |
 |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2005-08-09 : 17:27:59
|
actually, if you put the /3GB switch in the boot.ini, SQL Server will be able to use 3GB for it's buffer cache. EDIT:I am totally wrong with this. MVJ set me straight in his post below.-ec |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2005-08-09 : 20:59:31
|
quote:
Originally posted by Michael Valentine Jones
Where did you get this information?This article says Standard Edition supports up to 2 GB of memory.SQL Server 2000 Product Overviewhttp://www.microsoft.com/sql/evaluation/overview/default.mspxThis article says you can use /3GB for Enterprise Edition, and makes no mention of /3GB support for Standard Edition.How to configure memory for more than 2 GB in SQL Serverhttp://support.microsoft.com/default.aspx?scid=kb;en-us;274750&sd=techquote:
Originally posted by eyechart
actually, if you put the /3GB switch in the boot.ini, SQL Server will be able to use 3GB for it's buffer cache. -ec
CODO ERGO SUM
Michael, you are correct, I am completely wrong on this. The /3GB switch does absolutely nothing for SQL2K standard edition.-ec |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2005-08-09 : 22:24:26
|
Maybe they have multiple instances of SQL Server running? I think each instance can use up to 2 GB, but I have never tried it.I guess it would be possible with 64-bit SQL Server also, but not many people are running that.quote:
Originally posted by DBADave
I have always used Enterprise Edition so never had to be concerned with the memory restrictions of Standard Edition. I've read where memory is limitted to 2GB for Standard Edition, but I encountered a server today containing over 3GB of memory. How is that possible? Is the Microsoft documentation incorrect?Thanks, Dave
CODO ERGO SUM |
|
|
|
DBADave
Constraint Violating Yak Guru
366 Posts |
Posted - 2005-08-10 : 08:42:47
|
| What I find strange is if I look at Memory under SQL Server properties I see 3712 as the maximum memory on the physical server and 3072 as the run_value.name minimum maximum config_value run_value max server memory (MB) 4 2147483647 3072 3072Is SQL Server allowing you to set the configuration to 3072, but only using 2GB?Dave |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2005-08-10 : 08:52:27
|
You could use performance monitor to see what it is actually using.quote:
Originally posted by DBADave
What I find strange is if I look at Memory under SQL Server properties I see 3712 as the maximum memory on the physical server and 3072 as the run_value.name minimum maximum config_value run_value max server memory (MB) 4 2147483647 3072 3072Is SQL Server allowing you to set the configuration to 3072, but only using 2GB?Dave
CODO ERGO SUM |
|
|
|
|
Memory and Standard Edition