SQL Server Performance

Failed to reserve contiguous memory

Discussion in 'Preguntas sobre SQL Server en Español.' started by RSuades, May 19, 2004.

  1. RSuades New Member

    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
  2. satya Moderator

  3. Luis Martin Moderator

    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.

  4. RSuades New Member

    Fixed with Microsoft Fix SQL Server build 2000.80.800.0

    Thanks.
  5. satya Moderator

    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.

Share This Page