Post reply

Memory related questions?

  • February 7, 2014 at 5:25 am

    #282252

    Version SQL Enterprise edition 64 bit with SP2 and CU1,

    Total memory 32 GB,

    I resized the max memory up to 8 GB in SQL instance side. But Total Memory = Target memory both are same values 8388608 always, so SQL instance using all allocated memory, is the normal memory usages?

    There is no CLR feature and object are not configured in database.

    rgds

    ananda

  • February 7, 2014 at 5:35 am

    #1686985

    Target and total memory are measured in KB. 8GB = 8*1024 MB = 8*1024*1024 KB = 8 388 608KB. So SQL is using exactly the amount of memory you told it that it could use.

    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

  • February 7, 2014 at 5:45 am

    #1686987

    Thanks .. So SQL instance could used 8 GB max memory .. just i want to know, is the normal usages?

    For the best system, It should Target memory should be less than Total memory.

  • February 7, 2014 at 6:24 am

    #1687006

    SQL will use as much memory as it is allowed to. By setting max server memory to 8GB, you've told it that it may use 8GB and hence it will use 8GB.

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

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