I am trying to understand how Delta is monitored in log-shipping. We have log-shipping monitoring in place and I am seeing delta increases sometimes for random instances and it drops once database is synchronized. My questions are:

  1. What is Delta in log-shipping?
  2. What is effect of Delta on log-shipping monitoring?

Please let me know if anymore information is needed.

Thank You for your time.

  • IIRC Deta was feature in SQL Server 2000, You have tagged your question as SQL Server 2008 – Shanky Dec 24 '14 at 15:20
  • I am seeing delta increases - where are you seeing this? – Aaron Bertrand Dec 24 '14 at 15:20
  • @Aaron It is in our monitoring alerts. – Im88 Dec 24 '14 at 15:21
  • That tells me absolutely nothing. – Aaron Bertrand Dec 24 '14 at 15:21
  • 1
    @AaronBertrand: Alert is for log-shipping monitoring and what I believe this delta is set for copy job. I know this is very broad question to begin with. But, all I am trying to understand is is there any specific definition of Delta in logshipping monitoring. – Im88 Dec 24 '14 at 15:34

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.