Hi , I having a server running on W2008 & SQL 2008 with 8 CPU. When I perform an batch update query , I notice it only utilize one of the CPU only. It is due to the SQL & Hardware setting ? How can I utilize all of the CPU to speed up the process ?
The actual number of threads used by a parallel query is determined at query plan execution initialization and is determined by the complexity of the plan and the degree of parallelism Read the following BOL topic... http://msdn.microsoft.com/en-us/library/ms178065.aspx
