Browse Site by Tags - Dynamics User Group

Downgrading NAV

Well, a current discussion is whether to go for NAV 5.0 Service Pack 1 or not. On the one hand, NAV 5.0 SP1 has lots of improvements regarding SQL performance (Indexed Views, Buffered Inserts, etc.), on the other hand there are other issues and problems (slow FlowFields, lacking SQL 2000 capability,...

Posted to Dynamics NAV Performance on SQL - My Two Cents by Jörg A. Stryk on 06-05-2008
Filed under: Performance, SIFT, NAV, vsift, sql server, 5.0 sp1, upgrade, downgrade

Included Columns vs. SIFT Tables

Base on David's "hint, hint ) I made my promise come true and copied this from a current thread: SIFT tables include aggregated information of e.g. "Ledger Entry" tables to display these values in FlowFields. The aggregation is done via SQL Server site triggers which are programmed...

Posted to Dynamics NAV Performance on SQL - My Two Cents by Jörg A. Stryk on 10-28-2007
Filed under: SQL, Performance, Index, SIFT

Performance Experience with SATA for NAV on SQL DB (was: Navision DB)

Hi IHAC who has deployed Navision for Retail stores. The deployment architecture is described below: Intel Blade with 1 Xeon E5320 Quad Core 1.86 GHz 16 GB memory 4x 146GB SAS Drives The App sits on the C Drive of the Blade The DB sits on an external storage connected via FC HBA The external storage...

Posted to NAV / Navision - Microsoft SQL Server by Mitesh on 10-19-2007

Re: Performance Issue

Hi! Welcome to dynamicsusers.net Please, search the forums for "SQL Performance" and you'll see, that these issues are actually permanetly discussed. Performance Optimization of NAV on SQL Server is a complex task, and you will get "gazillions" of valuable advice! Good Luck! Jörg

Posted to NAV / Navision - Microsoft SQL Server by Jörg A. Stryk on 08-16-2007