Dear friends,
I've been reading some docs about parallelism but I'm still not sure how it
works. My doubt is:
To work with parallelism, do I need to use partitioned tables/index? If yes,
how?
I'm using a dell power edge 6000 with 4 processors.
kind regards
BertoliYou don't need to have partitioned tables to use parallelism. All you need
are multiple CPU's. Parallelism is the striping of a query across multiple
CPU's. In many cases, this speed up the query. In a minority of cases, it
slows down the query. However, you can turn off parallelism for that query
by using OPTION (MAXDOP 1).
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
.
"Bertoli" <bertoli@.bertoli.com.br> wrote in message
news:%23ZJszXxYGHA.3532@.TK2MSFTNGP05.phx.gbl...
Dear friends,
I've been reading some docs about parallelism but I'm still not sure how it
works. My doubt is:
To work with parallelism, do I need to use partitioned tables/index? If yes,
how?
I'm using a dell power edge 6000 with 4 processors.
kind regards
Bertoli|||SQL Server will parallelize queries as it is able (if you allow it to do
so). You do NOT need to create partitioned tables to use this feature.
--
Keith Kratochvil
"Bertoli" <bertoli@.bertoli.com.br> wrote in message
news:%23ZJszXxYGHA.3532@.TK2MSFTNGP05.phx.gbl...
> Dear friends,
> I've been reading some docs about parallelism but I'm still not sure how
> it
> works. My doubt is:
> To work with parallelism, do I need to use partitioned tables/index? If
> yes,
> how?
> I'm using a dell power edge 6000 with 4 processors.
> kind regards
> Bertoli
>|||tks guys
Bertoli
"Bertoli" <bertoli@.bertoli.com.br> escreveu na mensagem
news:%23ZJszXxYGHA.3532@.TK2MSFTNGP05.phx.gbl...
> Dear friends,
> I've been reading some docs about parallelism but I'm still not sure how
it
> works. My doubt is:
> To work with parallelism, do I need to use partitioned tables/index? If
yes,
> how?
> I'm using a dell power edge 6000 with 4 processors.
> kind regards
> Bertoli
>|||You can get more info from BOL by searching for
* Max degree of parallelism
Thanks
Ajay Rengunthwar
No comments:
Post a Comment