Post reply

MemtoLeave area

  • January 9, 2008 at 6:06 am

    #73952

    Hi,

    Is there a way to see how much memory is free in the memtoleave pool, what's using the memory and how heavily fragmented it is?

    I'm trying to see if the memory issues we are having ('Failed to reserve contiguous memory of Size= 65536'....) are related to memory pressure on the memtoleave area.

    Regards,

    S.

  • January 9, 2008 at 6:43 am

    #766135

    This help?

    http://support.microsoft.com/kb/271624

  • January 9, 2008 at 9:12 am

    #766277

    DBCC MEMORYSTATUS gives you most info about memory. You can also check DBCC MEMUSAGE.

    SQL DBA.

  • January 10, 2008 at 5:45 am

    #766586

    Steve/Sanjay,

    Thanks for your replies, I'll take a look.

    Has anybody had any experience of changing the -g startup parameter to 384MB on SQL Server 2000? Did it have any detrimental side effects? Did it resolve any memory problems they were experiencing?

    Thanks,

    Stephen

  • March 25, 2008 at 2:02 pm

    #793748

    Stephen,

    Did you change the -g parameter. Did that affect your performance etc. I am planning to do a similar thing myself.

    Also, did you manage to get how to see the exact memtoleave allocated and in use

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

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