General question about tuning/performance/workoad on Navision

(0) Share

Report

Posted on by Community Member

Hi there, I am currently testing AX 2012 with the well-known subset or procedures Rod Hansen

https://dynamicsperf.codeplex.com/

I am not able to see scripts or jobs targeting Navision.. is it so?

Anyway, does anyone have some link or tools for squeezing Navision? We have one bigger cluster for different countries and lately performance is falling down

We run Navision 2009.

Thanks for your any input or hint related to

*This post is locked for comments

I have the same question (0)

All responses (9)

Answers (0)

Community Member on at

Like (0)

Report

RE: General question about tuning/performance/workoad on Navision

Roberto, many thanks, really useful!!

Was this reply helpful? Yes No
Suggested answer

Roberto Stefanetti 12,998 on at

Like (2)

Report

RE: General question about tuning/performance/workoad on Navision

hi,

take a look here

community.dynamics.com/.../124515

and here

community.dynamics.com/.../124547

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

RE: General question about tuning/performance/workoad on Navision

You can also use Client Monitor to find out the exact issues related to wrong coding in NAV.

How about doing re-indexing on important tables on scheduled manner? How frequently you have scheduled this?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: General question about tuning/performance/workoad on Navision

Thanks, althought SQL Profiler GUI is always messing up the server and even Extended Events is annoying the usual workload

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (1)

Report

RE: General question about tuning/performance/workoad on Navision

Performance Analyzer can be used with NAV as well.

Check Client Monitor, SQL Profiler, which would also help you to find out bad queries and further you can fine tune the same.

Refer following links, which can be very helpful to you.

community.dynamics.com/.../124547

msdn.microsoft.com/.../hh169233(v=nav.90).aspx

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: General question about tuning/performance/workoad on Navision

No, I meant, yes yes Navision and SQL Server works very tight... but, you know, looking over and over again articles or hints for it in Internet and always you get AX stuff.

Was this reply helpful? Yes No
Suggested answer

Nareshwar Raju Vane... 5,596 on at

Like (0)

Report

RE: General question about tuning/performance/workoad on Navision

Hi Enric,

Actually not. NAV is very close to SQL Server because most of transactions end in SQL Server Procedures.

Glad I helped you.

Was this reply helpful? Yes No
Community Member on at

Like (1)

Report

RE: General question about tuning/performance/workoad on Navision

Hi Nareshwar, thanks for your reply, the second link is useful althought it is really difficult to find articles Navision<->SQL Server related to, is like Navision were working totally independently of RDBMS.

Was this reply helpful? Yes No
Suggested answer

Nareshwar Raju Vane... 5,596 on at

Like (2)

Report

RE: General question about tuning/performance/workoad on Navision

Hi,

There are few help.

Please follow these links.

[1] www.sqlskills.com/.../wait-statistics-or-please-tell-me-where-it-hurts

[2] blogs.msdn.microsoft.com/.../sql-server-worker-threads-and-microsoft-dynamics-nav

[3] www.sqlskills.com/.../sql-server-performance-tuning-using-wait-statistics

Hope it helps.

Was this reply helpful? Yes No