Red Gate forums :: View topic - High CPU on VERIFY
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Backup 6
SQL Backup 6 forum

High CPU on VERIFY

Search in SQL Backup 6 forum
Post new topic   Reply to topic
Jump to:  
Author Message
meastland



Joined: 28 Mar 2011
Posts: 36

PostPosted: Tue Aug 14, 2012 11:03 pm    Post subject: High CPU on VERIFY Reply with quote

We have a backup configured against a ~ 300GB database to use the following options: CHECKSUM, COMPRESSION = 4, COPY_ONLY, FILECOUNT = 4, INIT, THREADPRIORITY = 1.

The backup appears to run fine, and compresses the combined backupset down to about 80GB. However, when it gets to the VERIFY step, the SQBCoreService.exe process pegs the CPU on a 4 x 2 GHz virtual server with 32GB of RAM.

I guess my question is, does the VERIFY step adhere to the THREADPRIORITY parameter, or does that just apply to the BACKUP step? Either way, is this expected behavior for the VERIFY step?
Back to top
View user's profile Send private message
petey



Joined: 24 Apr 2005
Posts: 2277

PostPosted: Wed Aug 15, 2012 3:44 am    Post subject: Reply with quote

This is indeed a bug, and a bug report has been raised for this (ref. SB-5367).
_________________
Peter Yeoh
SQL Backup Consultant Developer
Associate, Yohz Software
Beyond compression - SQL Backup goodies under the hood, updated for version 7
Back to top
View user's profile Send private message Send e-mail
meastland



Joined: 28 Mar 2011
Posts: 36

PostPosted: Wed Aug 15, 2012 3:10 pm    Post subject: Reply with quote

Peter,

Thanks for the quick response. Is it possible to be notified when the fix is available?

Thanks,

-Mike
Back to top
View user's profile Send private message
petey



Joined: 24 Apr 2005
Posts: 2277

PostPosted: Wed Aug 15, 2012 4:20 pm    Post subject: Reply with quote

I did not notice earlier that you are on version 6.

There are no plans for any new releases for version 6, as we are currently on version 7. You can still download a patch for this bug using the following link:

ftp://support.red-gate.com/patches/sql_backup/SQB_6_5_2_22.zip

The zip file contains two files:

SQBCoreService.exe
SQLBackupC.exe

To apply the patch, please follow the steps below:

1. Close all GUI connections to the SQL Server.
2. Ensure that no SQL Backup jobs are in progress.
3. Stop the SQL Backup Agent Service, or disable the cluster resource if on a cluster.
4. On the SQL Server where the SQL Backup server components are installed, navigate to the installation directory. Defaults are:

32-bit Machines - C:\Program Files\Red Gate\SQL Backup 6\(local) or <SQL Instance Name>
64-bit Machines - C:\Program Files (x86)\Red Gate\SQL Backup 6\(local) or <SQL Instance Name>

5. In the folder you will find an existing SQBCoreService.exe and SQL BackupC.exe. Rename the existing files, for example to OLDSQBCoreService.exe and OLDSQLBackupC.exe.
6. Now copy in the files extracted from the downloaded zip.
7. Restart the SQL Backup agent service/cluster resource, and ensure that it starts successfully.
8. Perform a test backup to ensure that all is OK. Then test to see if the THREADPRIORITY value is used for a verification process that is performed after a backup.

Please note that this patch has not been thoroughly tested, so use it at your own discretion. This patch release also includes other fixes, as listed in this document:

ftp://support.red-gate.com/patches/sql_backup/SQB_6_5_2_patch_history.txt
_________________
Peter Yeoh
SQL Backup Consultant Developer
Associate, Yohz Software
Beyond compression - SQL Backup goodies under the hood, updated for version 7
Back to top
View user's profile Send private message Send e-mail
meastland



Joined: 28 Mar 2011
Posts: 36

PostPosted: Wed Aug 15, 2012 5:06 pm    Post subject: Reply with quote

Thanks, Peter. I will deploy and test the patch as time permits.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group