AlwaysOn database going to Suspend Mode

  • I noticed that one of the databases frequently go to suspend mode and I need to manually go to AlwaysOn Group and have to do resume data movement.

    Can I try to find the root cause to know why it is frequently happening against this single DB alone?

    The DB size is 14 GB+

    Thanks.

  • Can I try to find the root cause to know why it is frequently happening against this single DB alone?

    Yes. What have you tried so far?

    Is it happening at a certain time every day, and if so, what else is happening at that time? How frequent is "frequently"?

    Give us some more background; how many databases in that AG? How many nodes are there? Is the AG synchronous or asynchronous?

    What does the AG dashboard say- anything in there that might help? What about the Windows Event Log?

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply