What are the challenges you face when working across database platforms? Take the survey
Options

Backup process consumes way to much CPU

achoynaachoyna Posts: 2
edited March 2, 2008 9:30AM in SQL Backup Previous Versions
We're running SQL backup v5.2.

Is there any way through the GUI to reduce the CPU consumption so that the DB will still be somewhat responsive to queries?

I saw in a previous forum entry some syntax for an earlier version (v4) of backup to achieve this from the command line. Has it changed for v5? What is the proper syntax?

The backups would take longer understandably, but at least the site would be more responsive.

Thanks in advance,

Alan

Comments

  • Options
    peteypetey Posts: 2,358 New member
    Compression level 1 uses the least CPU cycles, while compression level 3 is CPU intensive.

    You could also use the THREADPRIORITY option to set SQL Backups' process priority to below normal.
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
Sign In or Register to comment.