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 |
|
bryan99y
Starting Member
42 Posts |
 Posted - 2002-02-06 : 17:10:56
|
| I am purchasing a new server soon that will have:1. Four Processors2. 8GB Ram3. Windows 2000 Advanced Server4. SQL Server 2000 Enterprise EditionI am doing only the one install of SQL Server Enterprise Edition. How much memory will that SQL Server Enterprise be able to use / access ?If I install say 4 Instances, how much Memory will they be able to use ? |
|
|
bryan99y
Starting Member
42 Posts |
Posted - 2002-02-08 : 13:10:24
|
| Any ideas ? |
 |
|
|
aiken
Aged Yak Warrior
525 Posts |
Posted - 2002-02-08 : 13:23:14
|
| Search books online for "managing awe memory."It looks like SQL server can be configured to use up to 31GB of memory on a 32GB system.On an 8GB system, it looks like 7GB is the max for a single instance. It looks like you can split that 7GB up in arbitrary chunks for multiple instances (3+2+1+1, 2+2+2+1, etc), but the OS will need 1GB no matter what (the way I read it anyway).Cheers-b |
|
|
|
bryan99y
Starting Member
42 Posts |
Posted - 2002-02-10 : 12:33:26
|
| Chad --> your thoughts on this ? |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2002-02-10 : 13:48:22
|
| sql server should dynamically allocate memory up to what is available (up to 64 G I believe) i.e. not reserved for other processes.I'm not convinced by the management of muli-instance systems as they do seem to degrade more than I would expect when they get close to using all the memory, but I haven't tested too deeply.It's enough work to make sure that all the simultaneous processes on one instance will run in the available memory without worrying about what other instances are doing as well. You also come across the difficulty of communicating between instances if you have a process that needs a lot of memory.==========================================Cursors are useful if you don't know sql.Beer is not cold and it isn't fizzy. |
|
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2002-02-12 : 13:18:46
|
| No need to use AWE with 8GB Memory, and 4 instances. Because the Max Server Memory settings for each instance must total less than the Physical memory on the machine. So each instance can use 2GB without AWE, unless you want 1 instance to use 4 and the other 3 use 1 (which sounds overly complicated to me) I wouldn't even bother with AWE.If you are just going to run 1 or 2 instances, then look into AWE, and set each to just less than 4 GB.HTH-Chad |
|
|
|
|
|
|
AWE Memory & SQL Server 2000 Enterprise Edition