Post reply

Paging in SQL's prospective

  • January 25, 2012 at 5:27 am

    #391401

    Hi,

    What is paging in SQL Server's prospective ? I know it is windows component but I think it plays a bigh role in SQL Server operation also.

    Thanks in advance.

  • January 25, 2012 at 6:05 am

    #1438186

    You may find this article[/url] helpful.

    Regards

    Gianluca

    -- Gianluca Sartori

  • January 25, 2012 at 7:18 am

    #1438226

    If your memory config is correct, SQL will never be paged (written to swap file). SQL uses memory to avoid the cost of disk access, so if SQL's memory is written to a disk file that's pretending to be memory, it's completely negating the point of caching at all.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • January 27, 2012 at 7:00 am

    #1439331

    Somewhere I read paging is that if data pages are not found in cache and those pages have to be retrieved from disk is called paging. Please let me know if this statement is incorrect.

    Thanks in advance.

  • January 27, 2012 at 8:54 am

    #1439442

    It could be called that, but in general paging = memory in and out of the swap file.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 5 posts - 1 through 4 (of 4 total)

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