When setting up Microsoft SQL Server 2012 AlwaysOn Availability Groups with Microsoft Dynamics AX 2012 you may run into an issue when attempt to enable the “Partial Containment” option on the Dynamics AX production database, which is a pre-requisite for AlwaysOn. When you attempt to enable...

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....

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...

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...

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...