SQBCoreservice consuming 80 - 90% cpu

Forum for users of Redgate's SQL Backup tool

SQBCoreservice consuming 80 - 90% cpu

Postby stevenhoban » Mon Jul 29, 2013 4:44 pm

I need help troublshooting as to why whenever we get a 100% processor utilization using sql monitor the culprit is always SQBCoreservice consuming 80% - 90% processor usage.
There are no conflicting jobs running at the time ( it appears to be random, happening a few times a week on various servers on our estate)
The transaction log is backed up every 10 mins using a sql backup 7. There are no other backups occuring ( these happen at 1am in the morning when nobdoy is accessing the servers)
Do I need to actually monitor things as the problem occurs ? I have only noticed the matter after the event - it mostly only happens for around 5 - 10 mins but the other day it lasted for 25 mins.
I understand the compression is the only cpu intensive process from the reply i recieved last time. This doesnt explain though why it would suddenly max out the cpu as we are backing up every 10 mins ( the trans log) and generally no issues througout the day.
stevenhoban
 
Posts: 15
Joined: Thu Apr 18, 2013 4:41 pm

Re: SQBCoreservice consuming 80 - 90% cpu

Postby rayherring » Sun Nov 23, 2014 10:28 pm

I have a very similar problem.
I am running a full backup of a 4TB database. For months the backup succeeds with little impact on the rest of the system. Of course it takes multiple hours.
Now, suddenly the backup core service is using 100% of 8 cores for the entire period of the backup.
The backup is set to create 8 files so the file sizes are manageable (each is ~50GB). Compression is set to Level 3. CheckSum and Verify are OFF.

According to Perfmon, SQBCoreService is using an average of 400% processor with a maximum of 500+. Perfmon also shows all 8 Cores at continuous 95% plus User Time.

Update: This was not a Red Gate Backup issue.
I spent some additional time analyzing this issue and I have determined that there is not really a specific problem. The database is 4TB and I am backing it to 8 files (all on the same disk). The server has 8 cores (2 x 4). The final files are around 40GB each (+/-15GB). The backup takes about 4 hours when several major application activities are shut down. When those same activities are running the backup can take up to 7 or 8 hours.

Right now, with just normal application processing in progress, I see that all 8 cores are consistently well-over 60% utilization and the Average %Idle Time for each core is in the 20% - 30% range.

So the issue here is clearly that the processors are just at overload under normal circumstances and adding the full backup just drives them to saturation :)
Last edited by rayherring on Fri Dec 05, 2014 5:48 pm, edited 1 time in total.
Ray Herring
rayherring
 
Posts: 13
Joined: Wed Oct 29, 2008 4:30 pm
Location: US - Tx

Re: SQBCoreservice consuming 80 - 90% cpu

Postby petey » Tue Nov 25, 2014 3:35 am

Could you please post the contents of the SQL Backup log file for a backup that previously had little impact on the system, and a recent one that is taking up 80% - 90% of the CPU?

SQL Backup generates a log file for each process that it runs. The default folder where the logs are stored is C:\Documents and Settings\All Users\Application Data\Red Gate\SQL Backup\Log\<instance name> on Windows 2003 and older, and C:\ProgramData\Red Gate\SQL Backup\Log\<instance name> on Windows Vista and newer.
Peter Yeoh
SQL Backup Consultant Developer
Associate, Yohz Software
Beyond compression - SQL Backup goodies under the hood, updated for version 7
petey
 
Posts: 2296
Joined: Sun Apr 24, 2005 12:34 pm

Re: SQBCoreservice consuming 80 - 90% cpu

Postby rayherring » Wed Nov 26, 2014 4:06 pm

I don't mind sharing the files with Red Gate but I am not willing to post them on an open forum :)
If you provide an email address I'll forward them to you as attachments or if you email a link I can upload them.
Ray Herring
rayherring
 
Posts: 13
Joined: Wed Oct 29, 2008 4:30 pm
Location: US - Tx

Re: SQBCoreservice consuming 80 - 90% cpu

Postby petey » Thu Nov 27, 2014 3:38 am

You can send me the files at peter.yeoh@red-gate.com
Peter Yeoh
SQL Backup Consultant Developer
Associate, Yohz Software
Beyond compression - SQL Backup goodies under the hood, updated for version 7
petey
 
Posts: 2296
Joined: Sun Apr 24, 2005 12:34 pm


Return to SQL Backup Previous Versions

Who is online

Users browsing this forum: No registered users and 1 guest