Microsoft Dynamics NAV (Archived)

Performance Issues Native Database Nav 2009 SP2

(0) Share

Report

Posted on by Community Member

I have a customer who has native database and Nav 2009 SP2

The server they are using is relatively new and has resources available.

They have reported that they are experiencing performance issues even when there is only a single user logged in.

It is particularly slow when doing any of the below

-Posting invoices (SI's or PI's);

-Adding Lines to an SO;

-Opening Item/customer lists

Running optimisation on all tables temporarily alleviated the problem

The database KB used is possibly a bit on the high side

What performance monitoring do I need to investigate this issue ? or what can I do to optimise this instance?

Thanks 5280.Capture.JPG

5280.Capture.JPG

*This post is locked for comments

I have the same question (0)

All responses (9)

Answers (1)

Suggested answer

Stefano Demiliani 37,166 Most Valuable Professional on at

Like (0)

Report

Do you have a database with a single filegroup? Have you rebuilt the indexes? Do you have an active maintenance plan on your SQL Database?

Was this reply helpful? Yes No
ManishS 86 on at

Like (0)

Report

Native database ? Not on SQL !

Was this reply helpful? Yes No
Suggested answer

Peter D. Jorgensen 110 on at

Like (0)

Report

First you could look at the Database File virtual table and Performance virtual table. Just to make sure the hardware is ok.

A good place to start actual troubleshooting is the Client Monitor. It is a bit like SQL Profiler but but it can only analyze your own session. You will need to either reproduce the problem, or sit by the user while they do it. (Or use TeamViewer or similar tool). But make sure you are familiar with the tool before using it in front of the customer.

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

Like (0)

Report

Oh sorry, it’s the native one. Check the keys, launch the table optimization...

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thank you for your response. How do I view the database and performance file ? Do I need to create a page view to these? I don't seem to have access rights to do this but can probably arrange to get them.

I will practice using Client Monitor and work with the affected users then.

Thanks again

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thanks, table optimization temporarily helps the issue. How or what do I need to check on the keys ? Thanks

Was this reply helpful? Yes No
Suggested answer

Stefano Demiliani 37,166 Most Valuable Professional on at

Like (0)

Report

Table optimization is what you have to do in the classic database. Regarding keys, you can check if a key is optimized by going to File --> Database --> Information --> Tables --> Keys. If ypu have run table optimization, you don't have to check this.

If performance problem persists, you should check also key usage in your codes. By creating the right keys, you can speed up a lot.

Remember that native database is old, not supported anymore and you with limits on performances.

Was this reply helpful? Yes No
Verified answer

Peter D. Jorgensen 110 on at

Like (1)

Report

You will need to create forms (Native DB cannot by used by the RTC, so no Pages) for the two virtual tables. The tables should show up in the Create Form wizard table list, but are not shown directly in the Object Designer. The Performance table should say atleast 700 packets/sec of 4000 bytes, and atleast 3000 packets/sec of 100 bytes. These are my rules of thump, but many configurations offer must better connection. Latency is crusial for Native DB!

Be carefull using Table Optimization. It improves Read performance, but often decreases Write performance for a long time. It can be compared to doing a Index Rebuild on SQL with a fill factor of 0, and this fill factor is not adjustable for Native DB.

Regarding performance for single user databases, then SQL is nowhere near the possible performance of NAV Native DB, if configuration and code is made correct. I once in a while also work in Native databases, and afterwards all RTC clients (incl. NAV2018 and BC) feels awfully slow. The combination of Native DB and Classic client is normally very snappy.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thank you this is very helpful

Was this reply helpful? Yes No