Can one query be spread across multiple cpu's

Hi,

Im looking for some further information on how MS SQL works on dual xeon machines.

If i run a simple query. ie: select * from test. Would that query run on one cpu, or would it be spread across all 4 cpu's?
zattzAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Raynard7Connect With a Mentor Commented:
Hi,

This article describes how the sql processor divides the query into tasks as appropriate and then how it is recombined.

It is possible for one query to run across multiple processors

http://www.microsoft.com/technet/prodtechnol/sql/70/maintain/sql7qp.mspx
0
 
Guy Hengel [angelIII / a3]Connect With a Mentor Billing EngineerCommented:
note that for most applications, having queries to be split over several CPU costs more than it brings as end result, which is why in all cases until now, I deactivated the parallel query execution.
note: this is not the same setting as allowing sql server to run in general on all cpu (cpu affinity).
0
All Courses

From novice to tech pro — start learning today.