1 / 11

SQL Server 2012 AlwaysOn and SQLSentry

SQL Server 2012 AlwaysOn and SQLSentry. Kevin Kline Director of Engineering Services, SQL Sentry SQL Server MVP since 2004 Twitter, FB, LI: KEKline Blog: http://KevinEKline.com , http://ForITPros.com. Agenda. The Basics. Inherits from DBM: Sync / Async data protection

adrina
Download Presentation

SQL Server 2012 AlwaysOn and SQLSentry

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. SQL Server 2012 AlwaysOn and SQLSentry Kevin Kline Director of Engineering Services, SQL Sentry SQL Server MVP since 2004 Twitter, FB, LI: KEKline Blog: http://KevinEKline.com, http://ForITPros.com

  2. Agenda

  3. The Basics • Inherits from DBM: • Sync / Async data protection • Automatic or manual failover • Automatic page repair • Compressed data stream • TCP endpoints • With WSFC: • Does NOT require instances to be Failover Cluster Instances (FCIs) • Does NOT require that servers start out as clustered if using standalone instances • Database-level protection • Built upon the foundation of database mirroring • Requires a Windows Server Failover Cluster. • Availability Groups (AGs) are what most people mean when they say “AlwaysOn”

  4. What Does WSFC Mean for a DBA? • You need to know WSFC very thoroughly. • Quorum matters. • Nodes must be part of the same domain. (Different subnets are ok). • Quorum matters. • WSFC validation is very important. • AG feature doesn’t check like in setup for FCI • It’s on YOU to check it. • %windir%/Cluster/Reports • Apply hotfixes per Windows version • Quorum matters.

  5. I Know Mirroring. How’s This Different? • Enterprise Edition only. DB in full recovery mode only. • Not a 1:1 ratio of principals to mirrors. Per AG: • Up to 4 additional replicas, for a total of 5 • Up to 3 synchronous replicas • Up to 2 automatic failover pairs • Multiple DBs in an AG will failover at the same time.*** • Easily span subnets. • Replicas usable for read-only access and backups.

  6. Availability Groups Fundamentals o

  7. Flexible Failover Policy Levels Damaged databases and suspect databases? Nope, not detected by any failure-condition level.

  8. AG Metadata • SSMS (in demo) • DMVs: • sys.availability_* • sys.dm_hadr_* • Xevents • SP_server_diagnostics: checks the health_check_timeout value in 30 second intervals, by default.

  9. Additional Resources • Plan Explorer Free: http://sqlsentry.net/plan-explorer/sql-server-query-view.asp • Twitter and #SQLHelp • SQLCAT.com • SQLSkills.com • Community Sites: • SQLPASS.org • SQLServerCentral.com • SQLBlog.com • SQLTeam.com

  10. SUMMARY • SSMS, Traces, and Execution Plans • Test Harness & Testing • Query Tuning Tips • Temp tables • Cursors & Loops • NULL • Error Handling • Transactions • Security isn’t an afterthought • Change Management is risk management

  11. Q & A • Send questions to me at: kkline@sqlsentry.net • Twitter, Facebook, LinkedIn at KEKline • Slides at http://KevinEKline.com/Slides/ • IT Leadership content at http://ForITPros.com • THANK YOU!

More Related