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