Thursday, March 29, 2012

Failed to reserve contiguous memory

Hello people

I have a problem with my Sql,i Run SQL Server 2000 SP4 with Windows 2003 Server and i got the Hyper Threading Technology.

My log is here some one can help?

2007-02-27 07:31:12.30 spid59 WARNING: Failed to reserve contiguous memory of Size= 65536.
2007-02-27 07:31:12.31 spid59 Buffer Distribution: Stolen=609 Free=911 Procedures=523
Inram=0 Dirty=63344 Kept=0
I/O=0, Latched=32, Other=47333

2007-02-27 07:31:12.31 spid59 Buffer Counts: Commited=112752 Target=113711 Hashed=110709
InternalReservation=122 ExternalReservation=2216 Min Free=128 Visible= 113711

2007-02-27 07:31:12.31 spid59 Procedure Cache: TotalProcs=251 TotalPages=523 InUsePages=291

2007-02-27 07:31:12.31 spid59 Dynamic Memory Manager: Stolen=1132 OS Reserved=960
OS Committed=938
OS In Use=924
Query Plan=681 Optimizer=0
General=1169
Utilities=10 Connection=89

2007-02-27 07:31:12.31 spid59 Global Memory Objects: Resource=960 Locks=86
SQLCache=43 Replication=2
LockBytes=2 ServerGlobal=25
Xact=52

2007-02-27 07:31:12.31 spid59 Query Memory Manager: Grants=1 Waiting=0 Maximum=84834 Available=82618

2007-02-27 07:38:01.30 spid57 CImageHelper::Init () Failed load of dbghelp.dll - Not enough storage is available to process this command.

2007-02-27 07:38:01.30 spid57 CImageHelper::Init () Failed load of dbghelp.dll - Not enough storage is available to process this command.

***Symbol load failed - Proceed to dump without any symbols
*Stack Dump being sent to d:\sql_sdb\MSSQL\log\SQLDump0058.txt

2007-02-27 07:38:01.30 spid57 Error: 0, Severity: 19, State: 0

2007-02-27 07:38:01.30 spid57 SqlDumpExceptionHandler: Process 57 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process..
* *******************************************************************************
*
* BEGIN STACK DUMP:
* 02/27/07 07:38:01 spid 57
*
* Exception Address = 1047100B
* Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
* Access Violation occurred reading address 00000010
* Input Buffer 46 bytes -
* exec dbo.sp_good_prodP2
*
*
* MODULE BASE END SIZE
*
* Edi: 00000001:
* Esi: 000000A0:
* Eax: 00000000:
* Ebx: 00000000:
* Ecx: 19D417F8: 00000001 000000A0 00000002 00000064 00000000 18720048
* Edx: 1715A1C0: 08DB1538 0057005C 004E0049 004F0044 00530057 0073005C
* Eip: 1047100B: 8B104B8B F7D233C6 D28557F1 748B1E74 10681824 8D104730
* Ebp: 08B3E618: 18963218 060589B0 19D417F8 19E57580 18720048 000000A0
* SegCs: 0000001B:
* EFlags: 00010246: 005C003A 00720050 0067006F 00610072 0020006D 00690046
* Esp: 08B3E5E0: 16591DC8 08B3E618 19E57580 0605FA1D 00000000 19E57580
* SegSs: 00000023:
* *******************************************************************************
* -
* Short Stack Dump
* 1047100B Module(UNKNOWN+00000000)
* 060589B0 Module(UNKNOWN+00000000)
* -
2007-02-27 07:38:01.33 spid57 CImageHelper::Init () Failed load of dbghelp.dll - Not enough storage is available to process this command.

2007-02-27 07:38:04.69 spid57 Stack Signature for the dump is 0x268BA9A6

2007-02-27 07:38:04.70 spid57 Error: 0, Severity: 19, State: 0

2007-02-27 07:38:04.70 spid57 language_exec: Process 57 generated an access violation. SQL Server is terminating this process..

2007-02-27 07:58:59.03 spid57 WARNING: Failed to reserve contiguous memory of Size= 65536.

2007-02-27 07:58:59.05 spid57 Buffer Distribution: Stolen=438 Free=189 Procedures=524
Inram=0 Dirty=63086 Kept=0
I/O=0, Latched=36, Other=47606

2007-02-27 07:58:59.05 spid57 Buffer Counts: Commited=111879 Target=112935 Hashed=110728
InternalReservation=154 ExternalReservation=0 Min Free=128 Visible= 112935

2007-02-27 07:58:59.05 spid57 Procedure Cache: TotalProcs=252 TotalPages=524 InUsePages=291

2007-02-27 07:58:59.05 spid57 Dynamic Memory Manager: Stolen=962 OS Reserved=920
OS Committed=898
OS In Use=894
Query Plan=488 Optimizer=0
General=1165
Utilities=10 Connection=86

2007-02-27 07:58:59.05 spid57 Global Memory Objects: Resource=960 Locks=77
SQLCache=43 Replication=2
LockBytes=2 ServerGlobal=25
Xact=52

2007-02-27 07:58:59.05 spid57 Query Memory Manager: Grants=0 Waiting=0 Maximum=84256 Available=84256

2007-02-27 08:09:50.45 spid57 WARNING: Failed to reserve contiguous memory of Size= 65536.

2007-02-27 08:09:50.45 spid57 Buffer Distribution: Stolen=436 Free=187 Procedures=526
Inram=0 Dirty=63089 Kept=0
I/O=0, Latched=36, Other=47605

2007-02-27 08:09:50.45 spid57 Buffer Counts: Commited=111879 Target=112927 Hashed=110730
InternalReservation=158 ExternalReservation=0 Min Free=128 Visible= 112927

2007-02-27 08:09:50.45 spid57 Procedure Cache: TotalProcs=253 TotalPages=526 InUsePages=291

2007-02-27 08:09:50.45 spid57 Dynamic Memory Manager: Stolen=962 OS Reserved=920
OS Committed=898
OS In Use=894
Query Plan=488 Optimizer=0
General=1165
Utilities=10 Connection=86

2007-02-27 08:09:50.45 spid57 Global Memory Objects: Resource=960 Locks=77
SQLCache=43 Replication=2
LockBytes=2 ServerGlobal=25
Xact=52

2007-02-27 08:09:50.45 spid57 Query Memory Manager: Grants=0 Waiting=0 Maximum=84250 Available=84250

2007-02-27 08:18:00.67 spid60 CImageHelper::Init () Failed load of dbghelp.dll - Not enough storage is available to process this command.

2007-02-27 08:18:00.68 spid60 CImageHelper::Init () Failed load of dbghelp.dll - Not enough storage is available to process this command.

***Symbol load failed - Proceed to dump without any symbols
*Stack Dump being sent to d:\sql_sdb\MSSQL\log\SQLDump0059.txt

2007-02-27 08:18:00.68 spid60 Error: 0, Severity: 19, State: 0

2007-02-27 08:18:00.68 spid60 SqlDumpExceptionHandler: Process 60 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process..
* *******************************************************************************

Sounds like you ran out of memory. Add more memory and then check the configuration settings in Books Online for Server Memory. It will guide you through what you need to do.sql

No comments:

Post a Comment