page file RRS feed

  • Question

  • hi all,

    what is the page file ?

     how it is useful in ms sql server ?

    • Edited by SLNSH Saturday, May 11, 2013 12:52 PM
    • Changed type Olaf HelperMVP Sunday, May 12, 2013 5:14 AM More a question rather then a discussion
    Saturday, May 11, 2013 12:27 PM


  • Page files are a type of temporary storage used to extend the available RAM on the computer. The operating system uses page files to temporarily move portions of RAM which is not frequently accessed so that that part of the RAM can be made available for additional processing.

    Page file is not something specific to SQL Server, but more like an overall windows operating system level configuration to maintain the correct health and balancing of the resources.

    I would recommend reading this KB article which provides an overview of page files.

    My Blog

    • Proposed as answer by Olaf HelperMVP Sunday, May 12, 2013 5:14 AM
    • Marked as answer by Fanny Liu Friday, May 17, 2013 9:45 AM
    Saturday, May 11, 2013 2:31 PM

All replies