Hi Eirikur,

Thanks for the reply. I didn't explain my issue very well!

I have some processes that fail with errors like this (in the SQL Server Log):
Tue 2017-05-09 14:39:15 spid1598...

Thanks for the link, it looks interesting. I will study it in more depth.

To determine the CPU being used I'm look at total_worker_time this time minus whatever it was last...

Hi Jacob, thanks for the response.

Basically I sample the DMV every hour and compare it to what I sampled the previous hour. I then do some further augmentation of what...

Or do a smaller backup of a known size using the same infrastructure, as the time taken should be fairly linear (twice as big, twice as long).

Time of day can...

Thanks MadAdmin.

We run regular CHECKDB and it comes back OK. The system has been rebooted and the issue persists.

It's SQL Server 2012 Enterprise Edition Service Pack 3 (but we had...

That's a great article with good points and a really powerful and easy to assimilate comparison graphic David.

Thanks for sharing it.

Tim Walker

Eric M Russell (8/21/2015)

Tim Walker. (8/21/2015)

Eric M Russell (8/20/2015)

GilaMonster (8/20/2015)

The logical reads should be the same...

Eric M Russell (8/20/2015)

GilaMonster (8/20/2015)

The logical reads should be the same with identical plans. The physical...

That's very interesting Gail. I'll have a think about that, it certainly seems to answer the question.

Thanks for your help. I very much appreciate it.

Best Regards

Good Tip!

Attached...

Sorry guys I've just checked the plan and there are client specific details in it so I can't post it.

Thanks for your input anyway, I appreciate it.

Thanks

Tim