Pages

Tuesday, April 23, 2013

Friday, April 19, 2013

New book: Implementing Microsoft Dynamics AX 2012 with Sure Step 2012

Packt Publishing has released a new book about implementation of Microsoft Dynamics AX 2012 with Sure Step 2012

Here is their overview of the book:
  • Get the confidence to implement AX 2012 projects effectively using the Sure Step 2012 Methodology
  • Packed with practical real-world examples as well as helpful diagrams and images that make learning easier for you
  • Dive deep into AX 2012 to learn key technical concepts to implement and manage a project
I'll be posting a review as soon as possible.

Check out the book here.

Thursday, April 18, 2013

Book review: Dynamics AX Performance Optimization Guide

When dealing with performance issues you have to understand in depth how all the components in a solution work by themselves and in collaboration with the specific other components of the solution. You also need to master several different toolboxes to measure performance of the various components. Few people master all these components and tools in depth.

This book is a collection of information you need to be able to prevent and to troubleshoot and fix performance issues with a Microsoft Dynamics AX 2009 and 2012 solution and the components that make up the total solution. The authors have described each topic in an easy and understandable style. You can read it with the purpose of learning more about performance with Microsoft Dynamics AX solutions and you can use it later on as a reference guide.

Experienced, or somewhat experienced, Microsoft Dynamics AX technical consultants are the main audience of the book.

The very first part of the book explains a bit about the architecture of a Microsoft Dynamics AX solution and there is a detailed description about how concurrency control works with Microsoft Dynamics AX.

Second chapter deals with how you monitor the solution. Database monitoring and various performance counters are described in this chapter. As all performance problems starts with some code being executed, there is a large section about tools to monitor and trace the code. This includes Microsoft Dynamics AX Trace Parser, Windows Event Tracing, WCF Service Trace Viewer Tool, Microsoft Visual Studio Profiling Tools, WebServer Performance Tester, Web Performance Test for Enterprise Portal, Performance Analyzer for Microsoft Dynamics AX and Process Monitor.

In the third chapter, there are explanations of things that need consideration for setup and configuration of the solution. This covers I/O configuration, backup strategies, SQL Server configuration, network configuration and Microsoft Dynamics AX configuration.

Fourth chapter deals with several common Microsoft Dynamics AX performance problems. And what you can do to fix these problems.

The fifth chapter is almost entirely dedicated to how you can optimize what SQL statements
Microsoft Dynamics AX sends to SQL Server. The chapter also covers a number of important SQL Server flags.

Chapter six is about the many optimization possibilities you have with SQL Server 2008 and 2012. The optimizations that specifically relates to Microsoft Dynamics AX performance and manageability are discussed here.

Database index management, fragmentation, statistics and locking behavior is covered in chapter seven. Here you can read about how to detect and reduce fragmentation, how to update statistics and how to control the locking behavior.

In the eighth chapter, you can read about how to plan and size the infrastructure for a solution to support the expected load on the system. Even though there is no silver bullet or a magic spreadsheet, as someone from Microsoft put it on the last Technical Conference for Microsoft Dynamics AX, there is a good take on a guide for calculating the expected workload. And how to do your sizing against that calculation. Also in this chapter you will find information helping you with eventual virtualization, Hyper-V, considerations.  

The book covers a lot of ground and it cannot stand alone as a single educational tool for all the described tools and components. You can for example find information much more detailed other places about Microsoft AX development for performance. However, that would make the book ten times thicker. With the books focus on the, for Microsoft Dynamics AX solutions, important things, the book works. I could make the bold statement that you could consider the book to be a kind of a Maggi cube for the information you need about all the different components that make up the Microsoft Dynamics AX performance experience.

I will definitely recommend the book. The investment in the book will quickly pay off if you are a
technical consultant working with performance issues in relation to Microsoft Dynamics AX.   

Martin Zhen and Daniel Liao are the authors of the book. I believe both to be employed at the Chinese offshore development center OutsourceAX. Regrettably, they have been too modest to include bios of themselves in the book. It would have been interesting to learn more about these guys.

Friday, April 12, 2013

New blog address

This blog will from now on be redirected to http://www.agermark.com.

Google seems to be redirecting everything OK, except existing RSS settings. So you might want to update your RSS subscription to the new address.

New book: Dynamics AX Performance Optimization Guide

A new book about Dynamics AX performance optimization is out. It is called "Dynamics AX Performance Optimization Guide: Fixing Troubles with Microsoft Dynamics AX and SQL Server" and it is available from Amazon.


I'll soon post a reveiew of the book.

Tuesday, April 2, 2013

Setup the March 2013 demo machine for VirtualBox

On the new demo image for AX 2012, the image running on Windows Server 2012, I couldn't get EP and Role Centers to work. Not even using the usual trick where the hosts file is modified.

I'm definitely not a networking guy, but by reading the documentation for Hyper-V that comes with the image, I actually figured out how to change settings correctly for the image.

First you need two network cards for the machine. One for running its own private network, and one to give it Internet access through your physical machine.

These are the settings for the first card:


Notice the network name: AX2012.

And these are the settings for the second card:



After starting the image, you need to do some configuration of the network card running the internal network. To figure out precisely what card that is, open a command prompt and enter ipconfig to check IP addresses of the cards. It should be the card having an IP address starting with 169.

From the Control Panel you must now open Network and Sharing Center and click Change adapter settings. On the card running the internal network, right-click and choose Properties.
Select Internet Protocol Version 4 (TCP/IPv4):


Now click Properties and enter the following information:



Click Advanced to open this dialog:


And here you need to enter all these IP addresses, with subnet mask 255.255.255.0:
  • 10.20.12.101
  • 10.20.12.110
  • 10.20.12.111
  • 10.20.12.112
  • 10.20.12.113
  • 10.20.12.114
  • 10.20.12.120
  • 10.20.12.121
When you save the new network settings, it might warn about the same settings being applied to another network card. That would be that card setup for Hyper-V, and you wont have a conflict with that. You can safely let it remove these settings from the other card however.

Save everything and reboot.

It takes quites a while for both AX and the portal to come alive, so be patient.

For the two other machines that are involved in the full demo setup, you probably need to do the same. The IP addresses to add are different though. You can see the numbers in the Hyper-V documentation that comes with the image.

Any comments to guide me and the rest of the community to an eventual better process are welcome. It is very limited what kinds of questions I'll be able to answer.