Post reply

SQL HIGH memory Utilization

  • August 10, 2011 at 1:03 am

    #255358

    HI All,

    In my db Serevr we have 16 GB Ram , SQL server is taking 11.2 Gb Ram .

    I added perfmon counters for Available MBbytes [now its 300] .

    If any possibilty can i release the Sql server memory .

    Regards,

    Lavanya Sri

  • August 10, 2011 at 1:07 am

    #1366404

    What's server max memory set at?

    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

  • August 10, 2011 at 1:08 am

    #1366405

    Out of 16GB, 4GB is available for OS and other applications. That is ideal amount.

    I suggest you set SQL Server max memory to 12GB.

    Why do you want to release the SQL Server memory? Any issues?

  • August 10, 2011 at 2:52 am

    #1366429

    hI,

    Max memory seetings : 14 GB out of 16 GB RAM [In SQl server management studio]

    SQL server :memory Manager [perfmon counter]

    Target Server memory: 11,382,584.000

    Toatl Server Memory :11,159,272.000

    Memory : [perfmon counter]

    Available MBytes : 455.000

    Thanks,

    Lavanys Sri

  • August 10, 2011 at 3:20 am

    #1366434

    select * from sys.dm_os_performance_counters

    where counter_name like '%memory%'

    Could you post the result for the above query?

    Jayanth Kurup[/url]

  • August 10, 2011 at 3:29 am

    #1366437

    Is there any other application on the server?

    You can reduce the max memory from 14 GB to 12 GB, so that OS and other applications have enough memory.

  • August 10, 2011 at 3:45 am

    #1366440

    This is DB server No other applications are running .

    Please see the below figures ::

    Max memory seetings : 14 GB out of 16 GB RAM [In SQl server management studio]

    SQL server :memory Manager [perfmon counter]

    Target Server memory: 11,382,584.000

    Toatl Server Memory :11,159,272.000

    Memory : [perfmon counter]

    Available MBytes : 455.000

  • August 10, 2011 at 5:46 am

    #1366483

    HI Gila,

    please reply to mail pleaseee

  • August 10, 2011 at 7:11 am

    #1366527

    SQL Server is going to take all the memory you give it. 2gb out of 16gb is probably just fine, but if you feel it's not, or there seem to be issues, reduce the max memory on SQL Server.

    BTW, if you have further questions, keep them on the board here, not in emails. Unless you're offering Gail paid work. This way, other people who have the same question that you do will get answers as well.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • August 10, 2011 at 8:43 am

    #1366615

    Lavanyasri (8/10/2011)

    HI Gila,

    please reply to mail pleaseee

    I don't answer questions via mail (unless you're a paying client) Besides, I had no mail from you.

    As for recommendation:

    Suresh B. (8/10/2011)

    You can reduce the max memory from 14 GB to 12 GB, so that OS and other applications have enough memory.

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

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