- Win2K Adv Server
- SQL Server EE SP2
- 4Gb RAM
- 4x Xeon MP with hyperthreading enabled (4x logical, 4x physical)
- SQL Servers running on all 8 CPUs

When SQL Server runs at high CPU %(all 8 of them), starting Profiler, it all 8 CPU % by half. SQL Server still running but very slow.. (even with Profiler, killed and not in memory)

I noticed that someone experienced this before. However, not in an hyperthreading evnironment..