Skip to main content

Notifications

Announcements

No record found.

Finance | Project Operations, Human Resources, ...
Suggested answer

Batch jobs running better in sandbox environments than in Prod

(2) ShareShare
ReportReport
Posted on by 29
Hello,
 
We've been having this issue for the last 2 months in our company. We also upgraded to 10.0.37 at the beginning of February, but can't say it's relevant or not.
Summary is below:
 
  • During January close, we ran the depreciation proposal batch job just as every other month. It usually takes 5-7 hours. This one didn't complete after 15 hours. At the same time, we ran it in a sandbox environment after refreshing the data from Prod and which is also identical with the production code-wise. It ended in 5 hours successfully. 
  • During February close, which is also the first month close after replaced Revenue Recognition with Subscription billing, the recognition batch job threw an SQL related error twice. Then the third attempt ended successfuly but in 28 hours. We ran the same batch job in the sandbox environment (again identical to prod data&code-wise) and it ended in 12 hours successfully. Btw - This batch job tested multiple times in real life data in a Tier-2 sandbox before go-live and the batch jobs were completed in min 5 max 8 hours successfuly. We were obviously expecting a similar situation after the go-live but here we are. 
We have contacted Microsoft support but infortunately no help. They -as most of you are aware- usually take these things case by case and whenever they see a customization they stop supporting. We tried to explain this under multiple incidents that this issue is bigger as we don't have a reliable production environment and also we can't rely on any tests we run in sandbox as after the deployment the results may be different in production. 
 
We can't start to work on an improvement given the fact that we can't trust the test results we'll get in sandbox environments. 
I thought it would be a good idea to share this here and i'm looking for a reason why the sandbox all over sudden stop representing production. Is there something that's related to version 10.0.37? Or anything else specific to production environments that we're not aware of? Any idea would be much appreciated. 
Thanks,
Nagehan
  • Suggested answer
    Kevin Xia Profile Picture
    Kevin Xia Microsoft Employee on at
    Batch jobs running better in sandbox environments than in Prod
    Hi,
    Have you checked whether the configuration of both environments is the same? Includes settings, parameters, or any custom configuration that may affect batch job performance. Or compare the hardware and resource allocation of sandbox and production servers. If your production environment is low on resources, it may result in slower performance.
    Best regards,
    Kevin
  • andreasraithel Profile Picture
    andreasraithel 4,812 Super User 2024 Season 2 on at
    Batch jobs running better in sandbox environments than in Prod
    Hy,
    please compare Batch job and scheduling priority in PRD and sandbox, by default all batches are disabled by database movement activity.  
    So the batch job planing - which hopefully exists - could give more insghts, what batches are running in parallel with what priority and what is the expected workload for each batch.
     
    Herzliche Grüße / kind regards,
     
    Andreas Raithel
    D365FO Solution Architect
  • Suggested answer
    Mohamed Amine Mahmoudi Profile Picture
    Mohamed Amine Mahmoudi 10,150 Super User 2024 Season 2 on at
    Batch jobs running better in sandbox environments than in Prod
    Hi Nagehan,
     
    Please try these production environment monitoring
     
     
    Best regards,
    Mohamed Amine MAHMOUDI

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

Congratulations 2024 Spotlight Honorees!

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December!

Congratulations to our December super stars! 🥳

Get Started Blogging in the Community

Hosted or syndicated blogging is available! ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,622 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,354 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans