Wednesday, March 7, 2012

only utilising one processor

i have just set up a sql server on a new windows server 2003. the server has 4x xeon smp's on it. if i look at performance monitor it only seems to be utilising one. any ideas as to where i can find answers
thanks.Well, what kind of queries are you running? Many queries cannot be run in
parallel, so they can only queue on one CPU.
--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"mike" <anonymous@.discussions.microsoft.com> wrote in message
news:D54A605D-332D-46CE-ADB6-4EF585571365@.microsoft.com...
>i have just set up a sql server on a new windows server 2003. the server
>has 4x xeon smp's on it. if i look at performance monitor it only seems to
>be utilising one. any ideas as to where i can find answers ?
> thanks.|||Hi
You don't say what version of SQL server you are using, this can determine
the number of processes being used see:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_ts_8dbn.asp
If you have changed the processor affinity then it may favour the one
processor.
You may also be restricted on the number of processors you can use by your
licence.
John
"mike" <anonymous@.discussions.microsoft.com> wrote in message
news:D54A605D-332D-46CE-ADB6-4EF585571365@.microsoft.com...
> i have just set up a sql server on a new windows server 2003. the server
has 4x xeon smp's on it. if i look at performance monitor it only seems to
be utilising one. any ideas as to where i can find answers ?
> thanks.|||"Well, what kind of queries are you running? Many queries cannot be run in parallel, so they can only queue on one CPU.
Is "DBCC CHECKDB" a reliable exception, for those who want to test? (Unless you use trace flag 2528, which prevents CHECKDB going multi-processor.
AIUI, any simple (single-table) query will use only one processor. (And that not much, I suppose, if all it's doing is pulling data from disk and passing it to the network.)|||the queries are fairly intensive number crunching operations that use #temp tables, sp's calling other sp's etc.|||hi john
i'm using sql server 2000. affinity as set in em is to use all cpu's. 4x physical and 4x logical. i'm using standard edition ( i know there is a limitation on it using only 4x cpu's.) but if you could elaborate more on the licensing restrictions i would appreciate it.|||hi robert. thanks for your reply. most operations are multi table joins/updates on a #temptable. after all data has been changed etc. it get's inserted into a static table.|||Hi Mike
See http://www.microsoft.com/sql/howtobuy/default.asp for the types of
licences.
John
"mike" <anonymous@.discussions.microsoft.com> wrote in message
news:2DF4B315-3791-42FA-B8F9-214F438A04ED@.microsoft.com...
> hi john,
> i'm using sql server 2000. affinity as set in em is to use all cpu's. 4x
physical and 4x logical. i'm using standard edition ( i know there is a
limitation on it using only 4x cpu's.) but if you could elaborate more on
the licensing restrictions i would appreciate it.

No comments:

Post a Comment