345
Hi All,
I have created a view based on view 'LEDGERACTIVITYANALYSISCURRENCYAMOUNT' and 'LEDGERENTRYJOURNAL' to get journalBatchnumber .
Query is performing well in dev VM but at tier -2 environment execution time is quite high.
I took back of AX DB and restore on my local VM and ran same query but query ran quickly.
Would like to know, how tier -2 environment having same AX DB transactions are running for so long?
*This post is locked for comments
Thanks Sukrut.
Analysis ed execution plan and found most of time has taken by multiple "Table Spool/Lazy Spool".
Looked few articles on it . any suggestions are welcome
It could be a lot of things.
For example, different versions of SQL Server (or the same version with different service packs or hotfix levels). Or, different trace flags, providing for different query optimizations. Or, different SQL Server configuration, such as Maximum degree of parallelism or any other configuration option that impact query optimization. And so on.
Have you checked out the cached compile plan on each server and compared them?
#1
André Arnaud de Cal...
291,883
Super User 2024 Season 2
#2
Martin Dráb
230,569
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
