Share via

High Redo Queue - No Availability Group

Jayson Sainsbury 26 Reputation points
2020-09-10T17:38:22.703+00:00

I am getting alerts from our monitoring system that the Redo Queue is high but we do not have high availability or any type of database mirroring. I have searched the forums and the only thing I am seeing is dealing with a secondary replica. What else could be causing the queue to grow so large?

23765-image.png

SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

Answer accepted by question author

Shashank Singh 6,251 Reputation points
2020-09-14T13:20:42.977+00:00

here are no results returned.

You are getting false alert from your monitoring system it seems, time to check with them to make sure they have not made any wrong configuration.

Was this answer helpful?

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. hilary cotter 11 Reputation points
    2020-09-12T01:36:47.5+00:00

    What does this dmv return?
    use master

    GO
    select * From sys.dm_hadr_database_replica_states`

    Was this answer helpful?

  2. Cris Zhan-MSFT 6,676 Reputation points
    2020-09-11T02:31:16.517+00:00

    Hi @Jayson Sainsbury ,

    The SQLServer:Database Mirroring performance object contains performance counters that report information about SQL Server database mirroring. Log Send Queue KB indicates the total number of kilobytes of log that have not yet been sent to the mirror server.

    Maybe you can run the script in this article to check If Mirroring enable for Database .

    If the answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    Was this answer helpful?

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.