March 3, 2012 at 11:57 am
All,
We keep recieving this alert in the errorlog
spid17s Error: 1479, Severity: 16, State: 1.
2012-03-03 12:18:11.15 spid17s The mirroring connection to "TCP://xxx-xxx.xxxx.org:2323" has timed out for database "xxxxxxx" after 10 seconds without a response. Check the service and network connections.
its been coming in every so often for the ppast few days . i cant figure out whats causing it . any ideas on where to look? the mirror history never shows any disconnets so im confused as to what this is actually indicating.
March 3, 2012 at 12:13 pm
The default mirroring time out value is 10 seconds. You need to increase this number if you have more and more database transactions.
March 3, 2012 at 12:20 pm
ok let me add a little more detail .
so this alert is being logged on the mirror not the principal also
The mirroring connection to "TCP://xxx-xxx.xxxx.org:2323"(this address is of the witness) has timed out for database "xxxxxxx"
there is not anymore transactions going on especially on the weekend.
March 3, 2012 at 12:29 pm
ok i noticed something that im unsure would cause the problem but will throw it out as well. the clock was off on this server thats generating the alert. its time was 5-6 minutes behind the mirror. i have resolved that issue now
March 3, 2012 at 12:31 pm
You can increase the timeout value by below command.
ALTER DATABASE XXXXX SET PARTNER TIMEOUT 30
March 3, 2012 at 6:36 pm
can i perform this command on a live DB with no issues? and i should run it on the principal/mirror or both?
March 4, 2012 at 3:27 am
newbie_DBA (3/3/2012)
can i perform this command on a live DB with no issues? and i should run it on the principal/mirror or both?
This should be dynamic, execute this on the principal instance to extend the timeout value
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply