Post reply

Amount of data

  • October 26, 2016 at 7:27 am

    #314431

    Is there a way to find out "amount of data" sent over to the DR Database through SQL?

    Database sync is done through mirroring...

  • October 26, 2016 at 8:07 am

    #1908902

    I think if you determine the number of changed pages, you'll have the amount of data being sent over. Paul Randall has written an article to determine how much is changed[/url]. Allthough Paul uses it for different purpose it should give you a good indication for the amount of data being transferred.

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **

  • October 26, 2016 at 8:27 am

    #1908914

    For mirroring there's a perfmon counter, "Log Bytes Sent/sec" that exists for each database. Despite the "/sec", it's a cumulative counter (Perfmon just automatically does the calculations for you).

    You could just query that at intervals (in sys.dm_os_performance_counters) to see how much log was sent from principal to mirror for each DB.

    Cheers!

  • October 26, 2016 at 9:19 am

    #1908924

    Thanks Everyone!

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply