How Alerts can Degrade Your Dynamics AX System Performance

By Catherine Thole | March 22, 2016

The use of alerts in Microsoft Dynamics AX is a very helpful feature. Alerts allow end users to get an email or a Dynamics AX notification when a condition has been met. The purpose is typically to let the end user know they need to take action on something. For example, a common alert I see people set up is to notify an individual in the warehouse if the requested ship date on a sales order has changed. This way the warehouse worker can determine if they need to take action to be able to meet the new requested ship date.

What most people don’t realize is the impact alerts can have on the overall performance of their system. To understand why it makes an impact, it is helpful to realize what happens behind the scenes. Let’s take a look at what happens from the creation of an alert to the sending of an alert.

Creating an Alert and Sending Alerts in Dynamics AX

1. A system administrator sets up batch jobs for change based alerts, due date alerts, and email processing. These should be run on a recurring basis based on how quickly alerts are needed. The most often they can be set to run are every minute but most people find that this is too frequent and somewhere between 10 to 30 minutes works best in their system.

2. An end user creates an alert. When this happens a record gets written to the eventrule table and some associated tables (such as the eventruledata table). A record also gets written to the databaselog table. This is because the alerts functionality utilizes database logging to be able to track inserts, updates, and deletes to the table.

3. When a record is inserted, updated, or deleted for the table that the alert was set on database logging will write a record to the eventcud table.

4. When the alert batch job runs it will check the eventcud table to see if any of the alert conditions that are specified in the eventrule table have been met. If they have been met and an alert needs to be sent out that data gets written to the sysoutgoingemailtable and removed from the eventcud table. For records that didn’t meet the condition, they get removed from the eventcud table.

5. When the email distributor batch job runs this is what actually sends an email or a popup in Dynamics AX to the end user.

Example of Problematic Alerts in Dynamics AX

This process may not seem like it would be problematic, but it can be when alerts are set on high volume tables. Let’s say your company typically adds 1,000 sales orders an hour which would be considered a high volume. An account representative in your organization has a very important client that demands attention to any order they submit. So this account representative creates an alert to get notified anytime a sales order for this client is entered. This seems harmless but let’s look at what that does to the system. What happens is that for every sales order not only do you have these 1000 sales orders an hour added to the salestable but they are also added to the eventcud table. Meaning you have doubled the write activity on the database for these sales orders. The next part comes when the alert batch job runs. If it runs hourly then this batch job has to go through all 1000 sales orders to check to see if the sales order is for the client specified in the alert rule.

What can happen with these alerts on high volume tables is that the alert cannot finish processing the records because as it gets through checking records more records are added. What a number of people have run into is that the alert batch job will run for hours and not finish. This can prevent other batch jobs from starting if they utilize the same AOS Batch server.

Use Dynamics AX Alerts with Caution

While alerts are a feature in Microsoft Dynamics AX that can provide great benefits to an end user they must be used with caution. What I have started recommending is that my clients put into place a process for managing alerts. This process removes the ability for any individual to create alerts. An end user can request an alert to be setup but a subject matter expert/supervisor/system administrator has to review the alert and determine that it would not be detrimental to the system. If the subject matter expert/supervisor/system administrator determines that this alert provides business value and doesn’t pose a performance risk they can setup the alert on the user’s behalf.

In addition to alerts, my experience performing numerous health checks has allowed me to identify 10 other common issues affecting Dynamics AX system performance. A Stoneridge Software AX Health Check reviews several areas of your system and clients are provided with a scorecard and executive summary, presenting top issues and recommendations. Learn more about our Health Check service and download a sample AX Health Check Report here.

Related Posts

Recommended Reading:

5.27.22 Dynamics GP

How to Run Drop Ship Sales in Dynamics GP

Need to Invoice the Customer before you get the invoice from the vendor? This The freight forwarder has contacted you […]

Read the Article

New Features in Dynamics 365 Business Central 2022 Wave 1 Release – Protecting G/L Accounts From Being Deleted

There are a lot of exciting New Features in Dynamics 365 Business Central 2022 Wave 1 Release to get excited […]

Read the Article
5.25.22 Financials

Rounding Numbers in Power Automate

  If you’ve ever tried to round numbers in Power Automate, you have probably already run into the issue there […]

Read the Article

Manage U.S. Use Tax on Purchase Orders in Dynamics 365 Finance and Operations

  Managing sales tax requirements on your business purchase can be complicated, but Dynamics 365 Finance and Operations can help […]

Read the Article
5.19.22 Dynamics CRM

How to Write a Great Support Ticket in the Stoneridge Support Portal

Submitting a support ticket through the Stoneridge Support Portal is a quick and effective way to get assistance for any […]

Read the Article

Managing Your Business Through Uncertain Times Using Dynamics 365 Finance and Operations

  Dynamics 365 Finance and Operations (F&O) can help you make informed decisions on how to move your business forward. […]

Read the Article
5.13.22 Power Platform

Using Power BI Object Level Security

  The following article will demonstrate how to use Power BI Object Level Security to disable column data based on […]

Read the Article
5.12.22 Dynamics CRM

How to Use the Stoneridge Support Portal

Stoneridge Software’s support portal is an intuitive and useful function that makes it easy for you to access resources to […]

Read the Article
5.6.22 Dynamics GP

Dynamics GP Transaction Removal: Purchase Orders

  Are you having performance issues with Purchase Orders?  Do you find that there are old Purchase Orders on your […]

Read the Article

Start the Conversation

It’s our mission to help clients win. We’d love to talk to you about the right business solutions to help you achieve your goals.

Subscribe To Our Blog

Sign up to get periodic updates on the latest posts.

Thank you for subscribing!

X