Getting message: WARNING: Failed to reserve contiguous memory of Size=

[antzzz]

I'm running SQL Server 2000 SP3 Standard Edition with Windows 2000 on a 4 CPU server with 2GB RAM. I am currently receiving some memory messages in the Error Log like the ff:

WARNING: Failed to reserve contiguous memory of Size= 65536
.
.
.
<With corresponding procedure/buffer cache messages, etc.>

IIS and a HelpDesk web application is currently running on the same machine. There are around 8500 connections when I run sp_who2.

When I use Enterprise Manager, I can't even view the properties of the server saying that it can't load the DLLs. My backup and DBCC jobs are also being affected.

I think the problem lies in the fact that there are too many connections. Is there a way to limit the number of connections?

What are my options?

Appreciate any advice.

THanks

 

[mrdenny]

From what I'm reading on the web there are a couple of things that could be causing this. None of which look like very much fun.

First problem is a Curser Plans error

http://support.microsoft.com/default.aspx?scid=kb;en-us;818095

Next we have a problem that shows up when using the sp_OA procedures a lot

http://support.microsoft.com/kb/282229/EN-US/

(I've seen this one my self before).

Based on what you've said I'm guessing that the first one will be for you.

Denny

--Anything is possible. All it takes is a little research. (Me)