• antonio.collins (8/23/2010)[hr

    on a small dev/test server, a large pagefile may be necessary, but a production db server shouldn't have a higher peak commit than its accesible physical ram. in fact, a large pagefile can hinder performance because the OS could start swapping executable pages -- that will kill performance. i would never suggest limping along in a memory starved environment by adding more paging space even if its on an ssd

    It won't hinder performance at all. The memory manager will only swap executable pages if it needs to, irrespective of the pagefile - executable pages wouldn't go to pagefile anyway since they are already backed on disk. They will just be dropped and paged back in as/when needed.

    Gimping the pagefile only reduces the options available to the memory manager and make it more likely to drop executable pages at the expense of paging out (to pagefile) unbacked pages. Leave it alone, it can manage the memory better than you.