March 11, 2014 at 12:05 pm
Let's also be careful about parallelism. It's a good thing. It's just that some queries are set as parallel that shouldn't be. Adjusting the cost threshold for parallelism up from the default value of 5 is a great idea. But I wouldn't suggest switching parallelism off completely on a server without a lot more information.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
March 11, 2014 at 12:10 pm
Grant Fritchey (3/11/2014)
Let's also be careful about parallelism. It's a good thing. It's just that some queries are set as parallel that shouldn't be. Adjusting the cost threshold for parallelism up from the default value of 5 is a great idea. But I wouldn't suggest switching parallelism off completely on a server without a lot more information.
Exactly. That's a great approach. Just trying to figure out certain things.
--
SQLBuddy
Viewing 2 posts - 16 through 16 (of 16 total)
You must be logged in to reply to this topic. Login to reply