Hyperthreading an issue?

Hi!
Has anyone experienced troubles with machines that have hyperthreading
enabled? Troubles concerning speed and data consistency issues?
We have three machines (one for testing, one at a client and another one
at a friend's place who agreed to try it as well) with hyperthreading and
all machines suffer from performance problems with MSDE (but not only with
MSDE).
They are all running WinXP Professional.
Any pointers appreciated.
Stefan
On Mon, 12 Jul 2004 12:05:14 +0200, Stefan M. Huber <looseleaf@.gmx.net>
wrote:

> Hi!
> Has anyone experienced troubles with machines that have
> hyperthreading enabled? Troubles concerning speed and data consistency
> issues?
> We have three machines (one for testing, one at a client and another one
> at a friend's place who agreed to try it as well) with hyperthreading
> and all machines suffer from performance problems with MSDE (but not
> only with MSDE).
> They are all running WinXP Professional.
...with only one CPU, I should mention.
Stefan
|||I have heard rumors about hyper-threading, but I have an Intel 875 P4
motherboard and have not experienced any issues--that I'm aware of. MSDE can
use multiple processors (up to two) and hyperthreading exposes the same
processor as a second thread so it should be able to help. Are you getting
errors in the event log to indicate that the governor is kicking in? I can
see how some applications written on a single processor might not be
prepared for operations on dual processor boxes where race conditions can
cause operations to occur out of the usual serialized order.
hth
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
"Stefan M. Huber" <looseleaf@.gmx.net> wrote in message
news:opsa0r3kscs9ddfw@.news.individual.de...
> On Mon, 12 Jul 2004 12:05:14 +0200, Stefan M. Huber <looseleaf@.gmx.net>
> wrote:
>
> ...with only one CPU, I should mention.
> Stefan
|||On Mon, 12 Jul 2004 11:14:09 -0700, William (Bill) Vaughn
<billvaRemoveThis@.nwlink.com> wrote:

> processor as a second thread so it should be able to help. Are you
> getting errors in the event log to indicate that the governor is kicking
> in? I can
> see how some applications written on a single processor might not be
> prepared for operations on dual processor boxes where race conditions can
> cause operations to occur out of the usual serialized order.
I haven't yet seen any event log entries. Or other log file entries that
indicate troubles. It's just slow :/ But thanks for your reply.
Stefan
|||There are a dozen dozen reasons that an application can be slow. Blaming
MSDE is like blaming your car's engine when you're hauling a ton of sand up
and towing a horse trailer up Mt. Rainer. If you're not seeing events, then
it's likely your database configuration, the amount of RAM in your system
(consider that SQL Server builds its performance model around cached pages),
or the what your application is asking the engine to do...
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
"Stefan M. Huber" <looseleaf@.gmx.net> wrote in message
news:opsa4h2fhjs9ddfw@.news.individual.de...[vbcol=seagreen]
> On Mon, 12 Jul 2004 11:14:09 -0700, William (Bill) Vaughn
> <billvaRemoveThis@.nwlink.com> wrote:
can
> I haven't yet seen any event log entries. Or other log file entries that
> indicate troubles. It's just slow :/ But thanks for your reply.
> Stefan
|||On Wed, 14 Jul 2004 12:25:53 -0700, William (Bill) Vaughn
<billvaRemoveThis@.nwlink.com> wrote:

> There are a dozen dozen reasons that an application can be slow. Blaming
> MSDE is like blaming your car's engine when you're hauling a ton of sand
> up and towing a horse trailer up Mt. Rainer. If you're not seeing
> events, then
> it's likely your database configuration, the amount of RAM in your system
> (consider that SQL Server builds its performance model around cached
> pages),
> or the what your application is asking the engine to do...
I am not directly blaming MSDE, I just hoped that somebody else has
troubles. Alas, we'll have to look elsewhere. The problem is that we don't
know where to start :/
The DB configuration is identical on (nearly) all our customers' places.
At least as identical as it can be.
We'll be trying our setup on a real dual processor machine shortly and see
if we can find similar issues. If so, I'd say Delphi or we ourselves are
to blame.
Thanks for your time,
Stefan