How can we help you today? How can we help you today?

Restore - THREADPRIORITY vs Backup - THREADCOUNT

Hi,

It exists in the backup command the option THREADCOUNT but not in the restore command.
In the restore command it only exists a THREADPRIORITY option.

Does the restore command automatically use the maximum number of threads possible ?
Is the restore command using the same number of threads as used to backup the DB ?
How could we optimise the restore of a DB ?

Thanks in advance for your replies,
Jerome
Dje
0

Comments

4 comments

  • petey
    The restore uses the same number of threads as that used during the backup.
    petey
    0
  • Dje
    Your answer makes me wondering the following :
    Could this lead to a CPU (ressources in general) overflow on our development servers if we optimise our backups on production servers where we have more processors than on development ?
    How is SQL Backup handling this ?
    Dje
    0
  • petey
    When you create a backup using the THREADCOUNT option, say using a value of 4, SQL Backup is receiving backup data from SQL Server for 4 'backup files'. However, SQL Backup consolidates the compressed backup data for these 4 'files', and stores them on a single file.

    During the restore process, SQL Server will expect to receive data from 4 separate 'files', which SQL Backup will need to provide. Each of these 4 'files' will be handled by a separate thread. If the number of processors on your system is less than the number of restore threads, there will be more frequent context switching on each processor, which will affect throughput.

    >> How is SQL Backup handling this ?
    SQL Backup has no choice but to create the same number of restore threads internally to service each of SQL Server's restore thread.
    petey
    0
  • Dje
    Thanks Petey.
    Dje
    0

Add comment

Please sign in to leave a comment.