• Thanks for the response

    I got the below error from mirror at the same time from sql error log :

    Error: 1204, Severity: 19, State: 4.

    The instance of the SQL Server Database Engine cannot obtain a LOCK resource at this time. Rerun your statement when there are fewer active users. Ask the database administrator to check the lock and memory configuration for this instance, or to check for long-running transactions.

    Error: 1454, Severity: 16, State: 1.

    Database mirroring will be suspended.

    Server instance 'XXXXXXXXX' encountered error 1204, state 4, severity 19

    when it was acting as a mirroring partner for database 'XXXXXXXXX'.

    The database mirroring partners might try to recover automatically from the error and resume the mirroring session.

    For more information, view the error log for additional error messages.