Post reply

MemToLeave Purge

  • March 13, 2008 at 9:42 am

    #71713

    Hi,

    Since we are not able to identify what's fillin up the memtoleave pool, is there a way to purge it.

    We are running SQL2000, sp4.

    We also have 2 dll running but they were not called when we got a decrease in the memtoleave pool.

    Thanks,

    keith

  • March 14, 2008 at 9:51 am

    #789735

    Did you have any chance to read the discussion in the link below?

    http://www.sqlservercentral.com/Forums/Topic440567-5-1.aspx

  • March 14, 2008 at 11:09 am

    #789770

    Restart the SQL instance.

    I asked the same question of PSS a couple years back. There's no command, documented or other to clear out memory in MemtoLeave

    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

  • March 14, 2008 at 12:10 pm

    #789804

    Thanks:)

    That's what we've been doing for the last 2 months.

    keith

Viewing 4 posts - 1 through 4 (of 4 total)

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