We use a maintenance plan to back up all of our many user databases every hour. Since upgrading to SQL Server 2019, database performance has been impacted while backups are running, so we are looking to optimize our backup settings. Correct me if I am wrong, but it appears that settings such as compression threads and CPU throttle apply on a per-databases basis and the maintenance plan backs up multiple databases in parallel. Is there any way to limit how many databases are backed up at one time so that we can get a better handle on LiteSpeed's resource consumption?
