What are the challenges you face when working across database platforms? Take the survey
Options

cpu issues with sql backup

go4relaxgo4relax Posts: 6
edited March 15, 2006 5:22AM in SQL Backup Previous Versions
hi there.

currently i am evaluating sql backup and i've got one question:

when i execute a local backup (compression 1) for a ~ 40GB database
the service consumes about 40% of cpu on my single cpu testserver.

if i test the same backup to a networkshare (1gb lan attached directly via
a switch) the cpu consumption raises to ~ 75-80%!

this looks pretty much to me....

thanks for information

ps: sorry for my bad english, but in austria it's german :-)

Comments

  • Options
    peteypetey Posts: 2,358 New member
    Do you get a similar increase in CPU usage when using native SQL Server backup?
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
  • Options
    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
  • Options
    peteypetey Posts: 2,358 New member
    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.
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
  • Options
    yes, there is more cpu, lets say 20% more.

    regards, dieter
  • Options
    peteypetey Posts: 2,358 New member
    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.
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
  • Options
    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
  • Options
    peteypetey Posts: 2,358 New member
    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.
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
  • Options
    it is only the SQBCoreService.exe process.

    thx, dieter
Sign In or Register to comment.