Post reply

running up a new SQL 2008 R2

  • July 7, 2011 at 6:07 am

    #389922

    Guys,

    I’m in the process of running up a new SQL 2008 R2 server on a Windows Server 2008 R2 Enterprise 64 bit VM and was wondering what the best practice is with regard to paging file sizes? The box will have 4GB of memory. Generally we use 2X the physical memory for all servers.

    Your comments are welcome.

  • July 7, 2011 at 6:18 am

    #1349619

    The paging is handled by the OS and any recommendation provided by the Operating system guide should be good enough.

    http://support.microsoft.com/kb/889654

    You can decide if you want more than 1 page file split across multiple drives also.

    Jayanth Kurup[/url]

  • July 8, 2011 at 12:42 pm

    #1350584

    thanks Jayanth.

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

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