Sunday, February 12, 2012

BPool error

I'm receiving this in my SQL errorlog:
ERRORLOG:2004-04-20 10:43:56.95 spid85 BPool::Map: no remappable address
found.
ERRORLOG:2004-04-20 10:43:57.09 spid85 Buffer Distribution:
Stolen=126759 Free=1305 Procedures=0
ERRORLOG: Inram=0 Dirty=12894 Kept=0
ERRORLOG: I/O=50738, Latched=108, Other=1643204
ERRORLOG:2004-04-20 10:43:57.09 spid85 Buffer Counts: Commited=1835008
Target=1835008 Hashed=1706944
ERRORLOG: InternalReservation=192 ExternalReservation=17101 Min Free=1024
ERRORLOG:2004-04-20 10:43:57.09 spid85 Procedure Cache: TotalProcs=0
TotalPages=0 InUsePages=0
ERRORLOG:2004-04-20 10:43:57.09 spid85 Dynamic Memory Manager:
Stolen=1178 OS Reserved=1648
ERRORLOG: OS Committed=1626
ERRORLOG: OS In Use=1616
ERRORLOG: Query Plan=20 Optimizer=0
ERRORLOG: General=2079
ERRORLOG: Utilities=151 Connection=252
ERRORLOG:2004-04-20 10:43:57.09 spid85 Global Memory Objects:
Resource=1770 Locks=131
ERRORLOG: SQLCache=92 Replication=2
ERRORLOG: LockBytes=2 ServerGlobal=53
ERRORLOG: Xact=75
ERRORLOG:2004-04-20 10:43:57.09 spid85 Query Memory Manager: Grants=2
Waiting=0 Maximum=138095 Available=66837
It looks very similar to what's mentioned in MS article 319477, except I
never receive an error 17803.
I am running SQL 2000, build 840, on Windows server 2003. Also, I have SQL
configured to use 14GB from a total of 16GB on the server.
Does anyone have any suggestions for how to address this?> I'm receiving this in my SQL errorlog:
> ERRORLOG:2004-04-20 10:43:56.95 spid85 BPool::Map: no remappable
address
> found.
> ERRORLOG:2004-04-20 10:43:57.09 spid85 Buffer Distribution:
> Stolen=126759 Free=1305 Procedures=0
> ERRORLOG: Inram=0 Dirty=12894 Kept=0
> ERRORLOG: I/O=50738, Latched=108, Other=1643204
> ERRORLOG:2004-04-20 10:43:57.09 spid85 Buffer Counts: Commited=1835008
> Target=1835008 Hashed=1706944
> ERRORLOG: InternalReservation=192 ExternalReservation=17101 Min Free=1024
> ERRORLOG:2004-04-20 10:43:57.09 spid85 Procedure Cache: TotalProcs=0
> TotalPages=0 InUsePages=0
> ERRORLOG:2004-04-20 10:43:57.09 spid85 Dynamic Memory Manager:
> Stolen=1178 OS Reserved=1648
> ERRORLOG: OS Committed=1626
> ERRORLOG: OS In Use=1616
> ERRORLOG: Query Plan=20 Optimizer=0
> ERRORLOG: General=2079
> ERRORLOG: Utilities=151 Connection=252
> ERRORLOG:2004-04-20 10:43:57.09 spid85 Global Memory Objects:
> Resource=1770 Locks=131
> ERRORLOG: SQLCache=92 Replication=2
> ERRORLOG: LockBytes=2 ServerGlobal=53
> ERRORLOG: Xact=75
> ERRORLOG:2004-04-20 10:43:57.09 spid85 Query Memory Manager: Grants=2
> Waiting=0 Maximum=138095 Available=66837
>
> It looks very similar to what's mentioned in MS article 319477, except I
> never receive an error 17803.
> I am running SQL 2000, build 840, on Windows server 2003. Also, I have SQL
> configured to use 14GB from a total of 16GB on the server.
> Does anyone have any suggestions for how to address this?
--
Please open an incident with your local Microsoft Product Support so this
can be looked at.
Regards,
Eric Crdenas
Senior support professional
This posting is provided "AS IS" with no warranties, and confers no rights.

No comments:

Post a Comment