My client uses SharePoint 2016 on prem. The last couple of months they started using third party software that send client files to one SharePoint library. For each client, a sub folder is created in this mentioned document library and the files uploaded in the relevant sub folders. This caused the document library to grew to 18000 files. (Containing a large amount of sub folders)
The problem they are experiencing is that when they upload a file now to one of those sub folders, it takes forever to upload it. The same when they set the properties as well as check-in.
Could it be that the contend DB is to large (it is 200Gb) or that the SQL server is running out of resources to handle these type of activities?
What is the suggested going forward from this? If I need to split the library, maybe move it to a different content DB - will it result in a new site collection?
Edited: I found the problem, the said document library has a workflow on it. The service bus message broker stopped working. I did a leave and join with the workflow manager and it is uploading files. However, I'd still like to know how to proceed with this large document library and big Content Database.