SQL Server Performance Forum – Threads Archive

Failed to reserve contiguous memory

Hola. Tengo un SQL Standar SP3A con 2 GB de memoria que al cabo de cierto tiempo trabajando genera el siguiente error: 2003-01-31 16:04:20.25 spid73 WARNING: Failed to reserve contiguous memory of Size= 65536.
2003-01-31 16:04:20.28 spid73 Buffer Distribution: Stolen=51347 Free=232 Procedures=14956 Inram=0 Dirty=4468 Kept=0 I/O=0, Latched=96, Other=98278 2003-01-31
16:04:20.28 spid73 Buffer Counts: Commited=169377 Target=169377 Hashed=102842 InternalReservation=261 ExternalReservation=0 Min Free=128 SegÃºn el Q818095 de Microsoft FIX: Cursor Plans Are Not Removed From the Cache When Virtual Memory Depleted
Se produce a partir del service pack 3 de SQL server, alguiÃ©n me puede dar una soluciÃ³n alternativa al FIX de Microsoft.
RamÃ³n Suades

KBAs:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;282229
http://support.microsoft.com/default.aspx?scid=kb;en-us;818095 way to go. What are the memory settings on SQL?
HTH Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

Solamente para ayudar (Just to help – Translation of Satya question) Satya pregunta cuÃ¡l es el seteo de memoria en las propiedades del SQL Server instalado?.
Luis Martin
Moderator
SQL-Server-Performance.com All postings are provided â€œAS ISâ€ with no warranties for accuracy.

Fixed with Microsoft Fix SQL Server build 2000.80.800.0 Thanks.

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q818414 is the KBA that was fixed for Rsuades problem. (Thanks Luis). Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

]]>