Post reply

Qeries to find the timeout and heartbeat??

  • February 15, 2012 at 10:43 am

    #255760

    Are there any qeries to find out the timeout and heartbeat for sql server mirroring quorums??

  • February 15, 2012 at 12:01 pm

    #1447472

    Actually i tried some common dmvs but don't know how to get the value of mirroring timeout and mirroring heartbeat. I know we can change this as follows:

    ALTER DATABASE <dbname> SET PARTNER TIMEOUT .....

    But how to know what is the current timeout value...

  • February 15, 2012 at 1:56 pm

    #1447541

    SELECT Mirroring_Connection_Timeout

    FROM sys.database_mirroring

    WHERE database_id = db_id('MyDB')

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

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