Join the SQL Server Tiger team for a Twitter Chat on Monday, June 27th from 10 -11 AM PST. You can ask anything about Query Performance on SQL Server for our first Twitter chat.
Log on at the time above, make sure to include #AskSQLTiger in every Tweet you make, and you’ll be part of our discussion. Or, follow this link to see the #AskSQLTiger feed. Tools like TweetdDeck, HootSuite can be helpful in following along in a Twitter Chat. Members of the @mssqltigerwill be moderating the discussion.
I recently delivered a session for High Availability and DBA Fundamentals on June 14th about the recent High Availability and Disaster Recovery enhancements that were delivered/to be delivered in recent Service Packs of SQL Server. The session recording is available on YouTube, the slide deck is available on Slide Share and the demo scripts along with the Power BI dashboards are available on GitHub
SQL Server 2012 Service Pack 3 and the upcoming SQL Server 2014 Service Pack 2 provide extended events which helps track down two of the most common issues that DBAs have to cope with during an outage situation related to Availability Groups: Latency and Lease Timeouts (which could result in failovers). These new extended events have been shipped based on customer feedback that we heard, acted up and shipped. If you have an Availability Group setup, then come learn about the new enhancements shipped with SQL Server 2012 Service Pack 3 and the upcoming SQL Server 2014 Service Pack 2 and above which allows you to troubleshoot failovers more easily and pin point the latency in your environment more efficiently.
TroubleshootingSQL 