Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL 2008 - Resource Governor - CLBackup.exe Expand / Collapse
Author
Message
Posted Wednesday, April 10, 2013 1:54 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, July 3, 2014 8:53 AM
Points: 80, Visits: 199
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



Post #1441001
Posted Wednesday, April 10, 2013 3:41 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, October 22, 2014 11:07 AM
Points: 5, Visits: 314
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
Post #1441046
Posted Wednesday, April 10, 2013 3:44 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 4:00 PM
Points: 31,181, Visits: 15,627
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.







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1441048
Posted Wednesday, April 10, 2013 4:11 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, July 3, 2014 8:53 AM
Points: 80, Visits: 199
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



Post #1441062
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse