Post reply

locked_page_allocations kb is zero will this improve or degrade any performance

  • June 29, 2016 at 7:18 am

    #308747

    Hi All,

    I am checking sys.dm_os_process_memory and found that locked_page_allocations_kb is 0 for two of my servers one is production and other is UAT and i found that value in

    locked_page_allocations_kb is 0,

    Can anyone suggest is this better for performance if so how can i do it.

    ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    Save a tree... Please don't waste paper unless you really need to!

    When life puts into problem don't say 'God Why Me' say:w00t: 'Try Me'

  • June 29, 2016 at 7:59 am

    #1887632

    That will only be non-zero if the SQL Server is running with locked pages enabled. Without that, it can't lock pages and hence that value will be zero.

    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 2 posts - 1 through 1 (of 1 total)

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