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?