Performance Matrix For Navision

abnainas

Dear All,

Can any body give me the performance matrix for navision.

Please advice

Marije_Brummel

Can you give an example of what that should look like please?

abnainas

Dear Mark Brummel,

I want some sheet that includes the peroformnce of NAVISION. including the the time it takes to run a report or a form. I want some detailes.

Please advice

stryk

Hi!

Are you running NAV on C/SIDE or SQL Server?

With C/SIDE you only could use the Client Monitor for investigation & analysis (check out the "Performance Troubleshooting Guide & Tools").

With SQL you could also use SQL Profiler, Performance Dashboard, DBA Dashboard and much more.

To check on the platform/hardware you could use "Windows Performance Monitor".

Hope this helps a little.
Regards,
Jörg

abnainas

Dear stryk,

I'm using SQL database. I will install NAV on a site outsile JORDAN. and they ask me about Navision performance matrix. So if you have a document or any referance to get some information.

Please Advice

abnainas

AnyBody Can help?

stryk

With SQL there is A LOT to monitor, analyze - and finally to optimize ...
If you search the forum for "SQL Perfromance" you'll get tons of advices!

Regarding "performance analysis & optimization" I recommend this site:
http://www.sql-server-performance.com/tips/performance_main.aspx
These are general tips for SQL analysis & tuning; the more specific NAV issues you could find here:

http://www.mibuso.com/forum/viewtopic.php?t=22727&postdays=0&postorder=asc&start=0 8)

Marije_Brummel

I think you need to get your customers expecations. Please ask them an example from another application. Maybe they want to benchmark or something.

abnainas

Dear All,

Can you provide me with Dynamics NAV benchmark for NAV 4.3 and NAV 5.0

Regards

stryk

Well, I'm not sure about what you are asking for ... :-k

As Mark said: What does your customer want to have? What should this "Matrix" show? What do you want to measure and compare? What kind of "benchmark" to you want to perform?

Some measuremen/analysis tools are mentioned above, maybe you also want check out the "Application Benchmark Tool" for NAV?

If you are looking for some kind of "best values" e.g. about "how long it takes to post an invoice with 10 lines" or anything, well, then: there isn't (except for the marking stuff telling you how many millions of line you could process etc. - in theory, not reality 8-[ - for example https://mbs.microsoft.com/downloads/partner/Nav/MSDYNAV_SQL_White%20Paper.pdf)

kriki

[Topic moved from Navision forum to SQL Performance forum]

Savatage

It also depends on hardware - Give me $5,000.00 and $20,000.00 and I'll get two very different machines that will have different performance & different benchmarks.

bbrown

Savatage wrote:

It also depends on hardware - Give me $5,000.00 and $20,000.00 and I'll get two very different machines that will have different performance & different benchmarks.

Or give $20,000.00 to a person that has a good understanding of NAV and another $20,000.00 to a person that just builds servers and you will get different performance and benchmarks.