September 20, 2016 at 2:29 pm
I'm in a new environment and never dealt with Always On before. I've been reading BOL since yesterday and looking up as much as I can, but stumped on where to start. I'm getting a agent notice regularly regarding -
'The SQL Server performance counter 'Transaction Delay' (instance '_Total') of object 'Database Replica' is now above the threshold of 3000.00 (the current value is 3615.30).'
I have used some dmv's I found and all I can say it is 'Synchronous_Commit' and it shows healthy, but trying to figure out why I keep getting the agent message.
Any suggestions on where to start looking would be appreciated!
Thank you,
September 20, 2016 at 3:05 pm
In simple terms the Synchronous commits are taking too long, i.e. over 3000ms. This will probably also be seen as degraded performance for your users/application.
Check the latency between the servers. Also check how busy the Primary Server is, and if there are more transactions that need to be replicated than the network capacity can handle.
A quick fix is to set the replication to Asynchronous. Depending on what is causing the problem there are a number of other tricks to reduce the replication load.
Cheers
Leo
Nothing in life is ever so complicated that with a little work it can't be made more complicated.
Leo
Nothing in life is ever so complicated that with a little work it can't be made more complicated.
September 21, 2016 at 8:35 am
Thank you and I will investigate your suggestions.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply