SQBCoreservice consuming 80 - 90% cpu
stevenhoban
Posts: 21
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.
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.
Comments
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
SQL Backup generates a log file for each process that it runs. The default folder where the logs are stored is C:Documents and SettingsAll UsersApplication DataRed GateSQL BackupLog<instance name> on Windows 2003 and older, and C:ProgramDataRed GateSQL BackupLog<instance name> on Windows Vista and newer.
SQL Backup Consultant Developer
Associate, Yohz Software
Beyond compression - SQL Backup goodies under the hood, updated for version 8
If you provide an email address I'll forward them to you as attachments or if you email a link I can upload them.
SQL Backup Consultant Developer
Associate, Yohz Software
Beyond compression - SQL Backup goodies under the hood, updated for version 8