Post-SP3 Problem

Question

Post-SP3 Problem

Viewing 3 posts - 16 through 17 (of 17 total)

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

stevevincent SSC Veteran Points: 265 More actions · Answer 1

Those settings sound a bit strange Michael. If your server has only 2Gb, surely the HighMemoryLimit must be set lower than that (you need to reserve some RAM for the OS after all). Do you have SQL Server on the same server? If so, that needs quite a bit of RAM too. I suggest you stop the AS service, then launch Task Manager, restart AS and monitor the memory usage of MSMSRV.EXE as it loads up. You need the HighMemoryLimit set to say, 20% more than whatever it peaks at. I'm not sure about the Low limit, but common sense suggests it should be lower than the High limit - how about 1Gb?

Steve

mhweiss SSCarpal Tunnel Points: 4284 More actions · Answer 2

That is exactly what I was thinking, Steve. How does the swap file/paging file size enter into this? Do you know?

I will do as you suggest and let you know what the results are.

Thank you,

Michael

Michael Weiss

stevefromOZ SSC-Forever Points: 43646 More actions · Answer 3

Hi Guys,

Take a quick browse at (watch out for possible line breaks in url)

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

Gives good explanation of minimum, max and default values for AS registry entries.

HTH.

Steve.