MAXDOP

(0) Share

Report

Posted on by Community Member

Hi everyone.

My name is Adelino Couto. I'm a newcomer in the world Dynamics NAV/SQL Server.

I have read a lot about the parameter MAXDOP of the SQL Server database, when it's the repository of data for Dynamics NAV.

It's recomended to set it's value to 1 for NAV. I read this on the DynamicsNAV 2018 official documentation.

My question is: should I use the same value for early versions of Dynamics NAV?

Regards, Adelino Couto

*This post is locked for comments

I have the same question (0)

All responses (12)

Answers (0)

Stefano Demiliani 37,166 Most Valuable Professional on at

Like (1)

Report

You can set it to 1 also for earlier version of NAV. Remember that with SQL 2016 you can set this parameter also at database level.

Was this reply helpful? Yes No
Suggested answer

Alexander Ermakov 28,096 on at

Like (1)

Report

Generally, yes.

However, 1 is not always the best, it depends no the nature of the database workload. In some cases, you can set it to e.g. 25 and then reduce by verifying the result.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Stefano.

So it's a best pratice to do that?

I do not know how to do it at instance level. Can you do it with SSMS?

Thanks.

Was this reply helpful? Yes No
Stefano Demiliani 37,166 Most Valuable Professional on at

Like (1)

Report

Absolutely yes, via SSMS or stored procedure:

docs.microsoft.com/.../configure-the-max-degree-of-parallelism-server-configuration-option

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Alexander.

Thank you! I'm only interested in using SQL Server for Dynamics NAV.

Why did you said to use the 25 value? In most cases I do not have more than 8 vCPUs.

And how can I check the result?

Thanks

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Stefano.

I tried to do it, but allways change at database level.

Regards

Was this reply helpful? Yes No
Stefano Demiliani 37,166 Most Valuable Professional on at

Like (0)

Report

Via Management Studio, right click your server, select Properties, Advanced and here it should be the Max Degree of Parallelism box (if I remember correctly).

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Stefano.

Yes. That way you change at database nevel, not at instance level, right?

Regards

Was this reply helpful? Yes No
Suggested answer

Stefano Demiliani 37,166 Most Valuable Professional on at

Like (0)

Report

No, if you right your SQL Server instance you can set the value for the instance itself.

For SQL 2016 only you can set it also at database level.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hello Stefano.

I think I'm making a confusion between instance and database level. Please help.

In the image above you can see a part of my SSMS connecting to my SQL Server database.

PT-ACOUTO is the name of my computer, and I think it is my database name, i.e, database level.

'Demo Database NAV' and 'MyNewApp' I think they are the instances of my database (PT-ACOUTO).

If I'm wrong and the database level is at ''Demo Database NAV' and 'MyNewApp', wich is my instance level?

Sorry for this basic questions.

Was this reply helpful? Yes No