CPU usage 100%

• Goboxe

  Newbie

  Points: 1

  More actions

  May 20, 2006 at 10:47 pm

  #190686

  Hi,

  I am in the midst of testing program that I have written to populate one table with more than 2 millions data.

  Now, I am running on Pentium 4 1.6GHz Single processor machine with 1.5GB RAM.

  When running, the CPU usage is always 99% - 100%. However, the RAM used is only up to 800 MB.

  Is this always the case when I running on 1 processor machine?

  I plan to test on new server with 4-processors + 3 GB RAM next month when we receive it.

  Do you think it behave the same as above for the 4-proc server?

   

  Thanks,

  G

• Sergiy

  SSC Guru

  Points: 110209

  More actions

  May 21, 2006 at 5:19 pm

  #639152

  You must loop through those 2 millons rows.

  That's why there is no memory usage and your CPU is very busy.

  _____________
  Code for TallyGenerator

• colin.Leversuch-Roberts

  SSC Guru

  Points: 52643

  More actions

  May 24, 2006 at 2:14 am

  #639689

  I'd suggest a read of Inside sql server 2000.

  [font="Comic Sans MS"]The GrumpyOldDBA[/font]
  www.grumpyolddba.co.uk
  http://sqlblogcasts.com/blogs/grumpyolddba/