PAGEFILE.SYS - Any relation to SS performance?

  • Yes I do not have the pagefile.sys set up (there is no pagefile.sys is any of the drives) 'No Paging File' is setup for the drives.

    Page Faults/sec is at 799

  • you need to setup a page file! SQL uses it.

    example. you have a large qry many big table lots of memory, sql will need to do a hash match join; it will ask for a memory grant from SQL server it asked for the correct amount no harm....if it get it wrong it need to fail over to the page file.. in order to finish....there other ex...bu regardless it need to be there

  • sure. I will add it.

    before that what perfmon counters can i run to see before and after permformance metrics.

    thanks.

Viewing 3 posts - 16 through 17 (of 17 total)

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