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 |
|
jpotucek
Constraint Violating Yak Guru
273 Posts |
 Posted - 2009-10-07 : 07:42:55
|
| I have a 32 bit Windows 2003 Server Enterprise Edition Server with one quad core processor 2.83ghz and the box has 3.25 GB of RAM. Is this adequate to run one default and two Named Instances of SQL Server 2005 Standard Edition (patched to SP3) ?? If additional memory is recommended, what kind of parameters would have to be changed or what kind of tuning would ahve to take place in order to take advantage of the additional memory? |
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2009-10-07 : 12:33:56
|
| Is there a reason you would need 3 instances of SQL Server? Couldnt one instance handle it all? Before you add more RAM upgrade to x64 so the apps can take advantage of the additional RAM. 32 bit systems have a 4 GB limit they can use. You can make SQL use a little more than that but its not clean...Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
 |
|
|
pphillips001
Starting Member
23 Posts |
Posted - 2010-03-15 : 07:04:53
|
| Hi,I thought that enabling AWE in SQL 2005 Standard allowed the DB to utilise up to all available memory (up to 64Gb) on 32Bit systems beyond 2Gb?Regards,Paul===========================There is no reality - only perspective. |
|
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2010-03-15 : 07:29:23
|
| The amount of RAM needed depends on what you're going to use the databases for. There is nothing stopping you from installing 3 instances and they will run just fine if you don't put any heavy-usage databases on it. You should however reserve some of the RAM to the OS (limit the ram used by each instance). AWE is a possibility but it's far better to upgrade to x64 if this is a possibility for you. I've always thought AWE was a pain in the a$$ so I'm very happy that 32-bit is on the way out...- LumbagoIf the facts don't fit the theory, change the facts. Albert Einstein |
|
|
|
|
|
|
Memory requirements