Post reply

Memory pressure

  • March 18, 2011 at 9:21 pm

    #233364

    I just have a instance got memory pressure. The DBCC MEMORYSTATUS shown the MEMORYCLERK_SQLOPTIMIZER took about 95% buffer pool, i suspect this is not normal.

    I am not sure why it took so many memory, could anybody advise how to troubleshooting this problem? Thanks in advance!

  • March 18, 2011 at 9:21 pm

    #1300879

    The instance is SQL Server 2008 R2 RTM version.

  • March 19, 2011 at 7:12 pm

    #1300993

    I have a few questions for you:

    Is your sql instance on 32- or 64-bit platform?

    What is the RAM on the server?

    Is the instance sharing resources with other applications or SQL instances on the same server?

    Have you set max-memory explicitly or left it at default value?

    In Task Manager, what is the available memory?

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

  • March 20, 2011 at 8:29 pm

    #1301097

    It is 64 bit version and not confiure max server memory. I suspect it is a internal memory pressure issue, not sure whether configure max server memory could fix this.

  • March 21, 2011 at 6:06 am

    #1301214

    Check the "avg page life expectancy" counter.

    If it is consistently lower than 300-500 sec, then you definitely have memory pressure.

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

  • March 21, 2011 at 6:15 am

    #1301220

    Marios Philippopoulos (3/19/2011)

    I have a few questions for you:

    Is your sql instance on 32- or 64-bit platform?

    What is the RAM on the server?

    Is the instance sharing resources with other applications or SQL instances on the same server?

    Have you set max-memory explicitly or left it at default value?

    In Task Manager, what is the available memory?

    Run tis and reply back.

    select * from

    sys.sysperfinfo

    Where counter_name

    in('Target Server Memory (KB)','Total Server Memory (KB)')

    Muthukkumaran Kaliyamoorthy
    https://www.sqlserverblogforum.com/

    • Viewing 6 posts - 1 through 5 (of 5 total)

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