Question

SQL Server Parallelism Settings

Updated September 21, 2017

asked on August 18, 2017

Hello. What are the recommended settings for “max degree of parallelism” and “cost threshold for parallelism” for SQL Server 2005 SP4? They are currently set to the defaults of 0 and 5 respectively. Thanks for your time.

0 0

Answer

SELECTED ANSWER

replied on August 18, 2017

Is there a reason why you're trying to change the defaults? "0" for the max degree of parallelism is basically "let SQL figure out what's best for performance based on the available resources".

0 0

View 3 previous replies

replied on August 22, 2017

Miruna. I am asking for a customer. His response back is this...

Our question is whether or not there is a specifications or setup document for the Laserfiche SQL Server. Some applications have specific recommendations for the layout of database files, SQL properties etc.

I have sent him an older whitepaper called "LF Hardware Planning and Specifications", but i didnt see anything related to parallelism.

0 0

replied on August 22, 2017

Laserfiche does not have custom requirements for SQL Server.

0 0

replied on August 22, 2017

Miruna. Thank you for the response. Is there an updated version of the "LF Hardware Planning and Specifications" whitepaper?

0 0

replied on August 22, 2017

The updated version of the paper should come out in the next week or so. It most likely won't touch on this subject though as we don't have custom settings. One of the reasons we use Microsoft SQL Server is that it works in most situations out of the box. Unless trying to solve a very specific performance issue, we're not recommending changing any of SQL's default settings.

0 0

replied on August 23, 2017

Thank you Miruna.

0 0

replied on September 21, 2017

Miruna,

Do you have an update on the release on the new updated version of the whitepaper? Thanks for your time.

Joe

0 0

Replies

replied on August 18, 2017

I know this doesn't answer the question, but why are you using SQL Server 2005?

SQL Server 2005 hit it's end of life with Microsoft a over a year ago, and is no longer being patched against bugs or security threats. I'd strongly recommend that you look at upgrading.

If you plan to upgrade to Laserfiche 10 at any point, you need to get up to at least SQL Server 2008 anyway.

2 0

replied on August 22, 2017

Glen.. This is for a customer. They are still on version 8 and have plans of upgrading to 10 in the near future in which the SQL version will be addressed.

0 0

You are not allowed to follow up in this post.

Question

Question

SQL Server Parallelism Settings

Answer

Replies

Sign in to reply to this post.