150
We have noticed that dropdown filters for certain columns in SalesTable are extremely slow to open. SalesTaker loads instantly, but "Customer Account" or "Sales Order" columns take roughly 8 seconds to load.
Noticed this ever since we updated to
Ever since we updated our production environment to
10.0.14 (10.0.605.20012) Update38 (7.0.5778.41503)
I've checked the indexes and such, I can't seem to figure out what the issue might be. We have about 500k rows in SalesTable.
Hmm, I ran a simple SELECT * FROM dbo.SalesTable frrom SSMS on our UAT environment, and it's taking 7 seconds exactly to load the table, and it only has 60.000 rows in it. The clustered index scan takes 1 second only, so my best guess is that the AOS is making requests to SQL which are taking a long time to fetch. Thinking this has to be something with Microsoft's server infrastructure.
There are no more details on the log and the support staff could not help
I think the environment engineers might have responded because I raised the log as critically high and it was having dramatic effect on our business
Hi Agneum
Finally received this notification that the environment engineers did apply a fix to our performance issue
Microsoft has an internal Watchdog searching for issues and the system the same has detected your performance issue and executed the needed SQL script to fix the issue at 05:11 UTC
Overnight there has been a dramatic change to our environment and the sales order controls are now responding well 1-2 seconds
Our logged support call state they have not done anything
I am now in the situation that I have no idea what the cause was or the solution they applied
All is satisfactory now, how is you environment?
Ironically, our test environment is faster than our production.
Work that one out?
Our test environment is on the new self-service environment, production is still Microsoft Managed.
Have you made sure your production is on the Generally Available - Version 10.0.14?
The initial version had a major DFX issue
#1
Abhilash Warrier
185
#2
Martin Dráb
149
Most Valuable Professional
#3
Vahid Ghafarpour
130
Super User 2025 Season 1
Share
Report
All responses (
Answers (
