Post reply

SQL SERVER target memory vs total memory

  • October 24, 2012 at 4:04 pm

    #269010

    Hi All,

    I ran this query

    SELECT object_name,counter_name,instance_name, (cntr_value/1024) as Memory_in_MB, cntr_type FROM sys.dm_os_performance_counters

    WHERE counter_name IN ('Target Server Memory (KB)','Total Server Memory (KB)')

    some servers Total server memory = target server memory --- is this normal ?

    Or Total server < target server ,please let me know which values are preferrable

  • October 25, 2012 at 1:46 am

    #1552543

    Target = total, stable memory allocation

    Target > total, SQL's still allocating memory and building up the caches.

    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