SQL 2008 - Resource Governor - CLBackup.exe

Question

SQL 2008 - Resource Governor - CLBackup.exe

DanielP

SSCrazy

Points: 2320
More actions
April 10, 2013 at 1:54 pm

#270950

Hello,
We are having issues with a backup system (CLBackup.exe) taking too much CPU when it does a disk backup. It is being used by our hosting company to perform a daily backup of specified files and directories. The time of the backup run and the amount of files backed up have all been modified but still seeing too much CPU pressue when it runs.
It averages about 35% CPU but can take as much as +50% CPU which is putting too much pressue on the Database server.
Can the Resource Governor be used to throttle the CPU usage of this exe?
Thanks,
Daniel

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

syed_h_ali2001 SSC Enthusiast Points: 113 More actions · Answer 1

Hi Daniel,

Here is the answer to your forum. You can go to task manager and from task manager click on processes. In that tab you would see CLBACKUP.EXE. Right click on it then choose affinity and there you can select the number of CPU's you would like CLBACKUP to use. Example if you have 16 CPU's. Select only four and that way it would limit it to 25% CPU Usage only.

Syed Ali

Steve Jones - SSC Editor SSC Guru Points: 736255 More actions · Answer 2

You could use RG if you use a specific account/group for backups that you can fit into a classifier function. Read about that if you need to. This will potentially limit CPU if needed, otherwise the backup can run with more resources.

However you ought to think about syed's idea of limiting threads.

DanielP SSCrazy Points: 2320 More actions · Answer 3

Thanks for the reply Syed and Steve. Yes, Syed's idea should work. They would have to set up a new account\group for the service to do your approach Steve.

We need to monitor that the next time it runs, it only used those threads only and the job finishes in a timely matter.

Thanks,

Daniel