AXUG Roundup – January in Minneapolis

Rod Hansen and I headed south to Minneapolis (yes, everything is south of Fargo) to join the Minnesota chapter of AXUG for dinner and a discussion on the Performance Analyzer tool.  The Minnesota chapter is very well attended and we had a good turnout for this meeting – about 20 folks there in total.  Ben Syltie…

1

AOS Load Balancing

I’ve been questioned several times recently about AOS load balancing in Dynamics AX, and there seems to be quite a bit of confusion about how to properly configure AX for AOS load balancing, as well as high availability. Here are a few clarifications that apply to Dynamics AX version 4.0, AX 2009 and AX 2012:…

3

Update on determining Disk Latencies with Performance Analyzer for Microsoft Dynamics

In my previous blog about Determining Disk Latency with Performance Analyzer for Microsoft Dynamics, I spoke of how to determine the disk latency.  In testing, we have determined that the computed latency from sys.dm_virtual_io_file_stats does not match Windows Performance Monitor Avg. Disk Sec/Read and Avg. Disk Sec/Write. There are many technical details around why the…


New DMVs in SQL Server 2008 R2 SP1 and SQL 2012 (‘Denali’) and Performance Analyzer for Microsoft Dynamics

One of the new features in Performance Analyzer 1.10 for Microsoft Dynamics is support for new DMVs in SQL 2008 R2 SP1 and SQL 2012. In this blog, we’ll explain what the new DMVs are and how they are used in analysis of performance issues in Microsoft Dynamics deployments.   New DMVs: sys.dm_os_windows_info                 This…

2

Performance Analyzer 1.10 for Microsoft Dynamics

We would like to announce the release of Performance Analyzer 1.10 for Microsoft Dynamics.  This new and exciting release has a long list of new features: Peformance Analyzer 1.10  NOTE: SQL Server 2008 and above only for this version. ·         An hourly capture of data that shows your transaction volume per table per hour ·        …

4