<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
SQL Server 2005
»
SQL Server 2005 Performance Tuning
»
Use of Parallelism.
Use of Parallelism.
Rate Topic
Display Mode
Topic Options
Author
Message
nitin.varshney
nitin.varshney
Posted Wednesday, December 19, 2012 11:42 PM
Grasshopper
Group: General Forum Members
Last Login: 2 days ago @ 3:29 AM
Points: 23,
Visits: 104
How can we use the parallelism in sql server. For the same query the exectuin plan at QA server the parallelism is being used. But It is not showing in Staging Server. What can be the reason behind that ?
Post #1398793
SQLRNNR
SQLRNNR
Posted Wednesday, December 19, 2012 11:48 PM
SSCoach
Group: General Forum Members
Last Login: Monday, May 20, 2013 1:07 PM
Points: 18,733,
Visits: 12,332
The reasons can be related to available resources, number of records and/or server settings.
Are bother environments exactly the same? If not, then the same execution plan could happen but should not be expected.
Jason
AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server 2008
SQL RNNR
Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #1398794
nitin.varshney
nitin.varshney
Posted Wednesday, December 19, 2012 11:55 PM
Grasshopper
Group: General Forum Members
Last Login: 2 days ago @ 3:29 AM
Points: 23,
Visits: 104
SQLRNNR (12/19/2012)
The reasons can be related to available resources, number of records and/or server settings.
Are bother environments exactly the same? If not, then the same execution plan could happen but should not be expected.
Yes, No of records in the table and environments are same. how can we resolve that ?
Post #1398797
SQLRNNR
SQLRNNR
Posted Thursday, December 20, 2012 12:10 AM
SSCoach
Group: General Forum Members
Last Login: Monday, May 20, 2013 1:07 PM
Points: 18,733,
Visits: 12,332
And the server settings, are they the same?
Max Degree of parallelism and Cost Threshold for Parallelism for starters.
Jason
AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server 2008
SQL RNNR
Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #1398809
nitin.varshney
nitin.varshney
Posted Thursday, December 20, 2012 12:23 AM
Grasshopper
Group: General Forum Members
Last Login: 2 days ago @ 3:29 AM
Points: 23,
Visits: 104
SQLRNNR (12/20/2012)
And the server settings, are they the same?
Max Degree of parallelism and Cost Threshold for Parallelism for starters.
Yes Both are same.....
Post #1398820
SQLRNNR
SQLRNNR
Posted Thursday, December 20, 2012 12:39 AM
SSCoach
Group: General Forum Members
Last Login: Monday, May 20, 2013 1:07 PM
Points: 18,733,
Visits: 12,332
And which plan is it that you want to use?
Which plan is performing better?
Did you clear the cache before running your tests on both servers?
Both servers have same number of cpus, same affinity, same resource governor settings, same memory?
Both servers have advanced power management turned off in bios?
Jason
AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server 2008
SQL RNNR
Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #1398829
nitin.varshney
nitin.varshney
Posted Thursday, December 20, 2012 2:50 AM
Grasshopper
Group: General Forum Members
Last Login: 2 days ago @ 3:29 AM
Points: 23,
Visits: 104
SQLRNNR (12/20/2012)
And which plan is it that you want to use?
Which plan is performing better?
Did you clear the cache before running your tests on both servers?
Both servers have same number of cpus, same affinity, same resource governor settings, same memory?
Both servers have advanced power management turned off in bios?
I want to use the execution plan which have the parallelism. It is working faster.
Both servers have same number of cpus, same affinity, same resource governor settings, same memory.
Post #1398878
nitin.varshney
nitin.varshney
Posted Thursday, December 20, 2012 2:55 AM
Grasshopper
Group: General Forum Members
Last Login: 2 days ago @ 3:29 AM
Points: 23,
Visits: 104
SQLRNNR (12/20/2012)
And which plan is it that you want to use?
Which plan is performing better?
Did you clear the cache before running your tests on both servers?
Both servers have same number of cpus, same affinity, same resource governor settings, same memory?
Both servers have advanced power management turned off in bios?
I have checked the no of processor. QA server, where the parallelism is being used have th 2 processor. and staging server have the 4 processor, where the parallelism qry is not being used.
Post #1398880
SQLRNNR
SQLRNNR
Posted Thursday, December 20, 2012 8:23 PM
SSCoach
Group: General Forum Members
Last Login: Monday, May 20, 2013 1:07 PM
Points: 18,733,
Visits: 12,332
Is advanced power management enabled in the bios on either machine?
Also, please submit actual execution plans for both servers. It will help us to troubleshoot.
Jason
AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server 2008
SQL RNNR
Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #1399161
opc.three
opc.three
Posted Friday, December 21, 2012 5:31 AM
SSCertifiable
Group: General Forum Members
Last Login: Today @ 8:46 AM
Points: 6,720,
Visits: 11,761
Have you updated your statistics recently on both databases? If statistics are up to date on one and not the other SQL Server can generate or pick different execution plans for the same query.
This too:
SQLRNNR (12/20/2012)
Also, please submit actual execution plans for both servers. It will help us to troubleshoot.
__________________________________________________________________________________________________
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
Believe you can and you're halfway there.
--Theodore Roosevelt
Everything Should Be Made as Simple as Possible, But Not Simpler
--Albert Einstein
The significant problems we face cannot be solved at the same level of thinking we were at when we created them.
--Albert Einstein
1 apple is not exactly 1/8 of 8 apples. Because there are no absolutely identical apples.
--Giordy
Post #1399354
« Prev Topic
|
Next Topic »
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
