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 job or task prioritization Expand / Collapse
Author
Message
Posted Sunday, July 7, 2013 9:06 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, February 27, 2014 9:04 PM
Points: 46, Visits: 113
Dear All,

My current SQL configuration is SQL 2008 standard edition (Vmware virtualized 2 node failover cluster) on windows 2008 R2 .
Whenever I run my SQL backup the CPU shoots up over 90%. How do I restrain this so that the CPU does not go up above 60%. Is there any way I can prioritize this task ?

Many thanks,
Jai
Post #1471022
Posted Monday, July 8, 2013 2:15 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, July 25, 2014 3:20 AM
Points: 1,375, Visits: 2,661
I'm sure this can be done with Resource Governor
Post #1471084
Posted Monday, July 8, 2013 3:04 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, February 27, 2014 9:04 PM
Points: 46, Visits: 113
Thanks, Is this something that can be done upfront even before the job actually kicks in (my job is a scheduled task)
Post #1471094
Posted Monday, July 8, 2013 3:12 AM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 12:33 AM
Points: 4,432, Visits: 4,169
mJai (7/7/2013)
Dear All,

My current SQL configuration is SQL 2008 standard edition (Vmware virtualized 2 node failover cluster) on windows 2008 R2 .
Whenever I run my SQL backup the CPU shoots up over 90%. How do I restrain this so that the CPU does not go up above 60%. Is there any way I can prioritize this task ?

Many thanks,
Jai


Sounds like there's something misconfigured. Taking a backup shouldn't cause that much CPU usage. What's the CPU usage on the VMware host. How is the IO throughput during backup.


Markus Bohse
Post #1471096
Posted Monday, July 8, 2013 3:17 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, July 28, 2014 2:06 AM
Points: 42, Visits: 248
Hi - You can use Resource Governor. But I would recommend to find why cpu usage is high during backup rather than solving it temporarily/ restricting it to certain percentage of cpu.

Is the usage consistently 90+% through out the backup?
Which time are you taking the backup? (Production or off hours)
Which type of backup?
What is the size of database and backup file?
Are you using compression mode to take backup?
What is the waiting types happening during taking the backup?
How many processors are in the server?
What is the physical memory size?
Are you taking the backup to disk/ tape/ network path?
Find out if there is cpu or any other resource bottleneck there.
Post #1471098
Posted Monday, July 8, 2013 11:05 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, February 27, 2014 9:04 PM
Points: 46, Visits: 113
I shall get back after conducting couple of tests. Thanks.
Post #1471439
Posted Monday, July 15, 2013 3:00 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, February 27, 2014 9:04 PM
Points: 46, Visits: 113
Found the culprit. It was a 3rd party tool causing this havoc!
Post #1473533
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse