Question about 'Conflicting Schedules'...

Compresses, encrypts, secures and monitors SQL Server backups.

Moderators: JonathanWatts, Chris Auckland, eddie davis, Colin Millerchip, Brian Harris, james.billings, RBA, petey

Question about 'Conflicting Schedules'...

Postby SQL_ME_RICH » Fri May 25, 2012 12:01 am

So - I'm looking at the cool timeline graph inside of SQL Backup 7, and it's a nice way to see the schedule I have in place for my various instances. One of the things however that I am curious to understand is whether or not my various instances are going to have issues with jobs that collide in scheduling? I have somewhere between 2 to 4 jobs that kick off, from different databases, at various points in a 24 hour period, on nearly all of my instances (DIFFS and TLogs).

To date - when I have tested out restores, they all have seemed to be fine, but is this going to become an issue at some point? Or is it just a cautionary alert to make me aware of the potential taxing that the PROC could experience?

As always - many thanks for any and all feedback!
SQL_ME_RICH
 
Posts: 64
Joined: Tue May 08, 2012 10:41 pm

Postby Marianne » Fri May 25, 2012 8:56 am

Hi,

It's the latter case: jobs that are scheduled to run at the same time are highlighted in the timeline as conflicting schedules to warn you of the demand on your server's processors and I/O. This may cause jobs to take longer to run.

Cheers,

Marianne
Marianne Crowder
Red Gate Software Limited
Marianne
 
Posts: 45
Joined: Mon Oct 03, 2011 3:24 pm

Postby SQL_ME_RICH » Fri May 25, 2012 7:25 pm

Thank you Marianne! I will plan accordingly.

P.S. This product truly does rock! The compression alone is a huge selling point for me, but I like the fact that this is more than just a fancy looking front-end. Nice stuff, and keep up the great work!
SQL_ME_RICH
 
Posts: 64
Joined: Tue May 08, 2012 10:41 pm


Return to SQL Backup 7

Who is online

Users browsing this forum: No registered users and 0 guests