5

Will all cores be used on an i7 when running SQL Server 2008 R2 Standard

view full story
linux-howto

http://serverfault.com – I have a server with an Intel Core i7 processor (4 cores). If I view processor activity in Task Manager I see that there are 8 cores. I believe that this is because of hyperthreading (please correct me if I'm wrong). SQL Server 2008 R2 Standard will use a maximum of 4 CPUs when compared to SQL Server Enterprise which uses a maximum of 8 CPUs. My question: Will the standard version of SQL Server fully utilize all available CPUs on this server? i.e. Will it see 4 or 8 CPUs? (HowTos)