Post reply

PAGEFILE.SYS - Any relation to SS performance?

  • October 20, 2009 at 11:17 am

    #1068363

    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

  • October 20, 2009 at 11:37 am

    #1068381

    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

  • October 20, 2009 at 3:41 pm

    #1068562

    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