Allocating Memory Across SQL Instances

Giganews Newsgroups
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

Replies