You will then have to dig further and see which ones are close to your requirement. That would give you all extended events related to AlwaysOn AG. The primary switches to Asynchronous-commit temporarily for that particular secondary and when it reconnects fine, the synchronous-commit mode is resumed.Īs for your question, I'd start with DMV sys.dm_xe_objects and filter by Just an FYI- AG replicas ping each other to ensure they can talk to each other (Heart-beat) and if primary doesn't get a ping response from the secondary replica within the specified session-timeout period (default is 10 seconds unless changed manually), Looking for some event based automation which will check in a real time if there is latency and switch back and forth between the Sync and Async. Shashank Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it Wait till someone responds regarding that, or if you like I can move the thread to service broker forum Yep service broker can be the thing but its shame that I do not know much about that. A good example of event based approach of the blocking event where we can use the service broker which can fire our proc as soon as there On this event, would like to trigger the stored procedure to revert from sync to asynch. I would like any kind of even to be generated when the latency goes higher, say 5 seconds. Precisely, do we have any event mechanism that we can use instead of using the job. I could work on the scripts to automate the process using DMV (sys.dm_hadr_database_replica_states) to query the column Secondary_Lag_Seconds through a job.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |