09-16-2015 02:42 AM
Hi all,
Environment:
We are starting to see repeated 196 errors (client backup was not attempted because backup window closed) and looking at the Job Details we see that the reason is "awaiting resource NEXSAN_STORAGE_UNIT. Maximum job count has been reached for the storage unit." This limit is currently set to 10 and looking at the performamnce figures of the storage there isn't an awful lot of headroom to allow for an increase this of this figure.
We were wondering if there is a report that we can run which will show us over the course of a typical backup window the length of time each individual job has a "lock" of the resource unit. It's not as easy as looking at the "Elapsed time" colum within the Activity Monitor as this time includes any delays encountered. What we need is to see the legnth of time the resource unit is in use per job.
Is that possible?
Thanks,
Graham
Solved! Go to Solution.
09-16-2015 08:08 AM
You can get the actual run time from OpsCenter. There is a table called nb_jobattempt with column activestarttime. That shows when the job went active, not when it was queued.
09-16-2015 08:08 AM
You can get the actual run time from OpsCenter. There is a table called nb_jobattempt with column activestarttime. That shows when the job went active, not when it was queued.
09-16-2015 08:13 AM
Perfect! Thanks Riaan.
09-16-2015 09:25 AM
Pleasure