pagefile

Discussion in 'microsoft.public.sqlserver.clustering' started by Hans, Apr 6, 2009.

  1. Hans

    Hans Guest

    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, Apr 6, 2009
    #1
    1. Advertisements

  2. Hans

    s_m_b Guest

    SQL will merrily take whatever RAM you let it, version dependent if I
    recall.
     
    s_m_b, Apr 22, 2009
    #2
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.