100% true... was isolated to my environment :w00t:

what do you mean my top running :w00t:

I think sp_lock give you valuable information and based on that you can investigate further

😛

Thanks to all for their valuable update.

So what I understand is Differential backup is important but not hard and fast. What is important is your log backup must be...

Thanks for so quick response.

But my only point is running differential backup for big database and highly transactional database, will impact the performance....

sorry for late, might be you already got the answer. I am just answering on my behalf and you can judge how correct I am :-

1. how do we troubleshoot...