I am working on creating a written workflow for handling a large imagery dataset at my organization and teaching future users how to create them. Quick summary of my workflow:
1. Create Mosaic Dataset
2. Add Rasters to Mosaic Dataset
3. Define Overviews
4. Build Overviews
Step 4 is where I encountered the issue. On my first test, building the overviews took 35 minutes for ~900 imagery tiles. During step 3. I designated that the overviews be stored in the file geodatabase.
Once I finished my documentation, I decided run through it to make sure it was coherent and easy to follow. I did everything the same, except this time, when Defining Overviews in step 3, I did not designate them to be stored in a file goedatabase, but rather a folder on my C drive. When I clicked run, I immediately noticed that the tool was going much slower. When it finally finished it had taken over 5 hours to run.
I decided to comb through the tool logs in the GP history panel and I came across one big discrepancy.
Just before the tool started generating overviews, it said the following:
2023-10-18T13:44:59.883: Distributing mosaic dataset operation across 10 parallel instances on the specified host: [GIS-0123].
When I go to that same spot in the log for the second run, I can clearly see that it did not say anything about parallel processing. Here is a screenshot from the logs (the log on the right is the 35 minute run and the log on the left is the the 5 hour run).

The only thing I did differently was in the defining overview stage. So I can't figure out why the parallel processing was affected. I did not tweak the parallel processing environment settings in either tool. Anyone have any experience with this issue?