default threadpriority setting...

swjohnsonswjohnson Posts: 30
edited July 28, 2005 12:43PM in SQL Backup Previous Versions
What is the default threadpriority setting for SQLBackup?

Thanks

SJ
· Share on Twitter

Comments

  • peteypetey Posts: 2,358 New member
    Normal.
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
    · Share on Twitter
  • swjohnsonswjohnson Posts: 30
    What is the impact/benefit of boosting that setting?

    SJ
    · Share on Twitter
  • peteypetey Posts: 2,358 New member
    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
    · Share on Twitter
Sign In or Register to comment.