getting warning : Failed to reserve contiguous memory of Size= 65536.

• anoop.mig29

  SSCrazy

  Points: 2218

  More actions

  November 1, 2013 at 10:44 pm

  #104219

  Hi at one of our client side we are continuously geeting below warning every evening around 6 pm

  2013-10-31 18:08:18.96 spid57 WARNING: Failed to reserve contiguous memory of Size= 65536. 0

  2013-10-31 18:08:19.01 spid57 Buffer Distribution: Stolen=4294951127 Free=1296 Procedures=357067 0

  Inram=0 Dirty=129775 Kept=0 0

  I/O=0, Latched=129, Other=307803 0

  2013-10-31 18:08:19.01 spid57 Buffer Counts: Commited=779901 Target=779901 Hashed=437707 0

  InternalReservation=542 ExternalReservation=0 Min Free=484 Visible= 454232 0

  2013-10-31 18:08:19.01 spid57 Procedure Cache: TotalProcs=72283 TotalPages=357067 InUsePages=211694 0

  2013-10-31 18:08:19.01 spid57 Dynamic Memory Manager: Stolen=340898 OS Reserved=34688 0

  OS Committed=34626 0

  OS In Use=34622 0

  Query Plan=357124 Optimizer=0 0

  General=17849 0

  Utilities=6 Connection=317 0

  2013-10-31 18:08:19.01 spid57 Global Memory Objects: Resource=13232 Locks=61 0

  SQLCache=4509 Replication=2 0

  LockBytes=2 ServerGlobal=21 0

  Xact=29 0

  2013-10-31 18:08:19.01 spid57 Query Memory Manager: Grants=0 Waiting=0 Maximum=194018 Available=194018 0

  2013-10-31 18:15:06.82 backup Log backed up: Database: GSD, creation date(time): 2013/02/16(23:32:58), first LSN: 12593068:1262:1, last LSN: 12593122:44987:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'p:\GSD_tlog_201310311815 0

  .TRN'}). 1

  2013-10-31 18:17:06.35 spid57 WARNING: Failed to reserve contiguous memory of Size= 65536. 0

  2013-10-31 18:17:06.38 spid57 Buffer Distribution: Stolen=4294949029 Free=816 Procedures=359220 0

  Inram=0 Dirty=130314 Kept=0 0

  I/O=0, Latched=128, Other=307690 0

  2013-10-31 18:17:06.38 spid57 Buffer Counts: Commited=779901 Target=779901 Hashed=438132 0

  InternalReservation=537 ExternalReservation=0 Min Free=256 Visible= 454232 0

  2013-10-31 18:17:06.38 spid57 Procedure Cache: TotalProcs=78742 TotalPages=359220 InUsePages=226014 0

  2013-10-31 18:17:06.38 spid57 Dynamic Memory Manager: Stolen=340953 OS Reserved=34688 0

  OS Committed=34626 0

  OS In Use=34624 0

  Query Plan=359258 Optimizer=0 0

  General=15839 0

  Utilities=6 Connection=245 0

  2013-10-31 18:17:06.38 spid57 Global Memory Objects: Resource=11178 Locks=186 0

  SQLCache=4545 Replication=2 0

  LockBytes=2 ServerGlobal=21 0

  Xact=29 0

  2013-10-31 18:17:06.38 spid57 Query Memory Manager: Grants=0 Waiting=0 Maximum=185494 Available=185494 0

  2013-10-31 18:25:40.76 spid57 WARNING: Failed to reserve contiguous memory of Size= 65536. 0

  2013-10-31 18:25:40.79 spid57 Buffer Distribution: Stolen=4294948512 Free=565 Procedures=359842 0

  Inram=0 Dirty=131586 Kept=0 0

  I/O=0, Latched=114, Other=306578 0

  2013-10-31 18:25:40.79 spid57 Buffer Counts: Commited=779901 Target=779901 Hashed=438278 0

  InternalReservation=512 ExternalReservation=0 Min Free=248 Visible= 454232 0

  2013-10-31 18:25:40.79 spid57 Procedure Cache: TotalProcs=77691 TotalPages=359842 InUsePages=240104 0

  2013-10-31 18:25:40.79 spid57 Dynamic Memory Manager: Stolen=341058 OS Reserved=34688 0

  OS Committed=34626 0

  OS In Use=34624 0

  Query Plan=359866 Optimizer=0 0

  General=15447 0

  Utilities=6 Connection=149 0

  2013-10-31 18:25:40.79 spid57 Global Memory Objects: Resource=11335 Locks=82 0

  SQLCache=3990 Replication=2 0

  LockBytes=2 ServerGlobal=21 0

  Xact=29 0

  2013-10-31 18:25:40.79 spid57 Query Memory Manager: Grants=0 Waiting=0 Maximum=175440 Available=175440 0 1

  2013-10-31 18:34:35.85 spid57 WARNING: Failed to reserve contiguous memory of Size= 65536. 0

  2013-10-31 18:34:35.90 spid57 Buffer Distribution: Stolen=4294949258 Free=1585 Procedures=358712 0

  Inram=0 Dirty=130416 Kept=0 0

  I/O=0, Latched=126, Other=307100 0

  2013-10-31 18:34:35.90 spid57 Buffer Counts: Commited=779901 Target=779901 Hashed=437642 0

  InternalReservation=498 ExternalReservation=0 Min Free=484 Visible= 454232 0

  2013-10-31 18:34:35.90 spid57 Procedure Cache: TotalProcs=72929 TotalPages=358712 InUsePages=236525 0

  2013-10-31 18:34:35.90 spid57 Dynamic Memory Manager: Stolen=340674 OS Reserved=34688 0

  OS Committed=34626 0

  OS In Use=34624 0

  Query Plan=358746 Optimizer=0 0

  General=16185 0

  Utilities=6 Connection=153 0

  2013-10-31 18:34:35.90 spid57 Global Memory Objects: Resource=12141 Locks=69 0

  SQLCache=3923 Replication=2 0

  LockBytes=2 ServerGlobal=21 0

  Xact=29 0

  2013-10-31 18:34:35.90 spid57 Query Memory Manager: Grants=0 Waiting=0 Maximum=177152 Available=177152 0

  2013-10-31 18:43:06.96 spid57 WARNING: Failed to reserve contiguous memory of Size= 65536. 0

  2013-10-31 18:43:06.99 spid57 Buffer Distribution: Stolen=4294948938 Free=1058 Procedures=359549 0

  Inram=0 Dirty=131041 Kept=0 0

  I/O=0, Latched=124, Other=306487 0

  2013-10-31 18:43:06.99 spid57 Buffer Counts: Commited=779901 Target=779901 Hashed=437652 0

  InternalReservation=504 ExternalReservation=0 Min Free=488 Visible= 454232 0

  2013-10-31 18:43:06.99 spid57 Procedure Cache: TotalProcs=73073 TotalPages=359549 InUsePages=227526 0

  2013-10-31 18:43:06.99 spid57 Dynamic Memory Manager: Stolen=341191 OS Reserved=34688 0

  OS Committed=34626 0

  OS In Use=34624 0

  Query Plan=359586 Optimizer=0 0

  General=15890 0

  Utilities=6 Connection=126 0

  2013-10-31 18:43:06.99 spid57 Global Memory Objects: Resource=11872 Locks=67 0

  SQLCache=3897 Replication=2 0

  LockBytes=2 ServerGlobal=21 0

  Xact=29 0

  2013-10-31 18:43:06.99 spid57 Query Memory Manager: Grants=0 Waiting=0 Maximum=168996 Available=168996

  here are server and os details

  ProductVersion :8.00.2039

  sp:SP4

  Ram : 12287 (MB)

  processors : 4

  awe is enabled

  min memory is is 1024

  max memory is is 7169

  Server Type / Model :IBM eserver xSeries 236 -[884111A]

  No. Of CPUs : 2

  Operating System : Microsoft Windows Server 2003 R2, Enterprise Edition

  Version : Enterprise Edition