Dynamics User Group
Since 1995 - The Microsoft Dynamics Online User Community

May 2008 - Microsoft Dynamics NAV Sustained Engineering Team Blog

Sort by: Most Recent | Most Viewed | Most Commented

  • Release of Upgrade Toolkit for Microsoft Dynamics NAV 5.0 SP1

    I am pleased to announce the release of Upgrade toolkit for Microsoft Dynamics NAV 5.0 SP1. This update is now available for the first countries and it’s ready for you to download from Partner Source. Login credentials are required. https://mbs.microsoft.com/partnersource/downloads/releases/MicrosoftDynamicsNAV50SP1.htm The Upgrade toolkit update rollup corrects the issues that are described in KB article number 952193. These postings are provided "AS IS" with no warranties and confer no...
    Filed under:

  • NAV and the .Net Garbage Collector

    Many NAV solutions, including internal ones, have the necessity to use .Net as a supplement of NAV technology, in order to complete their logic; however, dealing with managed and unmanaged world takes some extra challenges, especially when the managed code uses unmanaged resources. This is further important, when the .Net component will be hosted on the NAS, as it restarts (traditionally because of a deadlock) giving a short time for the unmanaged resources to be disposed. When a .Net component ends...

  • What is the cost of maintaining an indexed view?

    In previous versions, Microsoft Dynamics NAV maintains SIFT totals in SIFT tables. So updating the main table is done in one query. Updating the related SIFT tables is done by seperate queries run from triggers on the SQL tables. This makes it difficult to idenitfy the real cost of updating the table with a SQL Profiler trace, since you need to take several queries into account to get the real cost. From NAV version 5 SP1, the SIFT tables are replaced with Indexed Views which makes it simpler to...

  • Index View Matching & Dynamics NAV 5.0 SP1

    In a recent question we were asked whether it was required to use Dynamics NAV 5.0 SP1 with Microsoft SQL Server 2005 Enterprise or Developer Edition to gain better performance, from the changes we have done in Dynamics NAV 5.0 SP1, and the answer is "NO". I will in this blog post try to explain why. Indexed views on SQL Server 2005 includes functionality like "index view matching" and is a capability that enables SQL Server (Enterprise and Developer Edition only) to automatically...

  • Changes to Microsoft Dynamics NAV 5.0 SP1 with Microsoft SQL Server

    I just want to point you to the whitepaper describing the changes done for the Microsoft Dynamics NAV 5.0 SP1 SQL Option: With the release of Microsoft Dynamics NAV™ 5.0 SP1, major changes have been made to Microsoft Dynamics NAV™ with Microsoft SQL Server. This document outlines these changes and shows how these changes can help you improve the Microsoft Dynamics NAV customer experience. This document will only cover changes to Microsoft Dynamics NAV with SQL Server. Martin Nielander Program Manager...

  • Modern NAV/SQL troubleshooting

    This post is the first in a planned series to describe various "modern" methods for troubleshooting performance problems with Microsoft Dynamics NAV on SQL Server. The idea is also to make the best out of information that already exists, either in other places on this blog or anywhere else. Modern Troubleshooting: The idea about "Modern Troubleshooting" is: To take as much of the hard work out of troubleshooting as possible. To make the system itself (SQL Server and NAV) help...
    Filed under:

Copyright Dynamics User Group, 1995-2008, all rights reserved. The Dynamics User Group is not affiliated with Microsoft Corporation.