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 |
|
nakod1
Starting Member
2 Posts |
 Posted - 2007-09-24 : 09:07:40
|
| Hi,We have a number of sql server databases. The database has been setup over a period of time by various dbas. One of the server has a database which is very active, and have about 20 users. The other databases on the same server light usage (single instance).I have oracle experience and some sql server 4 experience3. I have been tasked with taking stock of all the databases and recommend a way forward form sql server optimization (sql 2000). One of the area I am looking is sql memory management and I have the following questions: How should I setup the database server: Multiple instants or a single instant. In multi instance mode can each instance have 2GB of memory.All inputs will be most appreciated.Thanks ! |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-09-24 : 23:54:47
|
| Don't need multiple instances in your case. How much memory each instance can use depends on sql edition, total amount of memory the server has and os type (32-bit or 64-bit). |
 |
|
|
nakod1
Starting Member
2 Posts |
Posted - 2007-09-25 : 05:27:43
|
| Thanks for the reply - we are using:Enterprize 2003 32 bitsEnterprize sql server 2000 The server has 8GM ram.Regards, |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-09-25 : 23:34:03
|
| You can allocate 7gb memory to sql if it's dedicated sql server. If each instance needs 2gb memory, you can have 3 instances on the server. |
|
|
|
|
|
|
sql server multi instance and memory usage