August 18, 2014 at 1:07 am
Hi Experts,
How to find the pending transactions to be applied on secondary in Always On? Can i get those details from dashboard?
August 19, 2014 at 3:48 am
There are a host of extra columns available in the dashboard view. They are
Log send queue size (kb)
Log send rate (KB/sec)
Redo queue size (kb)
Redo rate (KB/sec)
Estimated data loss (time)
Estimated recovery (secs)
There are also a number of LSN based info columns. Open the dashboard and right click any one of the column headers and a pop up menu will appear. Select any columns you require, of course you could also get this information by querying the DMVs\system catalogs.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 21, 2014 at 4:36 am
Thanks Perry.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply