-
Error 17803....
Here is the repeating part from SQL2k error log:
[2003-11-06 04:49:07.90 server Error: 17803, Severity: 20, State: 14
2003-11-06 04:49:28.01 server Insufficient memory available..
2003-11-06 04:49:28.70 spid1 LazyWriter: warning, no free buffers found.
2003-11-06 04:49:28.70 spid1 Buffer Distribution: Stolen=64862 Free=0 Procedures=3
Inram=0 Dirty=12 Kept=0
I/O=0, Latched=27, Other=0
2003-11-06 04:49:28.71 spid1 Buffer Counts: Commited=64904 Target=64904 Hashed=39
InternalReservation=537 ExternalReservation=0 Min Free=128
2003-11-06 04:49:28.71 spid1 Procedure Cache: TotalProcs=1 TotalPages=3 InUsePages=3
2003-11-06 04:49:28.71 spid1 Dynamic Memory Manager: Stolen=64865 OS Reserved=328
OS Committed=301
OS In Use=290
Query Plan=8 Optimizer=0
General=657
Utilities=8 Connection=64354
2003-11-06 04:49:28.73 spid1 Global Memory Objects: Resource=353 Locks=118
SQLCache=13 Replication=2
LockBytes=2 ServerGlobal=43
Xact=227
2003-11-06 04:49:28.73 spid1 Query Memory Manager: Grants=0 Waiting=0 Maximum=0 Available=0
2003-11-06 04:49:29.01 server Error: 17803, Severity: 20, State: 14]
From Microsoft Knowledge Base on error 17803: <<http://support.microsoft.com/default...&Product=sql2k>> A Memory Leak Occurs When Cursors Are Opened During a Connection.
It looks all the symptom are quite similar to the above discription. But the fix "may receive addition testing and if you are not severely affected by this problem, Microsoft recommends that you wit for the next service pack."
on this server, sql2k sp3 has been applied. Does anyone have similare issue and applied the fix yet?
thanks
-D
-
p.s. This server has been running around 2 years with the same application. This error about insufficient memory is the first time. And it is ok now after a cool boot.
-D
-
I found similar posting in some other forums. I am curious on your memory settings and system configurations.
see the below 2 links and see whether it is helpful for u.
http://dbforums.com/arch/179/2002/12/610842
http://www.sql-server-performance.co...p?TOPIC_ID=126
-
How often your recycle your box?
-
NT 5.0(2195), Memory Dynamic with 512 MB. Accoring to the error logs, it was stopped and restarted on 10/24 15:31, 10/28 18:21, 11/03 16:26 and 11/06 16:32.
-
attached are 2 files related to configure and memory. but not see the description of the memorystatus, an undocumented sp.
-
dbcc memorystatus
Buffer Distribution Buffers
------------------------------ -----------
Stolen 35175
Free 29
Procedures 1008
Inram 0
Dirty 215
Kept 0
I/O 0
Latched 27
Other 1944
(9 row(s) affected)
Buffer Counts Buffers
------------------------------ -----------
Commited 38398
Target 38398
Hashed 2186
InternalReservation 510
ExternalReservation 0
Min Free 32
(6 row(s) affected)
Procedure Cache Value
------------------------------ -----------
TotalProcs 375
TotalPages 1008
InUsePages 533
(3 row(s) affected)
Dynamic Memory Manager Buffers
------------------------------ -----------
Stolen 36183
OS Reserved 320
OS Committed 297
OS In Use 287
General 590
QueryPlan 996
Optimizer 0
Utilities 8
Connection 34805
(9 row(s) affected)
Global Memory Objects Buffers
------------------------------ -----------
Resource 354
Locks 71
XDES 127
SQLCache 29
Replication 2
LockBytes 2
ServerGlobal 44
(7 row(s) affected)
Query Memory Objects Value
------------------------------ -----------
Grants 0
Waiting 0
Available (Buffers) 2020
Maximum (Buffers) 2020
(4 row(s) affected)
Optimization Queue Value
------------------------------ -----------
Optimizing 0
Waiting 0
Available 4
Maximum 4
(4 row(s) affected)
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
name minimum maximum config_value run_value
----------------------------------- ----------- ----------- ------------ -----------
affinity mask -2147483648 2147483647 0 0
allow updates 0 1 0 0
awe enabled 0 1 0 0
c2 audit mode 0 1 0 0
cost threshold for parallelism 0 32767 5 5
Cross DB Ownership Chaining 0 1 0 0
cursor threshold -1 2147483647 -1 -1
default full-text language 0 2147483647 1033 1033
default language 0 9999 0 0
fill factor (%) 0 100 0 0
index create memory (KB) 704 2147483647 0 0
lightweight pooling 0 1 0 0
locks 5000 2147483647 0 0
max degree of parallelism 0 32 0 0
max server memory (MB) 4 2147483647 2147483647 2147483647
max text repl size (B) 0 2147483647 65536 65536
max worker threads 32 32767 255 255
media retention 0 365 0 0
min memory per query (KB) 512 2147483647 1024 1024
min server memory (MB) 0 2147483647 0 0
nested triggers 0 1 1 1
network packet size (B) 512 65536 4096 4096
open objects 0 2147483647 0 0
priority boost 0 1 0 0
query governor cost limit 0 2147483647 0 0
query wait (s) -1 2147483647 -1 -1
recovery interval (min) 0 32767 0 0
remote access 0 1 1 1
remote login timeout (s) 0 2147483647 20 20
remote proc trans 0 1 0 0
remote query timeout (s) 0 2147483647 600 600
scan for startup procs 0 1 0 0
set working set size 0 1 0 0
show advanced options 0 1 1 1
two digit year cutoff 1753 9999 2049 2049
user connections 0 32767 0 0
user options 0 32767 0 0
