SQL2012 and iSCSI or Fusion IO

amcmwuamcmwu Member Posts: 34
edited 2014-01-10 in SQL Performance
Hello

i do not know if this is the correct forum but i hope.
We are a company with about 400 employees and want to upgrade from NAV2009 (technical - only Classic Client ) to NAV 2013.
We have a database about 350 GB.
Now we are testing new funktions and have two systems for this. A VM-Ware system with iSCSI Storage that is really
slow and a Fusion IO System, also with VM-Ware that is really fast.
Now if we ask the Hardware guys, they say the programing is not good and that makes the system slow, and if we ask the
Software guys the say the hardware is to slow.
How do we have to go on, to make the right choice for the hardware, that it is not oversized. But we also do not want to
pay with hardware for not good programing.

Would be nice if any one has experience on this. I only find topics with older versions.

Regards

Comments

  • Marije_BrummelMarije_Brummel Member, Moderators Design Patterns Posts: 4,262
    You cannot upgrade from 2009 to 2013 classic client. The forms, dataport and classicreport engines have been removed.
  • amcmwuamcmwu Member Posts: 34
    Hello

    thats is correct. Now we are working with Classic Client
    in NAV2009. NAV2009 is the technical release and the structure
    is still from NAV 3.7.
    We are planing to use the RTC for NAV2013.

    Sorry for that confusion
  • Marije_BrummelMarije_Brummel Member, Moderators Design Patterns Posts: 4,262
    Ok, that makes more sense.

    NAV 2013 is the fastest version of NAV ever. If correctly programmed it should outperform all previous versions of NAV. Afaik there is now one known issue related to SQL Integer datatypes in NAV Code fields.

    I had a customer running NAV 2009 on quite slow hardware and just by upgrading to 2013 they are happy now on the same hardware.

    With 400 users I would always go for fusion IO.

    In a project this size you should hire a specialist that knows both hardware, SQL and NAV that is respected by all parties involved and end the arguments.
Sign In or Register to comment.