dcsimg
Results 1 to 5 of 5

Thread: CPU utilization

  1. #1
    Join Date
    Jan 2005
    Posts
    4

    Question CPU utilization

    Hi all,
    I have a problem in trying to find out why only one CPU in a 2 CPU H-T utilized. Using task manager, I can see 4 processors windows but only 1 actually utilized. I select +boost sql server and select all CPU for use. Queries and all other command ie dbcheck.. appear to use only single cpu.
    Any help would be nice.
    thanks
    Andrew

  2. #2
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254
    1. how many days did you collect data?
    2. what OS, what version?

  3. #3
    Join Date
    Jan 2005
    Posts
    4
    Hi Mak,
    1. I havn't collect over a period of time as yet as this one currently going into production

    2. windows 2003 /sql 2000 SP3

    thanks

  4. #4
    Join Date
    Sep 2002
    Posts
    5,938
    It's possible on lightly used server. What's usage on that busy cpu? Better to uncheck boost sql server.

  5. #5
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254
    a. One of the reason might be that it is not doing parallel execution. check the following

    sp_configure

    for 'max degree of parallelism'

    b. If there is no need of multiple processing power for certain task, it uses only one CPU.

    c. Collect the data for a period of time. Instant peek will not give enough information about the behaviour.

    http://forums.databasejournal.com/sh...threadid=39040

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •