DTS Package and CPU Utilization

• karthik M

  One Orange Chip

  Points: 29139

  More actions

  June 18, 2007 at 12:29 am

  #177063

  Hi,

   

  While executing the DTS package through scheduling process, I came to know it is not taking 100 % of CPU .It is taking 4% of CPU only. But i like to force it to use 100 % of CPU.Because i am running the job in night time . At that time i am not using my PC.So i want to force the DTS Package's CPU uasge to 100 % .

  Will it possible to change CPU utilization manually from 5% to 100% ?

  is it possible to tune our DTS package to use 100% CPU ?

   

  Regards

  Karthik

  karthik

• Sugesh Kumar

  One Orange Chip

  Points: 27311

  More actions

  June 18, 2007 at 1:32 am

  #713499

  You can set affinity to a particular process in your system but you cant force the processor to attain 100% utilization.

  Cheers,
  Sugeshkumar Rajendran
  SQL Server MVP
  http://sugeshkr.blogspot.com