Subject: | Allocating Memory Across SQL Instances |
Posted by: | edsmi…@pascocountyfl.net |
Date: | 31 Jul 2006 |
Considering the platform: 4-way, 16GB RAM running Windows 2003 (32-bit)
Enterrise Edition and SQL 2000 Enterprise Edition. With only 2GB (or
3GB with /3GB switch) of pagable memory to work with, how is this
memory shared across multiple SQL instances within a clustered
environment? This is a new cluster that will potentially support about
20 databases. Any suggestions on how to best work through the decision
process of whether to add additional SQL instances and what the memory
implications would be either way?
Thanks much,
Ed