default threadpriority setting...

• 
  Normal.

  petey July 28, 2005 12:22

  - 0 +
• 
  What is the impact/benefit of boosting that setting?
  
  SJ

  swjohnson July 28, 2005 12:29

  - 0 +
• 
  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.

  petey July 28, 2005 12:43

  - 0 +

Add comment

Please sign in to leave a comment.