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...
    http://msdn.microsoft.com/en-us/library/ms178065.aspx

Share This Page