BSOD with hyper threading and SQL

Dell Power Edge 6650 duel 1.5 Xeon SQL 2000
I have been on the phone with dell trying to resolve an
issue with the server stated above. I kept getting bsod's
and they finally told me to dissable the HTT in the bios
and everything worked fine so far. They say that SQL see's
four processors and we are only lc. for two proc therefor
creating the bsod. This is wrong... SP2 and SP3 inable
htt and utilize it. right? Please help I cant except the
resolve they gave me.SQL Server is only user mode code, so it doesn't BSOD, so DELL are obviously
feeding you some crap. And SQL Server will definitely not BSOD deliberately
for licensing reasons!
What happens sometimes is that SQL Server pushes the HW enough so that you
see HW or driver problems which you won't see under normal load. You need to
find the offending driver or HW.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Eddie" <anonymous@.discussions.microsoft.com> wrote in message
news:c2b701c40c54$157ce7b0$a601280a@.phx.gbl...
> Dell Power Edge 6650 duel 1.5 Xeon SQL 2000
> I have been on the phone with dell trying to resolve an
> issue with the server stated above. I kept getting bsod's
> and they finally told me to dissable the HTT in the bios
> and everything worked fine so far. They say that SQL see's
> four processors and we are only lc. for two proc therefor
> creating the bsod. This is wrong... SP2 and SP3 inable
> htt and utilize it. right? Please help I cant except the
> resolve they gave me.|||I'm on the phone with them now. Ill post with the reply
they give me. Thanks
>--Original Message--
>SQL Server is only user mode code, so it doesn't BSOD, so
DELL are obviously
>feeding you some crap. And SQL Server will definitely not
BSOD deliberately
>for licensing reasons!
>What happens sometimes is that SQL Server pushes the HW
enough so that you
>see HW or driver problems which you won't see under
normal load. You need to
>find the offending driver or HW.
>--
>Tibor Karaszi, SQL Server MVP
>http://www.karaszi.com/sqlserver/default.asp
>
>"Eddie" <anonymous@.discussions.microsoft.com> wrote in
message
>news:c2b701c40c54$157ce7b0$a601280a@.phx.gbl...
bsod's
see's
therefor
>
>.
>|||I agree with Tibor. I currently have some Dell 6650 units in service and
they are pretty stable when they are on current firmware. The HT issue is
not a valid cause for a BSOD, but I would put SQL build 818 on just in case.
It is the post-SP3 hotfix specifically for HyperThreaded systems.
You can download and apply firmware patches and driver updates yourself with
the OpenManage software included with your Dell system or you can get a tech
out to do a complete system-wide firmware upgrade. That option may cost
money, depending on what level of support you have for your server. Since
it is crashing, you may be able to get it serviced under warranty.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:%23eeFDUFDEHA.2052@.TK2MSFTNGP11.phx.gbl...
> SQL Server is only user mode code, so it doesn't BSOD, so DELL are
obviously
> feeding you some crap. And SQL Server will definitely not BSOD
deliberately
> for licensing reasons!
> What happens sometimes is that SQL Server pushes the HW enough so that you
> see HW or driver problems which you won't see under normal load. You need
to
> find the offending driver or HW.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
>
> "Eddie" <anonymous@.discussions.microsoft.com> wrote in message
> news:c2b701c40c54$157ce7b0$a601280a@.phx.gbl...
>

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
>