December 8, 2003 at 7:15 am
On a multiprocessor having 8 CPUs,Sqlserver is using only one processor up to 90% without using other CPU in multi-threads simultaneous process. what can be reason?
December 8, 2003 at 7:24 am
Can you post result of sp_configure here?
December 8, 2003 at 8:11 pm
Have you checked to make sure SQL Server has been set to use more than one processor? In Enterprise Manager, right click the Server and choose Properties. Then select the Processors tab. Check to see how many processors its being asked to use under Parallelism.
Cheers,
Angela
December 9, 2003 at 2:16 am
This is the result of Sp_configure:
affinity mask-2147483648214748364700
allow updates0100
awe enabled0100
c2 audit mode0100
cost threshold for parallelism03276755
Cross DB Ownership Chaining0100
cursor threshold-12147483647-1-1
default full-text language0214748364710331033
default language0999900
fill factor (%)010000
index create memory (KB)704214748364700
lightweight pooling0100
locks5000214748364700
max degree of parallelism03200
max server memory (MB)4214748364721474836472147483647
max text repl size (B)021474836476553665536
max worker threads3232767255255
media retention036500
min memory per query (KB)512214748364710241024
min server memory (MB)0214748364700
nested triggers0111
network packet size (B)5126553640964096
open objects0214748364700
priority boost0100
query governor cost limit0214748364700
query wait (s)-12147483647-1-1
recovery interval (min)03276700
remote access0111
remote login timeout (s)021474836472020
remote proc trans0100
remote query timeout (s)02147483647600600
scan for startup procs0111
set working set size0100
show advanced options0111
two digit year cutoff1753999920492049
user connections03276700
user options03276700
December 9, 2003 at 2:20 am
quote:
All the CPU's are selected for parallel execution.cheers
sntiwary
December 9, 2003 at 2:33 am
what version of SQL Server are you using?
Right-click server and select properties
December 9, 2003 at 2:59 am
quote:
version is 8.00.760(SP3)
December 9, 2003 at 7:00 am
What multi-threads simultaneous process did you run? Can you be more specific in details?
January 26, 2004 at 5:29 am
One of our customers have exactly the same problem on a dual processor Win 2K server running SQL7. The operating system seems to detect both processors but SQL would only ever use one and when SQL was flat out the processor usage was only showing as 50%.
Did anybody ever find out what was causing this?
Thanks
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply