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)

Suggested answer

Community Member on at

Like (0)

Report

RE: MAXDOP

Hi Stefano.

Than you, now I understand.

It's funny that at Instance Level the defenition is named 'Max Degree of Paralelism' and at Database Level, it's named 'Max DOP'.

Thank you very much, for everything.

Adelino

Was this reply helpful? Yes No
Suggested answer

Stefano Demiliani 37,166 Most Valuable Professional on at

Like (0)

Report

RE: MAXDOP

PT_ACOUTO is the name of the SQL Server instance in your machine, Demo Database NAV is the name of your database.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: MAXDOP

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
Suggested answer

Stefano Demiliani 37,166 Most Valuable Professional on at

Like (0)

Report

RE: MAXDOP

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

RE: MAXDOP

Hi Stefano.

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

Regards

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

Like (0)

Report

RE: MAXDOP

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

RE: MAXDOP

Hi Stefano.

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

Regards

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: MAXDOP

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
Stefano Demiliani 37,166 Most Valuable Professional on at

Like (1)

Report

RE: MAXDOP

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

RE: MAXDOP

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