I have two IBM machines with the same exact hardware 32 cores, 256GB RAM for each machine. One machine has Hyperthreading enabled and the other does not. When I run maintenance jobs (dbcc checkdb, and rebuild index) for the database that is 1TB the maintenance job takes 8 hours on the machine that has hyperthreading enabled and 22 hours on the machine that does not have hyperthreading enabled. I have read all over the internet to disable hyperthreading as a best practice. Am i doing the right thing here by disabling hyperthreading?
SQL Server 2008 Enterprise 64-bit, Microsoft Server 2008 R2
March 12, 2012 10:45 PM
March 13, 2012 12:43 PM