1

Can I get some help on below

As I have started and learning about the Measuring of Availability Group synchronization lag between replicas inclusive of BCP , I want to understand and learn that does this query or dashboard show the values including FileStream synchronization lag ?

My Databases are with FileStream enabled . I am using SQL Server 2014 SP2 AOAG.

Please help me understand the above point and kindly advise me with good link or query to measure the Sync lad between replicas.

Improve this question
2
  • May I know why the question was down marked ? is it formatting or the content I asked ? I want to be aware of for future usage of DBA Stack exchange.
    – Learning_Learning
    Mar 4, 2019 at 16:57
  • You may want to update your statements with the query you're talking about or a screenshot of the dashboard to show what you're referencing and what your specific question is about.
    – Sean Gallardy
    Mar 4, 2019 at 22:38

1 Answer 1

Reset to default
0

I learned that the AG Dashboard is made up using the sys.dm_hadr_database_replica_states results . Thanks for all help.

I got an answer what I am looking for :

filestream_send_rate (bigint )

The rate at which the FILESTREAM files are shipped to the secondary replica, in kilobytes (KB)/second.

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.