Database Mirroring - set partner timeout

Question

Hi,

I made a test on a Virtual Machine with three SQL Server instances at the same server.

I tested the failover time with this option enabled:

ALTER DATABASE NOME_BASE set partner timeout 60

But the database mirroring failover in only 2 seconds.

This option "set partner timeout 60" doesn't work in the same instance? Only for different

I found this information on microsoft site:

Failure is detected: The failure is detected by the mirror and the witness. Hard failures
(such as server power failure) are detected quickly (typically in around 1
second). Soft failures (such as storage failure) take a bit longer to detect.
The default timeout for communication (a ping message) between the principal,
the mirror, and the witness is 10 seconds. The timeout can be modified by using
the ALTER DATABASE SET PARTNER TIMEOUT command. If the principal doesn’t respond
(to the ping message) within the timeout period, it is considered to be down. If
you change the timeout setting, it is a best practices recommendation to set it
to 10 seconds or higher. Setting it to lower than 10 seconds may result in false
failures under heavily loaded or sporadic network
conditions.

http://technet.microsoft.com/en-us/library/cc917681.aspx

Thanks for your time

---

Fabrício França Lima | MCP, MCTS, MCITP | Visite meu site: http://fabriciolima.net | Dicas de artigos SQL: Siga-me no twitter @fabriciodba.

Answer 1

Does you database is on SQL Server Clustered instance? 

---

http://uk.linkedin.com/in/ramjaddu

Answer 2

No. Two normals instances in the same server.

AMBIENTE5 and AMBIENTE5\INST1

Thanks RamJaddu

---

Fabrício França Lima | MCP, MCTS, MCITP | Visite meu site: http://fabriciolima.net | Dicas de artigos SQL: Siga-me no twitter @fabriciodba.

Answer 3

Then Pls check this thread for answer http://www.sqlmag.com/blog/sql-server-questions-answered-28/sql-server/why-isnt-the-mirroring-partner-timeout-working-137113

---

http://uk.linkedin.com/in/ramjaddu

Answer 4

Hi RamJaddu.

I was right. This only work with a windows failure in diferent servers.

Thanks for your time.

---

Fabrício França Lima | MCP, MCTS, MCITP | Visite meu site: http://fabriciolima.net | Dicas de artigos SQL: Siga-me no twitter @fabriciodba.