cpu issues with sql backup

• 
  Do you get a similar increase in CPU usage when using native SQL Server backup?

  petey March 14, 2006 05:19

  - 0 +
• 
  hi.
  
  no, with the native backup (other stuff is ident) the cpu usage
  grows to a mx. of ~25-30%
  
  thx in advance & best regards,
  dieter

  go4relax March 14, 2006 08:11

  - 0 +
• 
  What I meant to ask was if there was a difference in CPU usage if you perform a native backup to a local drive and to a network share? Thanks.

  petey March 14, 2006 10:14

  - 0 +
• 
  yes, there is more cpu, lets say 20% more.
  
  regards, dieter

  go4relax March 15, 2006 01:52

  - 0 +
• 
  By 20%, do you mean from say 10% usage, it increases to 12%, or from 10% it increases to 30%?
  
  Also, when the CPU usage increases to 75-80%, is it all utilised by the SQL Backup process, or together with one or more other processes?
  
  Thanks.

  petey March 15, 2006 02:36

  - 0 +
• 
  hi.
  
  there are no other tasks on this server, so the cpu consumption is 'netto' :-)
  
  for comparison :
  
  dbsize ~ 40GB
  
  backups local:
  native ~ 0-5% cpu
  sql backup ~40% cpu
  
  backups via lan (1 gb - 0[zero] hops)
  native ~ 0-25% cpu
  sql backup ~60-85% cpu
  
  thanks,
  dieter

  go4relax March 15, 2006 04:49

  - 0 +
• 
  Is this per process or overall? If overall, is the 60% - 80% usage wholly used by the SQBCoreService.exe process, or is there some other process involved? Thanks.

  petey March 15, 2006 05:02

  - 0 +
• 
  it is only the SQBCoreService.exe process.
  
  thx, dieter

  go4relax March 15, 2006 05:22

  - 0 +

Add comment

Please sign in to leave a comment.