Basically the system is telling you it doens't have time to "Clean the room" Before the next guest is arriving.
You can extend the period given so that the processes get some more time, but that is just postponing your pain. You need to either decrease the data (or the resolution of the datra), increase (speed) the hardware or go for a cluster.
No - in general the the serialization and all the extra that a network Connection between the 2 Machines will cause more overhead than you potentially gain from a "exclusive" SQL.
Is it an old machine or is it under spec?
Yes I stumbled upon this in Atscon some time ago, I also noticed I could not find this info in CAS doc's,
Is there more info on the CAS-procedures,
No sorry please, just tell me as it is (-;
Start by going to HTTP://YOUR-CAS/diagconsole
There in the middle column you have "Task Schedule Status" - click on that!
Now you get to a list showing you the task, when they were executed last and how long it took.
I'm betting 1$ or €uro that the "DBDailyMaintenance" never completed. Click on that task and then click "Execute" in the following window - then wait and eventually repeat until successful.
Best is if you do this as early as possible in the morning so that you don't collide with any of the bigger scheduled jobs that will kick in after midnight.