Separate to multiple AOS for performance

(0) Share

Report

Posted on by Lifeisbelieveful

363

Hello,

I have a severe problem for performance, one of our customers ask to solve their slow performance.

In the general journal function, when they make new ledger in the form(LedgerJouranlTransDaily) it is slow and one of the fields in grid blinks.

Since there is no customization fields or methods and the time when we test it is not slow, I just suspect the slow performance happens due to many active sessions and transactions.

I want to know that if there is a maximum limitation number that can run a query at the same time in DB and if I make new AOS on the same server to make them use AOS separately depends on their company(e.g. Company1 -> AOS1 / Company2 -> AOS2, only multiple AOS with one DB), then can it reduce running time?

Otherwise, will it make the server slower to use multiple AOS?

Please give me any information.

Thanks.

*This post is locked for comments

I have the same question (0)

All responses (1)

Answers (0)

Martin Dráb 239,364 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

No, there is no such limit, but if the database server or AOS is overloaded, it'll definitely have impact on performance. Another problem with many concurrent sessions may be in locking.

I suggest you start monitoring long-running queries, to verify whether you theory is correct and it is, which query is the problem. I would also look at blocked queries and general resource consumption on all machines (database, AOS, client).

If you're not familiar with it, take a look at Performance Analyzer for Dynamics.

Was this reply helpful? Yes No