Post reply

Please Clear Up PageFile Size Once and For All

  • May 16, 2011 at 10:00 am

    #250326

    Hi Folks

    I am starting to configure a new Windows 2008 R2 64-bit Server with 8GB of RAM to run SQL Server 2008 R2 and I need to be able to create a full memory dump if the system fails

    I have read several articles and visited several forums and there is no consensus it seems on what the pagefile should be and now I am totally confused.

    If anyone has been down this alley, I would appreciate it

    Thanks

    Jim

    Advise has been:

    SQL Server does not use pagefile if it is dedicated, it uses TEMPDB so you do not need one

    On Windows 2008 and 2008R2 PageFile should equal RAM

    You only need 2GB

    If your system crashes you need RAM+1MB

    If your system crashes you need RAM+300MB

    Pagefile = 1.5*RAM

  • May 16, 2011 at 12:18 pm

    #1325370

    For my 2008 R2 WinServers I configure with system managed option with the dump option selected to capture the complete dump. This configuration generally results in a pagefile of RAM+300MB.

    Hope this helps.

  • May 16, 2011 at 12:20 pm

    #1325371

    Thanks GreyBeard

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply