"Insufficient memory available" on SQL 2000

Hi All,
We have SQL 2000 ent and Windows 2003 , in a few day , restart many
time the error message in event log is "Error: 17803, Severity: 20, State:
14
Insufficient memory available."
i try open SQL profiler and use performance monitor , but i don't know how
to fix ? in profiler display error log , but i don't know is server problem
or application problem , how to check the problem ? help
SQL 2000 Ent ,enable AWE
Windows 2003 ent enable PAE
RAM : 16 GB
In Profiler error :
" 2007-09-18 04:54:49.51 spid56 BPool::Map: no remappable address found."
"2007-09-18 04:54:49.54 spid56 Buffer Distribution: Stolen=122023
Free=949769 Procedures=7
Inram=0 Dirty=236616 Kept=0
I/O=0, Latched=194, Other=107327"
"2007-09-18 04:54:49.54 spid56 Buffer Counts: Commited=1415936
Target=1415936 Hashed=344137
InternalReservation=360 ExternalReservation=0 Min Free=128 Visible= 191272"
"2007-09-18 04:54:49.54 spid56 Procedure Cache: TotalProcs=6
TotalPages=7 InUsePages=4"
"2007-09-18 04:54:49.54 spid56 Dynamic Memory Manager: Stolen=122029 OS
Reserved=3168
OS Committed=3112
OS In Use=3108
Query Plan=96903 Optimizer=1
General=24144
Utilities=160 Connection=3834 "
"2007-09-18 04:54:49.54 spid56 Dynamic Memory Manager: Stolen=122029 OS
Reserved=3168
OS Committed=3112
OS In Use=3108
Query Plan=96903 Optimizer=1
General=24144
Utilities=160 Connection=3834"
"2007-09-18 04:54:49.54 spid56 Query Memory Manager: Grants=0 Waiting=0
Maximum=52143 Available=52143"
"Error: 701, Severity: 17, State: 132"
"2007-09-18 04:54:49.56 spid56 BPool::Map: no remappable address found."
"2007-09-18 04:54:49.59 spid56 Buffer Distribution: Stolen=122022
Free=949770 Procedures=7
Inram=0 Dirty=236616 Kept=0
I/O=0, Latched=194, Other=107327"
"2007-09-18 04:54:49.59 spid56 Buffer Counts: Commited=1415936
Target=1415936 Hashed=344137
InternalReservation=360 ExternalReservation=0 Min Free=128 Visible= 191272"
"2007-09-18 04:54:49.59 spid56 Procedure Cache: TotalProcs=6
TotalPages=7 InUsePages=4"
......
how to fix this , i need restart the server mant time on everyday , HELP !!!Check out the following stuff from System Monitor:
Memory: Available MBytes
Memory: Page Faults\sec
MSSQL$<instance_name>: Buffer Manager: Buffer cache hit ratio
MSSQL$<instance_name>: Buffer Manager: Page life expectancy
MSSQL$<instance_name>: General Statistics: User Connections
Physical Disk: % Disk Time
Physical Disk: Disk Read Bytes\sec
Physical Disk: Disk Write Bytes\sec
Physical Disk: Avg. Disk Queue Length
Processor: % Processor Time
System: Processor Queue Length
Did you restarted your Windows Server after setting up PAE and same for SQL
Server's AWE setting. You need to restart your SQL Server service to take
effect this setting.
Please let me know the values of the counters above. (Don't analyze only for
2-3 mins. Give them at least 1 hour to work and do it in peak-hours)
Ekrem Önsoy
"pcnetnet" <pcnetnet@.yahoo.com.hk> wrote in message
news:e3Te6Yh%23HHA.5160@.TK2MSFTNGP05.phx.gbl...
> Hi All,
> We have SQL 2000 ent and Windows 2003 , in a few day , restart many
> time the error message in event log is "Error: 17803, Severity: 20,
> State:
> 14
> Insufficient memory available."
> i try open SQL profiler and use performance monitor , but i don't know how
> to fix ? in profiler display error log , but i don't know is server
> problem
> or application problem , how to check the problem ? help
> SQL 2000 Ent ,enable AWE
> Windows 2003 ent enable PAE
> RAM : 16 GB
> In Profiler error :
> " 2007-09-18 04:54:49.51 spid56 BPool::Map: no remappable address
> found."
> "2007-09-18 04:54:49.54 spid56 Buffer Distribution: Stolen=122023
> Free=949769 Procedures=7
> Inram=0 Dirty=236616 Kept=0
> I/O=0, Latched=194, Other=107327"
> "2007-09-18 04:54:49.54 spid56 Buffer Counts: Commited=1415936
> Target=1415936 Hashed=344137
> InternalReservation=360 ExternalReservation=0 Min Free=128 Visible=> 191272"
> "2007-09-18 04:54:49.54 spid56 Procedure Cache: TotalProcs=6
> TotalPages=7 InUsePages=4"
> "2007-09-18 04:54:49.54 spid56 Dynamic Memory Manager: Stolen=122029
> OS
> Reserved=3168
> OS Committed=3112
> OS In Use=3108
> Query Plan=96903 Optimizer=1
> General=24144
> Utilities=160 Connection=3834 "
> "2007-09-18 04:54:49.54 spid56 Dynamic Memory Manager: Stolen=122029
> OS
> Reserved=3168
> OS Committed=3112
> OS In Use=3108
> Query Plan=96903 Optimizer=1
> General=24144
> Utilities=160 Connection=3834"
> "2007-09-18 04:54:49.54 spid56 Query Memory Manager: Grants=0
> Waiting=0
> Maximum=52143 Available=52143"
> "Error: 701, Severity: 17, State: 132"
> "2007-09-18 04:54:49.56 spid56 BPool::Map: no remappable address
> found."
> "2007-09-18 04:54:49.59 spid56 Buffer Distribution: Stolen=122022
> Free=949770 Procedures=7
> Inram=0 Dirty=236616 Kept=0
> I/O=0, Latched=194, Other=107327"
> "2007-09-18 04:54:49.59 spid56 Buffer Counts: Commited=1415936
> Target=1415936 Hashed=344137
> InternalReservation=360 ExternalReservation=0 Min Free=128 Visible=> 191272"
> "2007-09-18 04:54:49.59 spid56 Procedure Cache: TotalProcs=6
> TotalPages=7 InUsePages=4"
> ......
> how to fix this , i need restart the server mant time on everyday , HELP
> !!!
>
>
>
>|||pcnetnet (pcnetnet@.yahoo.com.hk) writes:
> We have SQL 2000 ent and Windows 2003 , in a few day , restart
> many time the error message in event log is "Error: 17803, Severity:
> 20, State: 14 Insufficient memory available." i try open SQL profiler
> and use performance monitor , but i don't know how to fix ? in profiler
> display error log , but i don't know is server problem or application
> problem , how to check the problem ? help
That looks really bad. I was about to suggest that you should open a
case with Microsoft, but as I searched in Books Online for error
17803, I found something interesting: it's listed in a section for
for error codes listed by Open Data Services. So maybe this is due
to a memory leak in an extended stored procedure?
Do you if there are any extended stored procedures installed on your
system (beside those that ship with SQL Server)? Would it be possible
to keep them from running for a while to see if the problem goes away.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx|||Hi ekrem,
i have restart the server to take the effect , but the same case, i have
the momitor file , how to post to this ?
"Ekrem Önsoy" <ekrem@.btegitim.com> wrote in message
news:4F41E891-DC4A-4D2C-89C3-52441BDB998A@.microsoft.com...
> Check out the following stuff from System Monitor:
> Memory: Available MBytes
> Memory: Page Faults\sec
> MSSQL$<instance_name>: Buffer Manager: Buffer cache hit ratio
> MSSQL$<instance_name>: Buffer Manager: Page life expectancy
> MSSQL$<instance_name>: General Statistics: User Connections
> Physical Disk: % Disk Time
> Physical Disk: Disk Read Bytes\sec
> Physical Disk: Disk Write Bytes\sec
> Physical Disk: Avg. Disk Queue Length
> Processor: % Processor Time
> System: Processor Queue Length
> Did you restarted your Windows Server after setting up PAE and same for
> SQL Server's AWE setting. You need to restart your SQL Server service to
> take effect this setting.
> Please let me know the values of the counters above. (Don't analyze only
> for 2-3 mins. Give them at least 1 hour to work and do it in peak-hours)
>
> --
> Ekrem Önsoy
>
> "pcnetnet" <pcnetnet@.yahoo.com.hk> wrote in message
> news:e3Te6Yh%23HHA.5160@.TK2MSFTNGP05.phx.gbl...
>> Hi All,
>> We have SQL 2000 ent and Windows 2003 , in a few day , restart
>> many
>> time the error message in event log is "Error: 17803, Severity: 20,
>> State:
>> 14
>> Insufficient memory available."
>> i try open SQL profiler and use performance monitor , but i don't know
>> how
>> to fix ? in profiler display error log , but i don't know is server
>> problem
>> or application problem , how to check the problem ? help
>> SQL 2000 Ent ,enable AWE
>> Windows 2003 ent enable PAE
>> RAM : 16 GB
>> In Profiler error :
>> " 2007-09-18 04:54:49.51 spid56 BPool::Map: no remappable address
>> found."
>> "2007-09-18 04:54:49.54 spid56 Buffer Distribution: Stolen=122023
>> Free=949769 Procedures=7
>> Inram=0 Dirty=236616 Kept=0
>> I/O=0, Latched=194, Other=107327"
>> "2007-09-18 04:54:49.54 spid56 Buffer Counts: Commited=1415936
>> Target=1415936 Hashed=344137
>> InternalReservation=360 ExternalReservation=0 Min Free=128 Visible=>> 191272"
>> "2007-09-18 04:54:49.54 spid56 Procedure Cache: TotalProcs=6
>> TotalPages=7 InUsePages=4"
>> "2007-09-18 04:54:49.54 spid56 Dynamic Memory Manager: Stolen=122029
>> OS
>> Reserved=3168
>> OS Committed=3112
>> OS In Use=3108
>> Query Plan=96903 Optimizer=1
>> General=24144
>> Utilities=160 Connection=3834 "
>> "2007-09-18 04:54:49.54 spid56 Dynamic Memory Manager: Stolen=122029
>> OS
>> Reserved=3168
>> OS Committed=3112
>> OS In Use=3108
>> Query Plan=96903 Optimizer=1
>> General=24144
>> Utilities=160 Connection=3834"
>> "2007-09-18 04:54:49.54 spid56 Query Memory Manager: Grants=0
>> Waiting=0
>> Maximum=52143 Available=52143"
>> "Error: 701, Severity: 17, State: 132"
>> "2007-09-18 04:54:49.56 spid56 BPool::Map: no remappable address
>> found."
>> "2007-09-18 04:54:49.59 spid56 Buffer Distribution: Stolen=122022
>> Free=949770 Procedures=7
>> Inram=0 Dirty=236616 Kept=0
>> I/O=0, Latched=194, Other=107327"
>> "2007-09-18 04:54:49.59 spid56 Buffer Counts: Commited=1415936
>> Target=1415936 Hashed=344137
>> InternalReservation=360 ExternalReservation=0 Min Free=128 Visible=>> 191272"
>> "2007-09-18 04:54:49.59 spid56 Procedure Cache: TotalProcs=6
>> TotalPages=7 InUsePages=4"
>> ......
>> how to fix this , i need restart the server mant time on everyday , HELP
>> !!!
>>
>>
>>
>>
>|||Attach file to your message and send it.
I hope it's not a big issue as Erland mentioned.
--
Ekrem Önsoy
"Pcnetnet" <pcnetnet@.yahoo.com.hk> wrote in message
news:%232SKRom%23HHA.748@.TK2MSFTNGP04.phx.gbl...
> Hi ekrem,
> i have restart the server to take the effect , but the same case, i
> have the momitor file , how to post to this ?
> "Ekrem Önsoy" <ekrem@.btegitim.com> wrote in message
> news:4F41E891-DC4A-4D2C-89C3-52441BDB998A@.microsoft.com...
>> Check out the following stuff from System Monitor:
>> Memory: Available MBytes
>> Memory: Page Faults\sec
>> MSSQL$<instance_name>: Buffer Manager: Buffer cache hit ratio
>> MSSQL$<instance_name>: Buffer Manager: Page life expectancy
>> MSSQL$<instance_name>: General Statistics: User Connections
>> Physical Disk: % Disk Time
>> Physical Disk: Disk Read Bytes\sec
>> Physical Disk: Disk Write Bytes\sec
>> Physical Disk: Avg. Disk Queue Length
>> Processor: % Processor Time
>> System: Processor Queue Length
>> Did you restarted your Windows Server after setting up PAE and same for
>> SQL Server's AWE setting. You need to restart your SQL Server service to
>> take effect this setting.
>> Please let me know the values of the counters above. (Don't analyze only
>> for 2-3 mins. Give them at least 1 hour to work and do it in peak-hours)
>>
>> --
>> Ekrem Önsoy
>>
>> "pcnetnet" <pcnetnet@.yahoo.com.hk> wrote in message
>> news:e3Te6Yh%23HHA.5160@.TK2MSFTNGP05.phx.gbl...
>> Hi All,
>> We have SQL 2000 ent and Windows 2003 , in a few day , restart
>> many
>> time the error message in event log is "Error: 17803, Severity: 20,
>> State:
>> 14
>> Insufficient memory available."
>> i try open SQL profiler and use performance monitor , but i don't know
>> how
>> to fix ? in profiler display error log , but i don't know is server
>> problem
>> or application problem , how to check the problem ? help
>> SQL 2000 Ent ,enable AWE
>> Windows 2003 ent enable PAE
>> RAM : 16 GB
>> In Profiler error :
>> " 2007-09-18 04:54:49.51 spid56 BPool::Map: no remappable address
>> found."
>> "2007-09-18 04:54:49.54 spid56 Buffer Distribution: Stolen=122023
>> Free=949769 Procedures=7
>> Inram=0 Dirty=236616 Kept=0
>> I/O=0, Latched=194, Other=107327"
>> "2007-09-18 04:54:49.54 spid56 Buffer Counts: Commited=1415936
>> Target=1415936 Hashed=344137
>> InternalReservation=360 ExternalReservation=0 Min Free=128 Visible=>> 191272"
>> "2007-09-18 04:54:49.54 spid56 Procedure Cache: TotalProcs=6
>> TotalPages=7 InUsePages=4"
>> "2007-09-18 04:54:49.54 spid56 Dynamic Memory Manager: Stolen=122029
>> OS
>> Reserved=3168
>> OS Committed=3112
>> OS In Use=3108
>> Query Plan=96903 Optimizer=1
>> General=24144
>> Utilities=160 Connection=3834 "
>> "2007-09-18 04:54:49.54 spid56 Dynamic Memory Manager: Stolen=122029
>> OS
>> Reserved=3168
>> OS Committed=3112
>> OS In Use=3108
>> Query Plan=96903 Optimizer=1
>> General=24144
>> Utilities=160 Connection=3834"
>> "2007-09-18 04:54:49.54 spid56 Query Memory Manager: Grants=0
>> Waiting=0
>> Maximum=52143 Available=52143"
>> "Error: 701, Severity: 17, State: 132"
>> "2007-09-18 04:54:49.56 spid56 BPool::Map: no remappable address
>> found."
>> "2007-09-18 04:54:49.59 spid56 Buffer Distribution: Stolen=122022
>> Free=949770 Procedures=7
>> Inram=0 Dirty=236616 Kept=0
>> I/O=0, Latched=194, Other=107327"
>> "2007-09-18 04:54:49.59 spid56 Buffer Counts: Commited=1415936
>> Target=1415936 Hashed=344137
>> InternalReservation=360 ExternalReservation=0 Min Free=128 Visible=>> 191272"
>> "2007-09-18 04:54:49.59 spid56 Procedure Cache: TotalProcs=6
>> TotalPages=7 InUsePages=4"
>> ......
>> how to fix this , i need restart the server mant time on everyday , HELP
>> !!!
>>
>>
>>
>>
>|||Did you ever get a fix to your problem? We are also running SQL 2000 sp4
with the awe hot fix. We are on windows 2003 sp2. We've had this happen
several times on a production server. We tried killing some spids that we
thought might be causing the problem - but that didn't help. We had to
reboot the server.
We have a case open with microsoft - but so far they are telling us its
beyond SQL Server's scope. SQL Server is using all the memory except for a
little we have set aside (1 gb out of 4 gb) for the OS, etc.
Let me know what you found.
"pcnetnet" wrote:
> Hi All,
> We have SQL 2000 ent and Windows 2003 , in a few day , restart many
> time the error message in event log is "Error: 17803, Severity: 20, State:
> 14
> Insufficient memory available."
> i try open SQL profiler and use performance monitor , but i don't know how
> to fix ? in profiler display error log , but i don't know is server problem
> or application problem , how to check the problem ? help
> SQL 2000 Ent ,enable AWE
> Windows 2003 ent enable PAE
> RAM : 16 GB
> In Profiler error :
> " 2007-09-18 04:54:49.51 spid56 BPool::Map: no remappable address found."
> "2007-09-18 04:54:49.54 spid56 Buffer Distribution: Stolen=122023
> Free=949769 Procedures=7
> Inram=0 Dirty=236616 Kept=0
> I/O=0, Latched=194, Other=107327"
> "2007-09-18 04:54:49.54 spid56 Buffer Counts: Commited=1415936
> Target=1415936 Hashed=344137
> InternalReservation=360 ExternalReservation=0 Min Free=128 Visible=> 191272"
> "2007-09-18 04:54:49.54 spid56 Procedure Cache: TotalProcs=6
> TotalPages=7 InUsePages=4"
> "2007-09-18 04:54:49.54 spid56 Dynamic Memory Manager: Stolen=122029 OS
> Reserved=3168
> OS Committed=3112
> OS In Use=3108
> Query Plan=96903 Optimizer=1
> General=24144
> Utilities=160 Connection=3834 "
> "2007-09-18 04:54:49.54 spid56 Dynamic Memory Manager: Stolen=122029 OS
> Reserved=3168
> OS Committed=3112
> OS In Use=3108
> Query Plan=96903 Optimizer=1
> General=24144
> Utilities=160 Connection=3834"
> "2007-09-18 04:54:49.54 spid56 Query Memory Manager: Grants=0 Waiting=0
> Maximum=52143 Available=52143"
> "Error: 701, Severity: 17, State: 132"
> "2007-09-18 04:54:49.56 spid56 BPool::Map: no remappable address found."
> "2007-09-18 04:54:49.59 spid56 Buffer Distribution: Stolen=122022
> Free=949770 Procedures=7
> Inram=0 Dirty=236616 Kept=0
> I/O=0, Latched=194, Other=107327"
> "2007-09-18 04:54:49.59 spid56 Buffer Counts: Commited=1415936
> Target=1415936 Hashed=344137
> InternalReservation=360 ExternalReservation=0 Min Free=128 Visible=> 191272"
> "2007-09-18 04:54:49.59 spid56 Procedure Cache: TotalProcs=6
> TotalPages=7 InUsePages=4"
> .......
> how to fix this , i need restart the server mant time on everyday , HELP !!!
>
>
>
>
>