Thanks Drew

That seems a bit easier to maintain and works pretty fast.

Thanks for the suggestions, I was hoping to avoid profiler since it can be a couple of weeks between events, so the DMV's might work. Are they less likely to...

Have you checked the power management settings, possibly even at the bios level. Whilst I've never experienced it myself, I've seen several articles about power management reducing the CPU speed...

Thanks for the input

The server is getting close to the max, it has 24 cores which never drop below 60% use, it has 32 gig of ram with an 80...

When you do the restore job are you using with standby. If you don't need to use the dr server as a reporting server then you don't need to use...

No offense taken, I did ask them if they could use something else, but got a resounding no, and since they're the customer I have to deal with it.

The actual...