Coffee Break: Monitoring and troubleshooting NAV Services, Part III – Performance troubleshooting and profiling User Activity using PowerShell

Since the release of Microsoft Dynamics NAV 2013, tracing user activity has become a bit more complicated than it used to be in earlier versions due to the fact that unlike previously, all user connections to SQL Server are now server┬áconnections. Which makes it more difficult to trace individual user activity. But not impossible: Enabling…


Coffee Break – Monitoring and Troubleshooting Services Part 2

In this post, we thought we might look into how to use Windows PowerShell to work with XML data. As a user scenario, we are continuing here on our previous post, to look further into server troubleshooting possibilities. You might experience an error, warning, behavior that you want to analyze, but have no clear repro…


Coffee Break – keeping stuff in the cloud

In the last few Coffee Break posts we have been looking at virtual hard disks (VHDs) and virtual machines (VMs). Now let’s combine the two in the cloud. Coffee Break 11 – Provisioning – Using Microsoft Azure storage to keep VHDs and other useful stuff in the cloud Provisioning a new instance of Microsoft Dynamics NAV is like…


Watch Out for Zombies When Using Microsoft Dynamics NAV with “xact abort” Enabled

If you have turned on the xact abort connection setting option for the Microsoft Dynamics NAV SQL Server instance, then you should watch out for Zombies. With this option turned on, users of your solution risk seeing an error stating This SqlTransaction has completed; it is no longer usable along with a crash signature which includes a…