July 14, 2014 at 4:44 am
Hi
I have a query that use parallelism and takes 6 secs to run. I wanted to see how this would perform without parallelism and so set the threshold to 10, however my query still uses parallelism. Have I missed another setting somewhere?
Thanks
July 14, 2014 at 4:57 am
Cost != duration.
Check the execution plan for the query, see what the cost is, set cost threshold above that. Or just use the maxdop hint on that query.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 14, 2014 at 5:10 am
Ah yes thats sorted it, I was reading this article where it says "Estimatedcost in seconds.." which is what confused me.
http://msdn.microsoft.com/en-us/library/ms190949.aspx
Hopefully catch your session at SQLBits later this week.
Thanks
July 14, 2014 at 5:24 am
That estimated cost isn't in real "seconds." It's just a number used for the internal calculations.
----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply