Performance Matrix For Navision

abnainas
abnainas Member Posts: 174
edited 2008-07-09 in SQL Performance
Dear All,

Can any body give me the performance matrix for navision.

Please advice
Ahmad Bani Naser
Dynamics NAV Developer

Comments

  • Marije_Brummel
    Marije_Brummel Member, Moderators Design Patterns Posts: 4,262
    Can you give an example of what that should look like please?
    Marije Brummel | Freelance Business Central Specialist
  • abnainas
    abnainas Member Posts: 174
    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
    Ahmad Bani Naser
    Dynamics NAV Developer
  • stryk
    stryk Member Posts: 645
    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
    Jörg A. Stryk (MVP - Dynamics NAV)
    NAV/SQL Performance Optimization & Troubleshooting
    STRYK System Improvement
    The Blog - The Book - The Tool
  • abnainas
    abnainas Member Posts: 174
    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
    Ahmad Bani Naser
    Dynamics NAV Developer
  • abnainas
    abnainas Member Posts: 174
    AnyBody Can help?
    Ahmad Bani Naser
    Dynamics NAV Developer
  • stryk
    stryk Member Posts: 645
    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)
    Jörg A. Stryk (MVP - Dynamics NAV)
    NAV/SQL Performance Optimization & Troubleshooting
    STRYK System Improvement
    The Blog - The Book - The Tool
  • Marije_Brummel
    Marije_Brummel Member, Moderators Design Patterns Posts: 4,262
    I think you need to get your customers expecations. Please ask them an example from another application. Maybe they want to benchmark or something.
    Marije Brummel | Freelance Business Central Specialist
  • abnainas
    abnainas Member Posts: 174
    Dear All,

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

    Regards
    Ahmad Bani Naser
    Dynamics NAV Developer
  • stryk
    stryk Member Posts: 645
    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)
    Jörg A. Stryk (MVP - Dynamics NAV)
    NAV/SQL Performance Optimization & Troubleshooting
    STRYK System Improvement
    The Blog - The Book - The Tool
  • kriki
    kriki Member, Moderator Posts: 9,121
    [Topic moved from Navision forum to SQL Performance forum]
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

  • Savatage
    Savatage Member Posts: 7,142
    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.
    Harry Ruiz
    http://www.BiloBeauty.com
    http://www.autismspeaks.org
  • bbrown
    bbrown Member Posts: 3,268
    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.
    There are no bugs - only undocumented features.

Categories