Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
bshannon
Starting Member
3 Posts |
 Posted - 2007-11-20 : 11:26:31
|
| I know that SQL 2000 SE can only use up to 2GB of memory, but does that mean each instance can use that much or are all SQL instances on a Win2k3 SE server restricted to a total of 2GB of memory? |
|
|
KenW
Constraint Violating Yak Guru
391 Posts |
Posted - 2007-11-20 : 16:05:23
|
| Each instance, of course. |
 |
|
|
TRACEYSQL
Aged Yak Warrior
594 Posts |
Posted - 2007-11-20 : 18:06:44
|
| Yes can give 1 each but would have to leave some for operating system.We have 12 gig and leave 4 for windows. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-11-22 : 22:19:23
|
| >> does that mean each instance can use that much or are all SQL instancesOn 32-bit windows, user-mode applications can only use memory in lower 3gb range when you add /3gb in boot.ini file. If server has multiple sql instances, they have to share 3gb memory with any other user-mode apps on the server. |
|
|
|
|
|
|
SQL Server Memory Usage Question