how to find separate ping time for each database in mirroring in sql server

Category: sql server mirroring

Question

Dix14 on Mon, 09 Oct 2017 07:49:58


The issue is that there is a separate ping for each database, not one for all. So some are successful and some fail.

Replies

Atif-ullah Sheikh on Mon, 09 Oct 2017 08:51:11


Please check the below msdn article for better answer;

https://docs.microsoft.com/en-us/sql/database-engine/database-mirroring/possible-failures-during-database-mirroring

Fitnesspris on Mon, 09 Oct 2017 09:00:57


Is thirdparty software a "no go"?

Otherwise there are some SASS solutions that can handle this.

Dix14 on Mon, 09 Oct 2017 09:44:22


HI Atif,

Thanks for the reply,

But i want to know 

how to find separate ping time for each database in mirroring in sql server ?

Lin Leng on Tue, 10 Oct 2017 07:52:07


Hi Dix14,

>>how to find separate ping time for each database in mirroring in sql server ?

Exactly what does that mean? Could you please elaborate more?

If you have any other questions, please let me know.

Regards,
Lin

Atif-ullah Sheikh on Tue, 10 Oct 2017 08:28:46


As per the documentation;

".... database mirroring implements its own time-out mechanism, based on each server instance in a mirroring session sending out a ping on each open connection at a fixed interval."

As mentioned in the link that I shared, ping time is related to sql server instance. It is internally handled by sql server mirroring. Ping request is not related to a specific database. You can change the ping timeout but thats another thing.

Can you please explain what exactly you are trying to achieve? That would be helpful to give you a better answer :).

Dix14 on Wed, 25 Oct 2017 22:53:22


Is there any separate session time out   at  databases  level which is involved in database mirroring ?

Dix14 on Wed, 25 Oct 2017 22:53:31


Is there any separate session time out   at  databases  level which is involved in database mirroring ?

Lin Leng on Tue, 31 Oct 2017 07:42:42


Hi Dix14,

>>Is there any separate session time out   at  databases  level which is involved in database mirroring ?

Yes, please refer to the timeout option in ALTER DATABASE.

If you have any other questions, please let me know.

Regards,
Lin

Tom Phillips on Tue, 31 Oct 2017 11:59:28


Just to clarify,  the server monitors the response to the other servers involved in the database mirroring through a "ping" mechanism, at the server level.  The value of that delay is then used by the database level "timeout" value to determine if it should failover.

If you have 100 mirrored databases, it does not do 100 pings, it does 1 and uses that timing value for all 100 databases on that server.