Dear all,
What is the ideal value for "max degree of parallelism" if we have very long
running queries which eat up lots of resources in peak hours.
We have 4 processors Dell machine. Our last DBA recommended it to 4 but new
DBA suggests it to set it to 1.
Need your expert opinion.
Kay
The only way to see what is best is to test each of them. It depends a lot
on what you are doing, schemas etc. It could be any of them.
Andrew J. Kelly SQL MVP
"Kay" <CallDBA@.hotmail.com> wrote in message
news:OPcIup92FHA.2800@.TK2MSFTNGP10.phx.gbl...
> Dear all,
> What is the ideal value for "max degree of parallelism" if we have very
> long running queries which eat up lots of resources in peak hours.
> We have 4 processors Dell machine. Our last DBA recommended it to 4 but
> new DBA suggests it to set it to 1.
> Need your expert opinion.
> Kay
>
|||On Fri, 28 Oct 2005 21:12:47 +0500, Kay wrote:
> Dear all,
> What is the ideal value for "max degree of parallelism" if we have very long
> running queries which eat up lots of resources in peak hours.
> We have 4 processors Dell machine. Our last DBA recommended it to 4 but new
> DBA suggests it to set it to 1.
> Need your expert opinion.
> Kay
Hello,
Just to add a few things.
If you have hyperthreading procs, MS recommends to set the max degree of p.
to the number of physical procs. Ref here :
http://support.microsoft.com/default.aspx/kb/322385
Look also at the evolution over time of CXPACKET wait types ( DBCC SQLPERF
(waitstats) ), indicating if parallelized queries wait for their threads to
finish.
Look also, on the CPUs, the percentage of Kernel Time. That could give you
a hint if the parallelism is detrimental. E.g. if decreasing your maxdop
show a drop of the kernel time, that could be a good thing.
But as it was said, a good answer is, try not to have very long running
queries at peak hours...
sql
Showing posts with label queries. Show all posts
Showing posts with label queries. Show all posts
Wednesday, March 28, 2012
max degree of parallelism Option
Dear all,
What is the ideal value for "max degree of parallelism" if we have very long
running queries which eat up lots of resources in peak hours.
We have 4 processors Dell machine. Our last DBA recommended it to 4 but new
DBA suggests it to set it to 1.
Need your expert opinion.
Kay
On Fri, 28 Oct 2005 21:12:47 +0500, "Kay" <CallDBA@.hotmail.com> wrote:
>What is the ideal value for "max degree of parallelism" if we have very long
>running queries which eat up lots of resources in peak hours.
>We have 4 processors Dell machine. Our last DBA recommended it to 4 but new
>DBA suggests it to set it to 1.
>Need your expert opinion.
If you have hyperthreading turned on, you may have 8!
Well, y'know, I guess it's obvious, but you don't really want to have
long-running queries during peak hours, do you? There are various
tuning things you can do, but that's more a matter of design and
operations management.
J.
What is the ideal value for "max degree of parallelism" if we have very long
running queries which eat up lots of resources in peak hours.
We have 4 processors Dell machine. Our last DBA recommended it to 4 but new
DBA suggests it to set it to 1.
Need your expert opinion.
Kay
On Fri, 28 Oct 2005 21:12:47 +0500, "Kay" <CallDBA@.hotmail.com> wrote:
>What is the ideal value for "max degree of parallelism" if we have very long
>running queries which eat up lots of resources in peak hours.
>We have 4 processors Dell machine. Our last DBA recommended it to 4 but new
>DBA suggests it to set it to 1.
>Need your expert opinion.
If you have hyperthreading turned on, you may have 8!
Well, y'know, I guess it's obvious, but you don't really want to have
long-running queries during peak hours, do you? There are various
tuning things you can do, but that's more a matter of design and
operations management.
J.
max degree of parallelism Option
Dear all,
What is the ideal value for "max degree of parallelism" if we have very long
running queries which eat up lots of resources in peak hours.
We have 4 processors Dell machine. Our last DBA recommended it to 4 but new
DBA suggests it to set it to 1.
Need your expert opinion.
KayOn Fri, 28 Oct 2005 21:12:47 +0500, "Kay" <CallDBA@.hotmail.com> wrote:
>What is the ideal value for "max degree of parallelism" if we have very long
>running queries which eat up lots of resources in peak hours.
>We have 4 processors Dell machine. Our last DBA recommended it to 4 but new
>DBA suggests it to set it to 1.
>Need your expert opinion.
If you have hyperthreading turned on, you may have 8!
Well, y'know, I guess it's obvious, but you don't really want to have
long-running queries during peak hours, do you? There are various
tuning things you can do, but that's more a matter of design and
operations management.
J.
What is the ideal value for "max degree of parallelism" if we have very long
running queries which eat up lots of resources in peak hours.
We have 4 processors Dell machine. Our last DBA recommended it to 4 but new
DBA suggests it to set it to 1.
Need your expert opinion.
KayOn Fri, 28 Oct 2005 21:12:47 +0500, "Kay" <CallDBA@.hotmail.com> wrote:
>What is the ideal value for "max degree of parallelism" if we have very long
>running queries which eat up lots of resources in peak hours.
>We have 4 processors Dell machine. Our last DBA recommended it to 4 but new
>DBA suggests it to set it to 1.
>Need your expert opinion.
If you have hyperthreading turned on, you may have 8!
Well, y'know, I guess it's obvious, but you don't really want to have
long-running queries during peak hours, do you? There are various
tuning things you can do, but that's more a matter of design and
operations management.
J.
max degree of parallelism Option
Dear all,
What is the ideal value for "max degree of parallelism" if we have very long
running queries which eat up lots of resources in peak hours.
We have 4 processors Dell machine. Our last DBA recommended it to 4 but new
DBA suggests it to set it to 1.
Need your expert opinion.
KayThe only way to see what is best is to test each of them. It depends a lot
on what you are doing, schemas etc. It could be any of them.
--
Andrew J. Kelly SQL MVP
"Kay" <CallDBA@.hotmail.com> wrote in message
news:OPcIup92FHA.2800@.TK2MSFTNGP10.phx.gbl...
> Dear all,
> What is the ideal value for "max degree of parallelism" if we have very
> long running queries which eat up lots of resources in peak hours.
> We have 4 processors Dell machine. Our last DBA recommended it to 4 but
> new DBA suggests it to set it to 1.
> Need your expert opinion.
> Kay
>|||On Fri, 28 Oct 2005 21:12:47 +0500, Kay wrote:
> Dear all,
> What is the ideal value for "max degree of parallelism" if we have very long
> running queries which eat up lots of resources in peak hours.
> We have 4 processors Dell machine. Our last DBA recommended it to 4 but new
> DBA suggests it to set it to 1.
> Need your expert opinion.
> Kay
Hello,
Just to add a few things.
If you have hyperthreading procs, MS recommends to set the max degree of p.
to the number of physical procs. Ref here :
http://support.microsoft.com/default.aspx/kb/322385
Look also at the evolution over time of CXPACKET wait types ( DBCC SQLPERF
(waitstats) ), indicating if parallelized queries wait for their threads to
finish.
Look also, on the CPUs, the percentage of Kernel Time. That could give you
a hint if the parallelism is detrimental. E.g. if decreasing your maxdop
show a drop of the kernel time, that could be a good thing.
But as it was said, a good answer is, try not to have very long running
queries at peak hours...
What is the ideal value for "max degree of parallelism" if we have very long
running queries which eat up lots of resources in peak hours.
We have 4 processors Dell machine. Our last DBA recommended it to 4 but new
DBA suggests it to set it to 1.
Need your expert opinion.
KayThe only way to see what is best is to test each of them. It depends a lot
on what you are doing, schemas etc. It could be any of them.
--
Andrew J. Kelly SQL MVP
"Kay" <CallDBA@.hotmail.com> wrote in message
news:OPcIup92FHA.2800@.TK2MSFTNGP10.phx.gbl...
> Dear all,
> What is the ideal value for "max degree of parallelism" if we have very
> long running queries which eat up lots of resources in peak hours.
> We have 4 processors Dell machine. Our last DBA recommended it to 4 but
> new DBA suggests it to set it to 1.
> Need your expert opinion.
> Kay
>|||On Fri, 28 Oct 2005 21:12:47 +0500, Kay wrote:
> Dear all,
> What is the ideal value for "max degree of parallelism" if we have very long
> running queries which eat up lots of resources in peak hours.
> We have 4 processors Dell machine. Our last DBA recommended it to 4 but new
> DBA suggests it to set it to 1.
> Need your expert opinion.
> Kay
Hello,
Just to add a few things.
If you have hyperthreading procs, MS recommends to set the max degree of p.
to the number of physical procs. Ref here :
http://support.microsoft.com/default.aspx/kb/322385
Look also at the evolution over time of CXPACKET wait types ( DBCC SQLPERF
(waitstats) ), indicating if parallelized queries wait for their threads to
finish.
Look also, on the CPUs, the percentage of Kernel Time. That could give you
a hint if the parallelism is detrimental. E.g. if decreasing your maxdop
show a drop of the kernel time, that could be a good thing.
But as it was said, a good answer is, try not to have very long running
queries at peak hours...
max degree of parallelism Option
Dear all,
What is the ideal value for "max degree of parallelism" if we have very long
running queries which eat up lots of resources in peak hours.
We have 4 processors Dell machine. Our last DBA recommended it to 4 but new
DBA suggests it to set it to 1.
Need your expert opinion.
KayThe only way to see what is best is to test each of them. It depends a lot
on what you are doing, schemas etc. It could be any of them.
Andrew J. Kelly SQL MVP
"Kay" <CallDBA@.hotmail.com> wrote in message
news:OPcIup92FHA.2800@.TK2MSFTNGP10.phx.gbl...
> Dear all,
> What is the ideal value for "max degree of parallelism" if we have very
> long running queries which eat up lots of resources in peak hours.
> We have 4 processors Dell machine. Our last DBA recommended it to 4 but
> new DBA suggests it to set it to 1.
> Need your expert opinion.
> Kay
>|||On Fri, 28 Oct 2005 21:12:47 +0500, Kay wrote:
> Dear all,
> What is the ideal value for "max degree of parallelism" if we have very lo
ng
> running queries which eat up lots of resources in peak hours.
> We have 4 processors Dell machine. Our last DBA recommended it to 4 but ne
w
> DBA suggests it to set it to 1.
> Need your expert opinion.
> Kay
Hello,
Just to add a few things.
If you have hyperthreading procs, MS recommends to set the max degree of p.
to the number of physical procs. Ref here :
http://support.microsoft.com/default.aspx/kb/322385
Look also at the evolution over time of CXPACKET wait types ( DBCC SQLPERF
(waitstats) ), indicating if parallelized queries wait for their threads to
finish.
Look also, on the CPUs, the percentage of Kernel Time. That could give you
a hint if the parallelism is detrimental. E.g. if decreasing your maxdop
show a drop of the kernel time, that could be a good thing.
But as it was said, a good answer is, try not to have very long running
queries at peak hours...
What is the ideal value for "max degree of parallelism" if we have very long
running queries which eat up lots of resources in peak hours.
We have 4 processors Dell machine. Our last DBA recommended it to 4 but new
DBA suggests it to set it to 1.
Need your expert opinion.
KayThe only way to see what is best is to test each of them. It depends a lot
on what you are doing, schemas etc. It could be any of them.
Andrew J. Kelly SQL MVP
"Kay" <CallDBA@.hotmail.com> wrote in message
news:OPcIup92FHA.2800@.TK2MSFTNGP10.phx.gbl...
> Dear all,
> What is the ideal value for "max degree of parallelism" if we have very
> long running queries which eat up lots of resources in peak hours.
> We have 4 processors Dell machine. Our last DBA recommended it to 4 but
> new DBA suggests it to set it to 1.
> Need your expert opinion.
> Kay
>|||On Fri, 28 Oct 2005 21:12:47 +0500, Kay wrote:
> Dear all,
> What is the ideal value for "max degree of parallelism" if we have very lo
ng
> running queries which eat up lots of resources in peak hours.
> We have 4 processors Dell machine. Our last DBA recommended it to 4 but ne
w
> DBA suggests it to set it to 1.
> Need your expert opinion.
> Kay
Hello,
Just to add a few things.
If you have hyperthreading procs, MS recommends to set the max degree of p.
to the number of physical procs. Ref here :
http://support.microsoft.com/default.aspx/kb/322385
Look also at the evolution over time of CXPACKET wait types ( DBCC SQLPERF
(waitstats) ), indicating if parallelized queries wait for their threads to
finish.
Look also, on the CPUs, the percentage of Kernel Time. That could give you
a hint if the parallelism is detrimental. E.g. if decreasing your maxdop
show a drop of the kernel time, that could be a good thing.
But as it was said, a good answer is, try not to have very long running
queries at peak hours...
max degree of parallelism Option
Dear all,
What is the ideal value for "max degree of parallelism" if we have very long
running queries which eat up lots of resources in peak hours.
We have 4 processors Dell machine. Our last DBA recommended it to 4 but new
DBA suggests it to set it to 1.
Need your expert opinion.
KayOn Fri, 28 Oct 2005 21:12:47 +0500, "Kay" <CallDBA@.hotmail.com> wrote:
>What is the ideal value for "max degree of parallelism" if we have very lon
g
>running queries which eat up lots of resources in peak hours.
>We have 4 processors Dell machine. Our last DBA recommended it to 4 but new
>DBA suggests it to set it to 1.
>Need your expert opinion.
If you have hyperthreading turned on, you may have 8!
Well, y'know, I guess it's obvious, but you don't really want to have
long-running queries during peak hours, do you? There are various
tuning things you can do, but that's more a matter of design and
operations management.
J.sql
What is the ideal value for "max degree of parallelism" if we have very long
running queries which eat up lots of resources in peak hours.
We have 4 processors Dell machine. Our last DBA recommended it to 4 but new
DBA suggests it to set it to 1.
Need your expert opinion.
KayOn Fri, 28 Oct 2005 21:12:47 +0500, "Kay" <CallDBA@.hotmail.com> wrote:
>What is the ideal value for "max degree of parallelism" if we have very lon
g
>running queries which eat up lots of resources in peak hours.
>We have 4 processors Dell machine. Our last DBA recommended it to 4 but new
>DBA suggests it to set it to 1.
>Need your expert opinion.
If you have hyperthreading turned on, you may have 8!
Well, y'know, I guess it's obvious, but you don't really want to have
long-running queries during peak hours, do you? There are various
tuning things you can do, but that's more a matter of design and
operations management.
J.sql
Monday, March 19, 2012
Matrix Queries
I've just started using report martix's (RS2005) and have a couple of
questions.
Is it possible to change the way a summary for a column calculates. By
default it does a sum but on a certain row I want an average. can this been
done or am I stuck with a sum.
Also i would like to be able to have a static heading right at the top of
the matrix, at the moment i'm using the top left cell but this isn't ideal
--
Cheers
Luke
http://beakersoft.blogspot.comOfcourse you can use "Average", Give a title which is not changing, I mean
different values. then it will display single value. If you want the title to
be same then might as well you can think of table instead of matrix.
Amarnath, MCTS.
"lukethepunk" wrote:
> I've just started using report martix's (RS2005) and have a couple of
> questions.
> Is it possible to change the way a summary for a column calculates. By
> default it does a sum but on a certain row I want an average. can this been
> done or am I stuck with a sum.
> Also i would like to be able to have a static heading right at the top of
> the matrix, at the moment i'm using the top left cell but this isn't ideal
> --
> Cheers
> Luke
> http://beakersoft.blogspot.com
questions.
Is it possible to change the way a summary for a column calculates. By
default it does a sum but on a certain row I want an average. can this been
done or am I stuck with a sum.
Also i would like to be able to have a static heading right at the top of
the matrix, at the moment i'm using the top left cell but this isn't ideal
--
Cheers
Luke
http://beakersoft.blogspot.comOfcourse you can use "Average", Give a title which is not changing, I mean
different values. then it will display single value. If you want the title to
be same then might as well you can think of table instead of matrix.
Amarnath, MCTS.
"lukethepunk" wrote:
> I've just started using report martix's (RS2005) and have a couple of
> questions.
> Is it possible to change the way a summary for a column calculates. By
> default it does a sum but on a certain row I want an average. can this been
> done or am I stuck with a sum.
> Also i would like to be able to have a static heading right at the top of
> the matrix, at the moment i'm using the top left cell but this isn't ideal
> --
> Cheers
> Luke
> http://beakersoft.blogspot.com
Subscribe to:
Posts (Atom)