none
send queue piling up RRS feed

  • Question

  • My mirror server is down and send queue is piling up on principal and it consumed full disk space. So, the transactions that happen on principal will no longer be stored? When mirror comes online, will these transactions be lost. How many hours can the mirror server be down?

    Kiran

    Sunday, September 1, 2019 1:31 PM

Answers

  • Yes, you are right.

    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com

    • Marked as answer by juniorkiran Saturday, September 21, 2019 4:21 PM
    Friday, September 20, 2019 9:44 AM

All replies

  • Hi juniorkiran,

     

    >>My mirror server is down and send queue is piling up on principal and it consumed full disk space. So, the transactions that happen on principal will no longer be stored?

     

    The reason that your disk of principle server  is filled up is not the send queue, but the transaction log on the principal server has been growing because it cannot be truncated and reused.

     

    The send queue does not consume extra storage or memory on the principle server, it is present on the transaction log file (LDF) of the principal database. There will be a flag in the transaction log that points to the oldest of all the log records that were not sent to the mirror server. Then from the beginning of this mark to the latest log is the "send queue". The principal server continuously fetches the oldest logs from this queue and sends them to the mirror database.

     

    >>When mirror comes online, will these transactions be lost. How many hours can the mirror server be down?

     

    These transactions are not lost. When the mirror server is back online, the principal server will still send the log blocks to the mirror server according to the send queue. Just if the send queue is large, it will take a long time to synchronize the data.

     

    Regarding mirror server downtime, this may depend on the disk condition of your principle server. When the principal server cannot truncate the log because of sending queue flags, the log will grow until it is full of disks, which may even affect the use of the principal server.

     

    Best regards,

    Dedmon Dai


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com

    Monday, September 2, 2019 2:42 AM
  • So, mirror server can be down for any number of days? Also, if the log file of principal server is full, it cannot accept any more transactions, correct?

    Kiran

    Monday, September 9, 2019 12:35 AM
  • Yes, you are right.

    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com

    • Marked as answer by juniorkiran Saturday, September 21, 2019 4:21 PM
    Friday, September 20, 2019 9:44 AM