SQL Server Performance

SQL Update

Discussion in 'SQL Server 2008 General DBA Questions' started by travistan, Apr 5, 2010.

  1. travistan New Member

    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 ?
  2. MohammedU New Member

    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...

Share This Page