Save time and reduce costs through the optimization and automation of AX operations with our AOS State service.
Introducing our latest and most advanced feature yet, designed to benefit your company. Interested in learning how? Read on below.
AOS State is an advanced tool that automates the monitoring and resolution of operational issues in Microsoft Dynamics AX. It enhances system stability, reduces downtime, and frees up IT resources by identifying and addressing problems in real-time. With AOS State, your company benefits from more stable and efficient AX operations, saving both time and money.
How our AOS State service will benefit your company
How does it work?
Many companies find that their Microsoft Dynamics AX systems require constant monitoring and manual intervention to ensure stable operation, which is time-consuming and resource-intensive.
AOS State is an advanced tool that automates the monitoring and resolution of the most common operational issues in AX. It combines deep insights into the SQL platform and AOS server mechanisms with real-time data to ensure optimal system performance.
Benefits to your company
By using AOS State, companies can reduce downtime, increase system stability, and free up IT resources. The automation ensures that critical issues are identified and resolved quickly, improving productivity and reducing operational costs.
Make your company more competitive
Compared to manual monitoring and other less integrated tools, AOS State offers a more comprehensive and automated solution that proactively handles issues before they impact operations. This makes it a reliable and efficient investment for any company using Microsoft Dynamics AX.
Discover more about the service here for additional information.
Microsoft Dynamics AX (AX) is a complex system with numerous users and is critical to the overall operation of virtually every company.
Operating AX, especially monitoring and addressing operational challenges as they arise, is often a time-consuming task that must be managed 24/7 in many companies.
Drawing from our extensive experience with the SQL platform within AX and deep insight into the mechanisms of AOS servers, we have developed and refined an tool over several years. This tool can automatically address a range of the most common AX operational issues, ensuring stable system operation regardless of the time.
Typical operational challenges
AOS State continuously monitors the execution of x++ code in AOS servers, SQL queries against the database, and combines this with critical metrics on Windows resources such as CPU usage, etc. This data provides input for automation that can identify and resolve many common operational issues, some of which are listed below:
Monitoring of AX system tables
AX comprises various system tables, including number sequence tables and session tables. These tables are critical to AX’s overall performance, and any prolonged locking can lead to system hang-ups. AOS State can be configured to monitor these conditions and automatically address locking queries on these tables, treating them as application errors or inefficient code. Subsequently, the action is logged for further investigation.
Autotuning
If AOS State identifies significant variation in execution time for a given query in AX, it automatically executes an Update Statistics command against the database and removes the corresponding query plans in the SQL database’s Plancache. This ensures stable operation with minimal fluctuations in the expected execution of various AX functions.
Inappropriate user behavior
AX users can create custom queries on AX forms, resulting in complex table joins in the database and, in some cases, prolonged locks. Queries generated by users are reported based on a parameter-driven threshold for lock duration. With AOS State, information about the locking user can be obtained, allowing for contact with the user to gather more information about the executed function and initiate optimization accordingly.
Monitoring of inappropriate transactions in AX
In AX, developers may choose to perform transactions against the SQL database within a TTS scope. Historically, not all developers have followed best practices for these transactions, leading to unnecessarily long transactions. AOS State reports such inappropriate TTS transactions and underlying queries, allowing them to be identified and corrected in the code.
Monitoring of AX batch jobs
AOS State monitors and reports on failed batch jobs, as well as those exceeding predefined thresholds.
Monitoring of ongoing queries
The design of the AX client from Microsoft is single-threaded. This means that if a user initiates a long-running query, the AX client appears frozen to the user while waiting for the AOS server to respond. Users often mistakenly choose to force-close the AX client, leaving the initiated query running in the background. AOS State automatically terminates these unfinished queries on the AOS server and SQL database, preventing system slowdowns.
General monitoring
In addition to the above, AOS State continuously monitors the AOS server for draining, dead queries, and overall resource consumption for query optimization purposes.
All incidents are logged in the AOS server’s application log and can also be logged to .txt files for import into third-party systems or sent via email to administrators.
All features of AOS State are controlled via fully configurable thresholds and can be enabled or disabled as needed by each company.
Automated AX operations
With AOS State, you can have a tool that automates and monitors several critical aspects of operating a Microsoft Dynamics AX installation. The tool can address many of the most common but critical operational issues that arise in daily AX operations.
AOS State is compatible with AX 4.0, AX 2009, and AX 2012.
Interested in an uncommitted conversation
Click the link down below and connect with us, to find out how we can help you achieve peak optimization
