Michael_Lowry
Cheers.
I'm aware of that thread, but I'm not sure what to make of it.
Automic support told me based on my logs that I should have at least three DWP, but the ideal number is not known to us. That goes for worker processes, too. Experimentation is difficult, because we can only really experiment on the production system (due to test systems not having the same load characteristics) and there is a lack of solid measurables.
Fourtyfive (even for a large installation) seems really excessive to me. A while ago we doubled WP (not DWP mind you, but WP) based on support advise, from a single digit count to doubly so but the result was inferior performance and seemingly (even) more database deadlocks, and a health check consultant who told us to reduce the number of WP back to single digits.
Finding the right amount of the various processes would be a lot easier if there were some documented, atomic (no pun intended) performance value for each process to look at. E.g. Automic could log and average how long object searches take and display it in the product (logs or administrative view), or include a benchmark tool that measures various operations, so you can hone in on the ideal values.
As matters stand, there's several screws to turn simultaneously, and few of them are properly labeled (as evident by your efforts to document the internal workings and responsibilities of the components).
*scnr*