RDLC Report and Performance in Microsoft Dynamics NAV 2015 and 2016

In a previous Blog dated back year 2014 https://blogs.msdn.microsoft.com/nav/2014/03/09/rdlc-report-and-performance-in-microsoft-dynamics-nav/ I have tried to give an overview related to the Out Of Memory exception that you might hit with Microsoft Dynamics NAV RDLC Report with the following versions: 2009 R2, 2013 and 2013 R2. The main focus of my dissertation now is based on the improvement…

5

A Couple of RDLC Performance Optimization Tips

We have received several requests related to optimization tips for the Microsoft Dynamics NAV RDLC report experience. So in this blog post we provide you with a couple of tips for how you can refactor a report in order to increase its performance in terms of dataset reduction – the example is based on the…

5

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 using cursors but MARS…

9

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/?LinkId=403898, and watch the video on how to install, configure and use…

10

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. I would encourage you…

12

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…

6

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 running server/client side: http://blogs.msdn.com/b/nav/archive/2008/12/03/automation-objects-in-microsoft-dynamics-nav-2009.aspx. As…

1

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. I know there are several generic “Compression Tools” available…

4

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 that are…

5