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..
* *******************************************************************************
No comments:
Post a Comment