Microsoft Dynamics NAV

Microsoft Dynamics NAV Team Blog

Common Tasks
Unfiltered HTML
The views expressed in this blog are those of the individual and do not necessarily represent those of Microsoft. This information is provided by way of general information only and should not be relied on without obtaining independent expert advice. These postings are provided "AS IS" with no warranties and confer no rights. You assume all risk for your use.
NAV Blogs and Forums
Dynamics NAV Resources
Tags
Archives
Archives

Browse by Tags

MSDN Blogs > Microsoft Dynamics NAV Team Blog > All Tags > performance
Browse by Tags

  • Blog Post: G/L Entry Table Locking Redesign in Microsoft Dynamics NAV 2013

    Do you or your customers have peak hours when all the sales orders and invoices need to be posted at the same time? Or do you have large numbers of postings that need to be run without blocking other users? I bet the answer is yes. If so, then you may also have experienced your screen freezing for several...
    on17 Oct 2012

  • Blog Post: Table Information including Index information (Usage, Blocks and Reads) - Again

    This is only the same query which is already here: Table Information including Index information (Usage, Blocks and Reads) But I noticed that the query somehow got mal-formed to a point where it could not run. So here is a cleaned-up version. In summary: This query shows a list of all tables...
    on8 Feb 2012

  • Blog Post: Export to Excel on Dynamics NAV: RTC

    Due to many and frequent questions on the topic of performance when exporting to MS Excel on RTC, I've summarized some of the answers in this blog to try and explain the impact of running MS Office automation objects on RTC . Let's start with Stefan's excellent blog on automation objects and considerations...
    on18 Aug 2011

  • Blog Post: SQL Server Data Compression and Microsoft Dynamics

    I am pleased to announce the release of the SQL Server Database Compression Analyzer for Dynamics. This tool was created to help Dynamics partners and customers leverage the benefits of SQL Server Data Compression and to make the processing of analyzing and implementing compression quicker and easier...
    on21 Jul 2011

  • Blog Post: RTC over WAN – What is the Required Bandwidth for my Workload

    As you probably know we shipped Dynamics NAV 2009 R2 with a few features to support running the RoleTailored Client over WAN. Specifically we added the capability of using Certificates to validate the Server that the client is connecting to and a Login dialog that enables a NAV user to type in credentials...
    on18 May 2011

  • Blog Post: Microsoft Dynamics NAV Changes by Version

    Microsoft Dynamics NAV has had multiple changes to the underlying code in order to optimize performance of NAV on SQL Server. The chart below shows the changes by version. REPEATABLEREAD In order to use the REPEATABLEREAD, changes are needed after installing the latest hotfix to enable the option...
    on12 May 2011

  • Blog Post: Microsoft Dynamics NAV and SQL Server Database Compression

    Microsoft SQL Server 2008 introduces two new compression features (available in Enterprise Edition) that are of interest to users with large databases. Data compression applies to individual tables and indexes within a database and comes in two options: ROW and PAGE. Backup compression is a new option...
    on11 Feb 2011

  • Blog Post: Designing reports for better performance on RTC

    Some of you might have run into scenarios that a report that runs for some (acceptable) time on classic client takes far longer time on RTC or simply even errors out with OutOfMemory kind of exception. Some have also asked what the limitation to number of records sent to RTC is, when experiencing...
    on2 Feb 2011

  • Blog Post: Degraded Performance on Dynamics NAV and the SQL Server TokenAndPermUserStore

    I have recently come across an issue with a large Dynamics NAV customer where queries that normally ran VERY quickly became slower and slower over time and blocking was increased significantly. After going through the normal troubleshooting activities there seemed to be no easily explainable cause for...
    on13 Jan 2011

  • Blog Post: Performance Analyzer 1.0 for Microsoft Dynamics

    The Microsoft Premier - Dynamics team has created and compiled a set of scripts and tools for helping analyze and troubleshoot SQL Server performance issues on the Dynamics products. These are the same tools that we use on a daily basis for collecting SQL performance data and troubleshooting SQL performance...
    on4 Nov 2010

  • Blog Post: Increased Deadlocking After Full Dynamics NAV Upgrade

    I was recently on-site at a large Dynamics NAV customer attempting to help them get through a number of significant performance issues they encountered on their two previous failed attempts to upgrade from NAV 3.70 to NAV 5.00 SP1. In summary, they had in excess of 100 concurrent users running relatively...
    on18 Oct 2010

  • Blog Post: Microsoft Dynamics NAV/SQL Server Configuration Recommendations

    Michael De Voe , a Senior Premier Field Engineer at Microsoft, has compiled a set of recommendations for SQL Server configuration to improve performance when running Microsoft Dynamics NAV 5.0 and later versions with one of the following versions of SQL Server: Microsoft SQL Server 2005 SP3 x64...
    on28 Sep 2010

  • Blog Post: Hosting Possibilities for Dynamics NAV 2009 R2

    With the release of Dynamics NAV 2009 R2 we have spent some time trying to understand the issues related to hosting the product. Based on these discussions we have added some things to the R2 release and will be adding things to the next release as well to accommodate hosting of NAV even further. The...
    on26 Sep 2010

  • Blog Post: Books! Five Options for Learning More About How to Create RoleTailored Solutions with Microsoft Dynamics NAV (Updated!)

    [Updated with a fifth book!] This month the fourth fifth English-language book on Microsoft Dynamics NAV 2009 is being released. For those of us working on Dynamics NAV, it is exciting to see that partners are so invested in our product that they eagerly spend months writing a book to help other partners...
    on7 Jun 2010

  • Blog Post: Table Information including Index information (Usage, Blocks and Reads)

    == Nov 9 update == In some cases we got integer overflow when running this query. So the table definitions in the query have now changed from using int to bigint to avoid this. == end of update == The query below combines these three queries into one: Index Usage Query Recent Bocking History...
    on25 Aug 2009

  • Blog Post: How to use WCF Performance Counters with NAV 2009 Server

    NAV Server (middle tier) utilises Windows Communication Foundations (WCF), which includes a number of performance counters that you can use to monitor NAV Server performance in real-time. This example shows how to monitor "Calls Per Second" for NAV Server to get some idea of how busy it is over a working...
    on19 May 2009

  • Blog Post: Cursor Types

    One of the changes in Microsoft Dynamics NAV version 5, was to change from primarily making use of Fast-Forward cursor types to Dynamic cursors. The same change was implemented in version 4 from build 26410, which is Version 4, SP3 Update6(940718) + KB950920. The change of cursor type can also mean...
    on20 Feb 2009

  • Blog Post: 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...
    on14 Oct 2008

  • Blog Post: 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...
    on11 Sep 2008

  • Blog Post: 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...
    on11 Jun 2008

  • Blog Post: 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...
    on3 Jun 2008

  • Blog Post: 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...
    on22 May 2008

  • Blog Post: 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...
    on12 May 2008

  • Blog Post: 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...
    on21 Apr 2008

  • Blog Post: Bulk Inserts in Microsoft Dynamics NAV 5.0 SP1

    Bulk Inserts is a new feature in NAV 5.0 SP1 which is designed to improve performance when inserting multiple records by delaying the physical inserts on the SQL Server. Before this change, inserts happen in the order that the C/AL code is running. With Bulk Insert, the NAV-client delays the actual...
    on14 Apr 2008
Page 1 of 2 (36 items) 12