Does anyone know what the reason is for the folowing paragraph on
http://support.microsoft.com/kb/889654:

Note If you are running Microsoft SQL Server together with MSDTC (COM+),
the pagefile should be at least 1 percent larger than how much RAM is
installed in the system. For example, when you are using 32 GB of RAM,
the pagefile should be at least 32.32 GB of RAM.

I surely hope a 32GB sql server will never use 32GB of ram.

--
Hans

Hans <Hans (AT) nl (DOT) invalid> wrote in news:1239003791.556376 (AT) draco (DOT) amc.nl:

SQL will merrily take whatever RAM you let it, version dependent if I
recall.