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 |
|
hvdtol
Yak Posting Veteran
50 Posts |
 Posted - 2007-05-05 : 06:03:32
|
| Hello,We have a discussion over here about named instances.We have a Windows 2003 server with 3Gb internal memory.On this server we have only 1 (default) instance running.We typically set SQL Server to Dynamically Configure Memory and leave the min and max server memory options at the default values.It is a Sql Server 2000 Standard Edition instance; this is a 32-bit version, so it can only address 2Gb of storage.This is the where our discussion is about.- If we create a second (named) instance, will it use the remaining 1 Gb of storage that is left over... ? - or will it also be using the same 2Gb of storage and thereby using the same address pages as the default instance is using..?We have thought of creating a second instance, because it looks like the default instance is running out of memory and 2Gb is not enough anymore.If we cannot use more then 2gb on this server, then there is no need to have 3gb of storage in the server i think.Can anybody confirm this?Thank you in advance.hvdtol |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-05-05 : 12:46:48
|
| If named instance is standard edition, it uses same address range with default instance. |
 |
|
|
MohammedU
Posting Yak Master
145 Posts |
Posted - 2007-05-06 : 17:02:12
|
| Yes, you may be wasting 700+MB if your server is dedicated sql box.If you want you can install another instance but configure to use only 744 MB, so that default instance can use 2GB and for OS 256 mb.MohammedU |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-05-06 : 22:24:56
|
| You need enterprise edition to make that work. |
|
|
|
|
|
|
Named instance and memory usage