-
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
-
1. how many days did you collect data?
2. what OS, what version?
-
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
-
It's possible on lightly used server. What's usage on that busy cpu? Better to uncheck boost sql server.
-
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
-
Forum Rules
|
|