August 14, 2004 at 8:48 pm
I have a multiple node failover cluster with 2 nodes. The cluster is currently in a failed over state and running. Both SQL server instances are configured with fixed server memory at 1400 MB and Reserve physical memory for SQL server is enabled. On the active cluster node there are 2 sqlservr.exe processes running. One process has allocated 1463 MB allocated while the other has only 567 MB.
Questions:
Will the memory allocation slowly grow to the appropriate size?
When the failover happens shouldn't the instance immediately allocate the required amount of memory?
Rusty
August 14, 2004 at 8:51 pm
hehehe... and i was trying to be so professional!!! Yes SQL Server 200 should be SQL Server 2000.
Oh Well.
Rusty
August 16, 2004 at 11:26 pm
It wil slowly (or quickly) grow to the amount needed (or maximum)
August 17, 2004 at 1:41 pm
Book online says.
When both instances are first started, they typically acquire 8 MB to 12 MB of memory. As users connect to the instances, each instance acquires enough memory to satisfy its current workload.
August 17, 2004 at 1:49 pm
How much physical memory each server has?
August 19, 2004 at 12:18 pm
Each server has 3Gb of memory. Though it seems strange to me that it would grow based on connections if the "Reserve Physical Memory" is checked.
Rusty
P.S. Thanks for all the replies!!
August 19, 2004 at 12:28 pm
Since both instances run in same node and 1GB reserved for OS, The max memory can be used by both SQL Server instances is 2GB in your configuration.
Separating two SQL Server instances in different nodes will allow each instance take 2GB memory.
Viewing 7 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply