Browse by Tags

  • Blog Post: Microsoft Dynamics NAV: Faster than ever.

    First, let me start by saying that based on the evidence so far: It is. Significantly. A number of the changes to the Dynamics NAV 2013 architecture contribute to the performance boosts that many of the test have shown. To outline some of the changes: Middle tier is 64 bit We are no longer...
  • Blog Post: Introducing the Microsoft Dynamics NAV Application Profiler

    Did you ever wish you could monitor how your application code performs at real time? We have produced a sample and a video that can help you get started with C/AL tracing and application performance profiling. Get the Microsoft Dynamics NAV Application Profiler here, http://go.microsoft.com/fwlink...
  • Blog Post: RDLC Report and Performance in Microsoft Dynamics NAV

    It has been a while since I last blogged and I am taking the chance now to post on a very delicate argument. The main focus of my dissertation is about performance (Out Of Memory exception, typically) with Microsoft Dynamics NAV 2009 R2, Microsoft Dynamics NAV 2013, and Microsoft Dynamics NAV 2013 R2...
  • 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...
  • 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...
  • 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...
  • 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...
  • 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...
  • 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...
  • 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...
  • 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...
  • 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...
  • 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...
  • 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...
  • 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...
  • 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...
  • 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...
  • 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...
  • 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...
  • 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...
  • 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...
  • 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...
  • 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...
  • 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...
  • 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...
Page 1 of 2 (39 items) 12