Posted by Erland Sommarskog on 04/23/07 21:27

(astrohorse26@hotmail.com) writes:
> We are running on SQL 2000 on Windows 2003. We have active-passive
> clustering set up. We have 16 GB of RAM on each box. This past
> weekend, we failed over. I noticed that the Total Server Memory went
> from about 15.5 GB to 8 GB. I have been trying to figure out why this
> has occurred. Any help would be greatly appreciated.

One cannot accuse me for knowing too much about Windows clustering,
but surely in a cluster, each node has its own memory, hasn't it? That
would mean that a failover is the same as running DBCC DROPCLEANBUFFERS,
that is the entire cache is flushed. Of course, as SQL Server continues
working, the cache will grow again. But if it only has grown to 8 GB
this far, this indicates that so far that you have only touched 8 GB
of data - actually even less, as this also includes the plan cache.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]