web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics AX (Archived)

AOS process abnormally large and oh where is SQL server process?

(0) ShareShare
ReportReport
Posted on by 655

I am currently having the worst time trying to do anything.  I noticed on the main server (AOS and AX databases) has a giant AOS and a small SQL process.  Any way to fix this without rebooting AOS?

5875.Capture01.jpg

*This post is locked for comments

I have the same question (0)
  • Martin Dráb Profile Picture
    237,878 Most Valuable Professional on at

    If you have SQL Server on the same box as AOS, it's clearly not a production system (unless you have a really bad setup), therefore restarting the AOS service shouldn't be a big deal. Nevertheless I don't believe that SQL Server can consume such a little amount of RAM when running correctly; something is likely wrong there.

  • Suggested answer
    Erik HB Profile Picture
    205 on at

    It's easy enough to verify where the SQL is running by checking the AX 2012 Server Configuration in Administrative Tools.  Most likely it is running somewhere else and the SQL Server process showing in the screenshot is not used.  It could be a SQL Server Express instance, perhaps used by a backup solution.

    I also see from your screenshot that you also have both SSRS and a large IIS process running on this same server.  (Enterprise Portal, perhaps?)

    You also have Management Reporter running.

    I have not found any reliable way to free up the memory taken by the AOS process, so a service restart will be needed recommended if you really need to release that memory.

    Is the current memory consumption causing your system to slow down?  Try to recycle the IIS worker pool, that may free up about a gig, at least temporarily.  Same with SSRS, try to restart that service, if you can.  But again, that is only likely to be a short-term solution.

    As Martin alludes to in his answer, running all-in-one is not a recommended configuration for a production environment, so this certainly looks like a development box where you should be able to stop and restart services pretty much any time you want.  If it is, you can run on a single server, but you'll need lots of memory.  Heaps...  Lots and lots...  Otherwise it will just be too painful.

    As you are worried about restarting, I'm going to assume for a moment that this is a production environment.  In that case, please split your services out to different servers.  SQL Server and SSRS can run on the same server if you are concerned about SQL licensing costs, just make sure there is enough memory in that box to serve both.  SQL Server is designed to take as much memory as it can get, so if you are going to co-host it with anything else, set the maximum memory limit through SSMS to make sure that the operating system and any other services (such as SSRS) will have enough memory to run.  The AOS should not be on the same server, and MR2012 really should have its own server as well.

    Enterprise Portal can be a real resource hog, so move that to a separate one as well.

    The official recommendation to split out the different services to separate servers is not just because Microsoft wants license revenue, there are real performance reasons for it.  Just make sure the servers have good, fast network connectivity between them.  As fast as you can go, and with low latency.

  • Suggested answer
    Vilmos Kintera Profile Picture
    46,149 on at

    The normal AX AOS operation is around 5 to 8 GB per instance, what you are seeing is completely normal.

    Running SQL Server on the same instance is only acceptable for a single-box development environment. That will not show the exact memory usage in Task manager, since if you have correctly set up SQL Server, it is using the Commit memory space. Enable that by right clicking the column header and select Commit size to get the actual figure.

    You can set a startup flag on the AX Server Configuration utility which would tell how much % of the available memory space could be allocated to the AOS process.

    You can also set the maximum allowed memory for the SQL instance, so they would not be competing with each other.

    But by doing this, you are putting both your AX AOS and SQL Server into memory pressure situation which affects performance negatively.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Priya_K Profile Picture

Priya_K 4

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#3
Ali Zaidi Profile Picture

Ali Zaidi 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans