"OneDrive Is Updating Files" never ends and has high CPU

[AloisKraus]

I have two machines where one has a large bunch of files (ca. 360 GB) while the other machine has only a small fraction of them downloaded. 

After reaching some point OneDrive does stop syncing anything. When looking at the machine with  high CPU I find that most time is spent in KernelBase.dll!LCMapStringW by the sync engine. 

Procmon and ETW shows what happens:

1. Enumerate a file on my drive
2. Call LCMapStringW with the file name
3. read/write SyncEngine-2020-08-03.2209.25372.179.aodl 
4. Goto 1

Between each file enumeration ca. 2.5s! are spent in LCMapStringW and sync engine. That is an insane amount of CPU to walk through the file system.

The aodl file seems to be some encrypted SQL database which I cannot read. Has OneDrive for business scalability issues with many small (ca. 10K) files? 

[#2]

@AloisKraus I've seen performance issues when tracking tens of thousands of constantly changing files. However I have found that a number of the computers with problems had quite old versions of OneDrive that were perhaps not as well optimised.

The raw size of the files is probably less interesting than the number of files and the rate of change. However I think there is definitely a long way to go with OneDrive efficiencies e.g. I've noticed my OneDrive tracking thousands of changes in a folder that is not synced to that computer.

The synchronization limits are easily found via web search e.g. https://docs.microsoft.com/en-us/office365/servicedescriptions/sharepoint-online-service-description...  but YMMV according to software versions etc.

[#3]

@Mike Williams: 300K files is not that much. My main workload are memory dumps and ETL files which comes with thousands of pdbs per zip. The previous product I used was Synplicity which allowed me to skip .pdb, .dmp, .etl from syncing. I always get compressed files so I can easily sync the compressed files and unzip them locally. 

With OneDrive For Business the world was simplified. Now everything is synced and I cannot prevent it. I did ask our IT and they said that feature is there but only at tennant level. 

In the new world it looks like I need to copy the data again somewhere else and uncompress them before OneDrive gets a chance to overflow. 

How can I check with OneDrive how many files I have in the cloud? The Storage explorer only shows files sizes but not counts. 

If I look at the ObfuscationStringMap.txt file I find 174647 lines which should mean that I have at least so many files. 

[#4]

@AloisKraus wrote

"Now everything is synced and I cannot prevent it. I did ask our IT and they said that feature is there but only at tennant level. " You can choose which folders to sync at the client level.

"How can I check with OneDrive how many files I have in the cloud? " Sure, I'll google that for you too: https://answers.microsoft.com/en-us/msoffice/forum/all/onedrive-for-business-how-count-number-of-fil...

[#5]

@Mike Williams: I think you underestimate the mental capabilities of paying customers. The googled linked answer was valid until the site design was changed. 

See attached screenshot. The "new" way is to open the context menu to show the Manage Storage view but this shows only file sizes but not the file counts. 

Do you have an answer to my question which is not outdated?

[#6]

@AloisKraus You're on a public forum and just get other members of the public like me who don't have a crossword puzzle within reach during a coffee break. If you want someone to pay attention to you as a paying customer then you need to contact Microsoft Support.

I found the answer from the link I provided worked quite well on both my OfB account and personal OneDrive. The Site Contents does show #files for each Doclib. It is not the same page as the site Storage Metrics.