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

Microsoft Dynamics NAV Sustained Engineering Team Blog

Sort by: Most Recent | Most Viewed | Most Commented

  • The asymmetric stream

    Since NAV’s Stream introduction, there has been confusion about when to use READ and when to use READTEXT; when to use WRITE and when WRITEXT. As it is documented, InStream.READ and OutStream.WRITE are meant to be in binary format, which means that Text strings will be ‘zero terminated’ when written, and a ‘zero terminated’ is expected when you are using READ; however READTEXT will not expect a ‘zero terminated’ text, but can accept one. This very last feature makes the streams asymmetric, as you...

  • Simple query to check the recent performance history II - now including Query Plan information

    One of the queries I use the most, is the pplan-cache query from this post: Simple query to check the recent performance history The good thing about the query is that it shows information that could otherwise require a lot of work (collecting and analysing traces files). And the query does not need any advance work or setup. It can just be run. So it's a very easy way to receive information from a system, which is often very useful as a first step in troubleshooting performance. For more details...
    Filed under:

  • Session Monitor for SQL Server 2005

    Session Monitor is not a new tool, but it did stop working with SQL Server 2005. So I think that a lot of people stopped using it, which is a shame. The things that were broken now work again, and I would recommend anyone with any kind of blocking problems to implement this tool. With this post I hope to get some people to use it again, and to provide a new tool to anyone who did not know it exists. Purpose of the tool The purpose of the Session Monitor tool is to show a live picture of any current...
    Filed under:

  • How to deploy multiple NAS’es in ADCS

    Although this is not related to the ‘core C/Side’, I would discuss about configuring ADCS with multiple NASes. The first question would by why somebody would like to do this? The answer is very simple. On a single VT100 NAS installation, whenever a handheld user is performing a time-consuming task, any other handheld user will have to wait for the task to complete, before getting a response in the screen. The reason is because the NAS can perform one task at a time, and while it is busy, it will...

  • The random events

    Some years ago I was dealing with an issue that was driving me crazy and it took many hours to figure out what was wrong with the code. It was until I was explaining my findings to a colleague (don't you solve lots of things this way?) that it hit me, and when looking at the original (NAS) code I confirmed what was wrong. What was more irritating was that the system was working most of the time, and, of course, there was no way to consistently reproduce the issue. I will explain the issue here...

  • Jobs Update for Microsoft Dynamics NAV 5.0 SP1 is now released.

    I am pleased to announce the release of Jobs Update for Microsoft Dynamics NAV 5.0 SP1. This update is now available for you to download from Partner Source. Login credentials are required. https://mbs.microsoft.com/partnersource/downloads/releases/MicrosoftDynamicsNAV50SP1.htm Jobs update rollup corrects the issues that are described in KB article number 954191. These postings are provided "AS IS" with no warranties and confer no rights. You assume all risk for your use. Mtoo Norrild Program...
    Filed under:

  • Modern NAV/SQL troubleshooting II

    Please refer to this post about what I mean with "modern troubleshooting". This post describes methods that work on any version of SQL Server, including SQL2000. It describes one of the most common questions I get, which is "Where do we start"... General performance problems - where to start: If a system is suffering general performance problems, then it is not always easy to decide what to do first, or where to start. Then you may be tempted to collect lots of information, for...
    Filed under:

  • Microsoft Dynamics NAV 5.0 SP1 and SQL Server 2000

    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 time consuming process as the SQL Server 2000 might decide to include a clustered index scan as part of its query plan to update the view. If your Microsoft Dynamics NAV implementation includes tables...
    Filed under:

  • 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:

  • SQLIndex property

    In some situations, using the SQLIndex property on a key in Microsoft Dynamics NAV can harm performance. In this blog I describe what to be careful about, and why the use of this property has been removed in the NAV 5 SP1 application. The property is still available and it is still a valuable tool in performance tuning. But from SP1, it is not used anymore in the standard application. The document "Changes in NAV 5 0 SP1.doc" on the SP1 product CD lists the 72 tables where the SQLIndex...
    Filed under:
1 2 3 4 Next >

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