InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 18 Jun 2013 15:46:26 GMT20http://www.sqlservercentral.com/Forums/Topic1350697-1452-1.aspxNice article Perry, very informative. Maybe you can help me with a question I have. I'm looking for a way (in a DMV) to see how far the secondary replica has fallen behind under heavy database load (inserts, updates, deletes) on the primary. In other words, is there a way to see how many transactions the secondary needs to apply so it is caught up and in sync with the primary?Also, is there an easy way to measure the overhead cost of using sync compared to async?Tue, 05 Mar 2013 13:25:33 GMTDustin W. Joneshttp://www.sqlservercentral.com/Forums/Topic1350697-1452-1.aspxHi, Have you guys experience where when you failover the AG, the clients do not pickup the new IP address and so cannot connect.See related link: http://social.msdn.microsoft.com/Forums/en-US/sqlhadr/thread/34e100db-a340-429d-b42a-41cdd8d4e09bThis decribes what is basically happening to us. We've setup a TEST environment to check out the AG stuff and this is the biggest problem we're having so far. I'm unable to find a bug number or anything on MS website. TIASteveWed, 03 Oct 2012 14:52:55 GMTSteve Thttp://www.sqlservercentral.com/Forums/Topic1350697-1452-1.aspx[quote][b]DanOrc (8/29/2012)[/b][hr]Very nice![/quote]Thank you very much for your kind feedback, please don't forget to rate the article if you found it useful.Wed, 29 Aug 2012 23:45:12 GMTPerry Whittlehttp://www.sqlservercentral.com/Forums/Topic1350697-1452-1.aspxVery nice!Wed, 29 Aug 2012 22:44:26 GMTDanOrchttp://www.sqlservercentral.com/Forums/Topic1350697-1452-1.aspx[quote][b]Ken Davis (8/28/2012)[/b][hr]Thanks for this article. It may be a while before my company is ready to use AO groups but I will definitely refer to your article when that time comes![/quote]Thanks for the feedback, please don't forget to rate the article if you found it useful :-)Also feel free to add it to your SSC briefcase ;-)Tue, 28 Aug 2012 13:52:56 GMTPerry Whittlehttp://www.sqlservercentral.com/Forums/Topic1350697-1452-1.aspxThanks for this article. It may be a while before my company is ready to use AO groups but I will definitely refer to your article when that time comes!Tue, 28 Aug 2012 13:26:46 GMTKen Davishttp://www.sqlservercentral.com/Forums/Topic1350697-1452-1.aspxLol you are way to kind, once again thank you.Btw keep an eye out for my article detailing how to combine failover cluster instances of SQL server with AlwaysOn availability groups, out on 4th SeptTue, 28 Aug 2012 07:10:53 GMTPerry Whittlehttp://www.sqlservercentral.com/Forums/Topic1350697-1452-1.aspx[quote][b]Perry Whittle (8/28/2012)[/b][hr]Thanks for the feedback, please don't forget to rate the article if you found it useful :-)[/quote]Rated it as 5 stars because that was the limit (it actually deserves more than that:-)).Tue, 28 Aug 2012 06:29:44 GMTDivine Flamehttp://www.sqlservercentral.com/Forums/Topic1350697-1452-1.aspxThanks for the feedback, please don't forget to rate the article if you found it useful :-)Tue, 28 Aug 2012 06:19:01 GMTPerry Whittlehttp://www.sqlservercentral.com/Forums/Topic1350697-1452-1.aspxVery nicely written. Thanks for sharing :-)Tue, 28 Aug 2012 05:31:38 GMTDivine Flamehttp://www.sqlservercentral.com/Forums/Topic1350697-1452-1.aspxComments posted to this topic are about the item [B]<A HREF="/articles/AlwaysOn/91408/">AlwaysOn Availability Groups in SQL Server 2012</A>[/B]Tue, 28 Aug 2012 00:02:15 GMTPerry Whittle