Parallel Plans

Hi,
Our production server is a Compaq Proliant with 2 CPU. How can I determine
that my queries benefit from having 2 CPU? Are parallel plans automatically
created our I must configure server options?
Any help would be greatly appreciated.
LeilaYou can check if your server is set to use parallel query plans on the
processor tab of the server properties in Enterprise Manager.
You can check if any queries with a parallel plan are executed by tracing
the DegreeOfParallelism event with SQL Profiler. See the topic "Degree of
Parallelism" in Books Online for details.
Jacco Schalkwijk
SQL Server MVP
"Leila" <Leilas@.hotpop.com> wrote in message
news:OmMhaHYzEHA.1192@.tk2msftngp13.phx.gbl...
> Hi,
> Our production server is a Compaq Proliant with 2 CPU. How can I determine
> that my queries benefit from having 2 CPU? Are parallel plans
> automatically
> created our I must configure server options?
> Any help would be greatly appreciated.
> Leila
>|||If you are using the database with more than one user, then you are
likely to benefit from the extra CPU even if no parallellism is chosen,
because in that case the workload can be divided over 2 CPU's instead of
just the 1.
Gert-Jan
Leila wrote:
> Hi,
> Our production server is a Compaq Proliant with 2 CPU. How can I determine
> that my queries benefit from having 2 CPU? Are parallel plans automaticall
y
> created our I must configure server options?
> Any help would be greatly appreciated.
> Leila