Home Forums SQL Server 2008 SQL Server 2008 Administration Memory utilization by a single sqlserver instance alone. RE: Memory utilization by a single sqlserver instance alone.

  • December 3, 2012 at 7:04 am

    #1564864

    Bhuvnesh (12/3/2012)

    and task manager can give you estimated value for sqlserver.exe

    No, Task manager gives exact values, not estimated. It can be wrong because it doesn't count memory allocated via the AWE mechanism which is used when SQL has the locked pages in memory privilege.

    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