-
I know that this blogpost is far from orriginal but I am always looking for this information so I am putting it in my blog The table $ndo$dbproperty has a field DatabaseVersionNo. This is a list of recent versions. With special thanks to Dean McRae! / Database versions for: 2.50 // 1 : Beta 1 data formats...
-
Well, "Performance Optimization" in NAV & SQL is some sort of "Cornucopia of issues" – starting from Hardware Sizing, Platform Configuration, Index Tuning, SIFT Optimization, etc. … and – last but not least – the question: " How to prevent and solve...
-
While struggling with NAV/SQL performance issues for many years I scribbled down countless pages about various issues, learned by own experience or from colleagues, taken from numerous knowledgebase articles, whitepapers, etc. or heard in several webcasts. In 2006 I started to put all this into a structured...
-
Well, we all know that " Index Statistics " are crucial for optimized query processing in SQL Server, that we shouldn't use "Auto. Create Stats" or "Auto. Update Stats", that we should use "Jobs" or "Maintenance Plans" to keep them up to date, etc...
-
As promised I have some results from the tests. So we compared HP ML 370 with 14 SAS disks dedicated to a HP DL380 with data on a HP MSA2000 SAS SAN running on VMWare with the same amounts of disks. The DL380 is running on VMWare. The OS is on a shared storrage with the OS of the other VMWare machines...
-
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,...
-
Microsoft Dynamics NAV 5.0 SP1 introduces a new way to handle SIFT. Instead of maintaining totals in separate tables, Dynamics NAV 5.0 SP1 uses a SQL feature called indexed views. Indexed views will automatically be maintained by the SQL Server. With SQL Server 2000, updating an indexed view can be a...
-
I spent last week performing a Microsoft Dynamics NAV 5.0 Update 1 to Microsoft Dynamics NAV 5.0 SP1 database conversion for a customer. The process went very smoothly and the customer was very excited about the increase in performance we were able to achieve. Just as an illustration of our success,...
-
Ho, ho, ho … well, X-Mas is coming soon, time to make a wish-list! In my special case I would like to ask for several things making life with NAV and SQL easier. I'm not asking for "science fiction" features like " non-blocking posting routines " or " different code versions...
-
Well, at Convergence 2007 in Copenhagen it was announced (Session: NAV Keynotes) that in Q1 2008 the SP1 for NAV 5.00 would be released (dates are subject to change, of course). During the "Meet the Experts" session little more information about the SP's content was published. As we had...
-
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...
-
Currenly I am again fighting with SQL2005 at a customer. Many, many reads on tables whilst there are perfect and selective indexes. Now I've never experienced this problem on SQL2000. SQL always uses the right index for the query. I also know Navision has not changed the communication with SQL. What...
-
SQL and NAV is hot these days. More and more knowledge becomes available and more companies and freelancers start helping customers tuning their databases. Most of the problems exist in "older" databases. Especialy early version 3 databases have difficulties performing. Fortunalely version...
-
Starting First thing to say is: My appologies for not reporting on a daily bases. Directions is way different from TechEd and much busier for me. I have also had troubles getting online with my laptop, so I had difficulties reading my email and even listending to my voicemail. My appologies for that...