Suggestion for Navision 4.0 SP2 with SQL Server 2000/2005

anilkumar

Hi Experts,

Can any one help me to advise for Navision 4.0 SP2 with SQL Server 2000 SP4/ SQL Server 2005 any issues related to performance & other things.

Any Suggestions would be appreciated,

kuju

Hi Anilkumar,

There is a complete webspace available on partnersource containing information on SQL for Dynamics NAV.
This page contains with white papers, benchtests, webcasts, report packs,...

https://mbs.microsoft.com/partnersource/sales/salestools/productfactsheets/nav_sqlsvroption.htm?printpage=false

This page is updated frequently updated...

Alex_Chow

More specifically, the Data Resource Kit on that page explains in detail what you need to do to optimize the performance when using SQL.

DenSter

A lot of the information in some of those links is outdated though.

diptish.naskar

You can et some useful information on the known issues with SP2 and SQL in the MS Knowledge base. Go through them will have a fair amount of information.

anilkumar

Thanks a lot to all for your suggestions.

anilkumar

Is there any Issues with Navision SP2 with SQL Server 2005 - ?