Home Forums SQL Server 2005 SQL Server 2005 Performance Tuning Server becomes very slow [RESOURCE_SEMAPHORE] waittype. RE: Server becomes very slow [RESOURCE_SEMAPHORE] waittype.
junk0
SSC-Addicted
Points: 437
More actions
September 4, 2008 at 10:23 am
#867272
Umm, as far as I know Quad cores do not support hyperthreading.
And if it matters, MAXDOP is currently set to 4. I don't think it's a maxdop issue, because parallel queries are executing fine and the slowdown affects all queries.