How to configure MemToLeave memory option? -- sql server (microsoft)

pshroads NO[at]SPAM gmail.com
3/21/2006 2:12:32 PM

I have been encountering errors on a couple of my SQL Servers and in
researching the problem I think that I may need to configure more
MemToLeave space. I have not been able to find any articles that
suggest how to go about calculating how much MemToLeave I need though.

I use AWE to a fixed 5.5 GB of memory dedicated to SQL Server. Does the
MemToLeave come from that 5.5 GB? How does one go about figuring out
how much MemToLeave to assign?

Thanks

Andrew J. Kelly
3/21/2006 7:20:27 PM

It would help if you posted what those errors were so we could answer a
little more intelligently. How much memory do you have overall?
This should get you started.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsqldev/html/sqldev_01262004.asp

--
Andrew J. Kelly SQL MVP

[quoted text, click to view]

sql server (microsoft) : How to configure MemToLeave memory option?