cpu issues with sql backup

go4relax · March 14, 2006 4:50AM

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 :-)

petey · March 14, 2006 5:19AM

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

go4relax · March 14, 2006 8:11AM

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

petey · March 14, 2006 10:14AM

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.

go4relax · March 15, 2006 1:52AM

yes, there is more cpu, lets say 20% more.

regards, dieter

petey · March 15, 2006 2:36AM

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.

go4relax · March 15, 2006 4:49AM

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

petey · March 15, 2006 5:02AM

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.

go4relax · March 15, 2006 5:22AM

it is only the SQBCoreService.exe process.

thx, dieter

cpu issues with sql backup

Comments

Product Learning

Community Forums

Events & Friends

Simple Talk