Thursday, March 29, 2012

Failed to reserve contiguous memory

Guys,
does anyone know what to do when you get this kind of
error message: My server is windows 2000 sp4, sql2000
sp3a, Here is the min and max memory configuration in
sp_config
min memory per query (KB) 512 2147483647
min server memory (MB) 0 2147483647
WARNING: Failed to reserve contiguous memory of Size= 65536.
Buffer Distribution: Stolen=4294948690 Free=412
Procedures=142775
Inram=0 Dirty=1232 Kept=0
I/O=0, Latched=41, Other=105186
Does anyone know what needs to be done. It happened
yester at 4pm and hasn't happened again. Let me know
please. Thanks.
Mary LouChances are it is related to one of these:
http://support.microsoft.com/default.aspx?scid=kb;en-us;832674&Product=sql2k
http://support.microsoft.com/default.aspx?scid=kb;en-us;818095&Product=sql2k
http://support.microsoft.com/default.aspx?scid=kb;en-us;316749&Product=sql2k
Andrew J. Kelly SQL MVP
"Mary Lou" <anonymous@.discussions.microsoft.com> wrote in message
news:197a01c4a25a$62bf7f50$a301280a@.phx.gbl...
> Guys,
> does anyone know what to do when you get this kind of
> error message: My server is windows 2000 sp4, sql2000
> sp3a, Here is the min and max memory configuration in
> sp_config
> min memory per query (KB) 512 2147483647
> min server memory (MB) 0 2147483647
>
> WARNING: Failed to reserve contiguous memory of Size=> 65536.
> Buffer Distribution: Stolen=4294948690 Free=412
> Procedures=142775
> Inram=0 Dirty=1232 Kept=0
> I/O=0, Latched=41, Other=105186
>
> Does anyone know what needs to be done. It happened
> yester at 4pm and hasn't happened again. Let me know
> please. Thanks.
> Mary Lou

No comments:

Post a Comment