We have 2 IBM xSeries 360 servers with 4 processors and 8
GB of ram in each. These machines are setup in a
clustered environment. Originally, these boxes had 2
procs in them and we added the additional processors 2
weeks ago. What we have noticed is that our execution
plans are not using parallelism and querries are running
slower than the time we had 2 procs. Does any one have
any idea why our execution plans are not using parallelism
and do you have any thoughts on how to correct?

Thanks in advance!
Chad

Have you turned on the /PAE switch in BOOT.INI? Have you set the max SQL
Server memory to about 7GB? Have you set the max degree of parallelism to
0?

--
Tom

---------------------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql


"Chad" <cwainscott (AT) marketingdirect (DOT) com> wrote

We have 2 IBM xSeries 360 servers with 4 processors and 8
GB of ram in each. These machines are setup in a
clustered environment. Originally, these boxes had 2
procs in them and we added the additional processors 2
weeks ago. What we have noticed is that our execution
plans are not using parallelism and querries are running
slower than the time we had 2 procs. Does any one have
any idea why our execution plans are not using parallelism
and do you have any thoughts on how to correct?

Thanks in advance!
Chad

Tom,

Thank you for the post. It is greatly appreciated.

We have turned the /PAE switch on in the Boot.ini. Max
memory is set at 7, but we have not set max degree of
parallelism. Can you provide more detail?

Thank

Chad
Please feel free to e-mail me directly.

Run the following and post the results:

sp_configure 'max deg'
go
sp_configure 'affinity'
go


--
Tom

---------------------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql


"CHad" <cwainscott (AT) marketingdirect (DOT) com> wrote

Tom,

Thank you for the post. It is greatly appreciated.

We have turned the /PAE switch on in the Boot.ini. Max
memory is set at 7, but we have not set max degree of
parallelism. Can you provide more detail?

Thank

Chad
Please feel free to e-mail me directly.

possible that there are MAXDOP hints on some queries forcing/overriding
default?

also posible that affinity mask value (uses a fraction of the available
cpus)?

Also check your cost threshold for parallelism to ensure that it is set to
default(and not set too high) thus preventing a parallel execution plan
being generated for certain queries


--
Olu Adedeji
"Tom Moreau" <tom (AT) dont (DOT) spam.me.cips.ca> wrote

Run the following and post the results:

sp_configure 'max deg'
go
sp_configure 'affinity'
go


--
Tom

---------------------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql


"CHad" <cwainscott (AT) marketingdirect (DOT) com> wrote

Tom,

Thank you for the post. It is greatly appreciated.

We have turned the /PAE switch on in the Boot.ini. Max
memory is set at 7, but we have not set max degree of
parallelism. Can you provide more detail?

Thank

Chad
Please feel free to e-mail me directly.