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?
Software/Hardware used: SQL Server 2008 Enterprise 64-bit, Microsoft Server 2008 R2
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!