NAV 5.0 SP1 SQL Upgrades

Posted by Dave Cintron at 9/27/2008 11:41 AM
Categories: Technical
 With NAV 5.0 Service Pack 1 Microsoft has rewritten the SQL version of the client to use SQL Indexing to take place of the original pre-Microsoft Navision SIFT technology. I believe they have been working on putting this feature into the NAV client for several years because it has taken them this long to match the sophistication of SIFT technology in the SQL server.

Recently we have been doing upgrades to the 5.0 SP1 version, sometimes the entire database and sometimes the client only. We have noticed a significant increase in speed especially where the database itself is upgraded because Microsoft has also rewritten the code in the database to take advantage of SQL features.


The client-only upgrade is very fast and trouble free. As soon as you open the database with the new client it runs through the tables doing the version update and this goes very quickly. Alternately you can do a backup/restore on the database to force an index rebuild. There is of course more SQL optimization to be done, but this is a report on the easy part. And of course the newer the SQL version the better. I’m not sure how far the SQL Optimization tools go with this version of NAV, but I’ve also found that the simplest actions usually get the job done.

Dave

 

What did you think of this article?




Trackbacks
Trackback specific URL for this entry
  • No trackbacks exist for this entry.
Comments
Display comments as (Linear | Threaded)

Leave a comment

Submitted comments will be subject to moderation before being displayed.

 Enter the above security code (required)

 Name

 Email (will not be published)

 Website

Your comment is 0 characters limited to 3000 characters.