SQL Backup has 3 main operations: reading backup blocks from SQL Server, compressing the data and writing them out to disk. With a 'normal' priority, you are pretty much a normal citizen in a queue when it comes to receiving CPU cycles to perform each of the task.
With a priority boost, you'll receive priority in receiving CPU cycles to carry out your tasks, at the expense of other processes (not a good thing on a SQL Server box).
THREADPRIORITY was introduced to allow demoting the SQL Backup thread processes, so as not to grab too much CPU cycles from SQL Server operations during high workload periods.
Peter Yeoh
SQL Backup Consultant Developer
Associate, Yohz Software Beyond compression - SQL Backup goodies under the hood, updated for version 8
Comments
SQL Backup Consultant Developer
Associate, Yohz Software
Beyond compression - SQL Backup goodies under the hood, updated for version 8
SJ
With a priority boost, you'll receive priority in receiving CPU cycles to carry out your tasks, at the expense of other processes (not a good thing on a SQL Server box).
THREADPRIORITY was introduced to allow demoting the SQL Backup thread processes, so as not to grab too much CPU cycles from SQL Server operations during high workload periods.
SQL Backup Consultant Developer
Associate, Yohz Software
Beyond compression - SQL Backup goodies under the hood, updated for version 8