Showing posts with label bpoolmap. Show all posts
Showing posts with label bpoolmap. Show all posts

Sunday, February 12, 2012

BPool::Map: no remappable address found

We received the error listed below last month on our SQL Server 2000 cluster
server with Windows 2003 server.
Please help me resolve this error.
Thanks,
2005-12-23 09:26:06.49 spid119 BPool::Map: no remappable address found.
2005-12-23 09:26:06.50 spid93 BPool::Map: no remappable address found.
2005-12-23 09:26:06.52 spid365 BPool::Map: no remappable address found.
2005-12-23 09:26:06.56 spid126 BPool::Map: no remappable address found.
2005-12-23 09:26:06.61 spid314 BPool::Map: no remappable address found.
2005-12-23 09:26:06.63 spid119 BPool::Map: no remappable address found.
2005-12-23 09:26:06.64 spid132 BPool::Map: no remappable address found.
2005-12-23 09:26:06.77 spid76 BPool::Map: no remappable address found.
2005-12-23 09:26:06.77 spid365 Buffer Distribution: Stolen=321943
Free=1954 Procedures=1218
Inram=0 Dirty=36513 Kept=0
I/O=1, Latched=204, Other=948887
2005-12-23 09:26:06.77 spid365 Buffer Counts: Commited=1310720
Target=1310720 Hashed=985605
InternalReservation=520 ExternalReservation=3156 Min Free=2048
2005-12-23 09:26:06.77 spid365 Procedure Cache: TotalProcs=161
TotalPages=1218 InUsePages=1079
2005-12-23 09:26:06.77 spid365 Dynamic Memory Manager: Stolen=323127 OS
Reserved=2528
OS Committed=2493
OS In Use=2457
Query Plan=300284 Optimizer=14761
General=4611
Utilities=134 Connection=2256
2005-12-23 09:26:06.77 spid365 Global Memory Objects: Resource=3639
Locks=1519
SQLCache=251 Replication=2
LockBytes=2 ServerGlobal=289
Xact=138
2005-12-23 09:26:06.77 spid365 Query Memory Manager: Grants=2 Waiting=7
Maximum=3156 Available=0
2005-12-23 09:26:06.77 spid93 Buffer Distribution: Stolen=321944
Free=1953 Procedures=1218
Inram=0 Dirty=36513 Kept=0
I/O=1, Latched=204, Other=948887
2005-12-23 09:26:06.77 spid93 Buffer Counts: Commited=1310720
Target=1310720 Hashed=985605
InternalReservation=520 ExternalReservation=3156 Min Free=2048
2005-12-23 09:26:06.77 spid93 Procedure Cache: TotalProcs=161
TotalPages=1218 InUsePages=1079
2005-12-23 09:26:06.77 spid93 Dynamic Memory Manager: Stolen=323127 OS
Reserved=2528
OS Committed=2493
OS In Use=2457
Query Plan=300284 Optimizer=14761
General=4611
Utilities=134 Connection=2256
2005-12-23 09:26:06.77 spid93 Global Memory Objects: Resource=3639
Locks=1519
SQLCache=251 Replication=2
LockBytes=2 ServerGlobal=289
Xact=138
2005-12-23 09:26:06.77 spid93 Query Memory Manager: Grants=2 Waiting=7
Maximum=3156 Available=0
2005-12-23 09:26:06.78 spid328 BPool::Map: no remappable address found.
2005-12-23 09:26:06.81 spid83 BPool::Map: no remappable address found.
2005-12-23 09:26:06.83 spid365 BPool::Map: no remappable address found.
2005-12-23 09:26:06.83 spid93 BPool::Map: no remappable address found.
2005-12-23 09:26:06.84 spid126 Buffer Distribution: Stolen=321850
Free=2053 Procedures=1212
Hi
Look at this KB article:
http://support.microsoft.com/kb/838459
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Joe K." <Joe K.@.discussions.microsoft.com> wrote in message
news:A5D5C3AA-F593-4087-B17B-F7B67C31FD90@.microsoft.com...
> We received the error listed below last month on our SQL Server 2000
cluster
> server with Windows 2003 server.
> Please help me resolve this error.
> Thanks,
>
> 2005-12-23 09:26:06.49 spid119 BPool::Map: no remappable address found.
> 2005-12-23 09:26:06.50 spid93 BPool::Map: no remappable address found.
> 2005-12-23 09:26:06.52 spid365 BPool::Map: no remappable address found.
> 2005-12-23 09:26:06.56 spid126 BPool::Map: no remappable address found.
> 2005-12-23 09:26:06.61 spid314 BPool::Map: no remappable address found.
> 2005-12-23 09:26:06.63 spid119 BPool::Map: no remappable address found.
> 2005-12-23 09:26:06.64 spid132 BPool::Map: no remappable address found.
> 2005-12-23 09:26:06.77 spid76 BPool::Map: no remappable address found.
> 2005-12-23 09:26:06.77 spid365 Buffer Distribution: Stolen=321943
> Free=1954 Procedures=1218
> Inram=0 Dirty=36513 Kept=0
> I/O=1, Latched=204, Other=948887
> 2005-12-23 09:26:06.77 spid365 Buffer Counts: Commited=1310720
> Target=1310720 Hashed=985605
> InternalReservation=520 ExternalReservation=3156 Min Free=2048
> 2005-12-23 09:26:06.77 spid365 Procedure Cache: TotalProcs=161
> TotalPages=1218 InUsePages=1079
> 2005-12-23 09:26:06.77 spid365 Dynamic Memory Manager: Stolen=323127 OS
> Reserved=2528
> OS Committed=2493
> OS In Use=2457
> Query Plan=300284 Optimizer=14761
> General=4611
> Utilities=134 Connection=2256
> 2005-12-23 09:26:06.77 spid365 Global Memory Objects: Resource=3639
> Locks=1519
> SQLCache=251 Replication=2
> LockBytes=2 ServerGlobal=289
> Xact=138
> 2005-12-23 09:26:06.77 spid365 Query Memory Manager: Grants=2 Waiting=7
> Maximum=3156 Available=0
> 2005-12-23 09:26:06.77 spid93 Buffer Distribution: Stolen=321944
> Free=1953 Procedures=1218
> Inram=0 Dirty=36513 Kept=0
> I/O=1, Latched=204, Other=948887
> 2005-12-23 09:26:06.77 spid93 Buffer Counts: Commited=1310720
> Target=1310720 Hashed=985605
> InternalReservation=520 ExternalReservation=3156 Min Free=2048
> 2005-12-23 09:26:06.77 spid93 Procedure Cache: TotalProcs=161
> TotalPages=1218 InUsePages=1079
> 2005-12-23 09:26:06.77 spid93 Dynamic Memory Manager: Stolen=323127 OS
> Reserved=2528
> OS Committed=2493
> OS In Use=2457
> Query Plan=300284 Optimizer=14761
> General=4611
> Utilities=134 Connection=2256
> 2005-12-23 09:26:06.77 spid93 Global Memory Objects: Resource=3639
> Locks=1519
> SQLCache=251 Replication=2
> LockBytes=2 ServerGlobal=289
> Xact=138
> 2005-12-23 09:26:06.77 spid93 Query Memory Manager: Grants=2 Waiting=7
> Maximum=3156 Available=0
> 2005-12-23 09:26:06.78 spid328 BPool::Map: no remappable address found.
> 2005-12-23 09:26:06.81 spid83 BPool::Map: no remappable address found.
> 2005-12-23 09:26:06.83 spid365 BPool::Map: no remappable address found.
> 2005-12-23 09:26:06.83 spid93 BPool::Map: no remappable address found.
> 2005-12-23 09:26:06.84 spid126 Buffer Distribution: Stolen=321850
> Free=2053 Procedures=1212
>
Posted by Clay at 3:36 AM 0 comments
Labels: , , , , , , , , , , , , , ,

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.
Posted by Clay at 3:36 AM 0 comments
Labels: , , , , , , , , , , , , , ,

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.
Posted by Clay at 3:36 AM 0 comments
Labels: , , , , , , , , , , , , , ,

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 Cárdenas
Senior support professional
This posting is provided "AS IS" with no warranties, and confers no rights.
Posted by Clay at 3:36 AM 0 comments
Labels: , , , , , , , , , , , , , ,
Subscribe to: Posts (Atom)