database is slow

• Grant Fritchey

  SSC Guru

  Points: 397721

  More actions

  March 11, 2014 at 12:05 pm

  #1696104

  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 RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software

• SQLBuddy123

  One Orange Chip

  Points: 28294

  More actions

  March 11, 2014 at 12:10 pm

  #1696106

  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