AlwaysOn – HADRON Learning Series – Automatic Page Repair Increases SQL Server High Availability (HA) Capabilities

WARNING:  The series is based on pre-release software so things could change but I will attempt to provide you with the best information I can!  The enterprise edition of SQL Server has provided page level repair for quite some time now.   For those not familiar with page level repair allow me to provide a brief…


AlwaysON – HADRON Learning Series – Running DBCC On A Secondary

HADRON allows DBCC to be executed directly against a secondary replica.  The DBCC can be run online, as is, or with TABLOCK if the HADR activity is suspended so the DBCC can acquire the database lock necessary to support the TABLOCK option. A secondary that allows connections enables the administrator to execute DBCC CHECKDB.   The…

5

AlwaysON – HADRON Learning Series – New DMVs

As I have been reviewing and learning about HADRON I have found a great wealth of information exposed in the DMVs.  I have pulled together a starting, entity relationship diagram and the HADRON PMs have been helping me refine it.  We continue to update it for changes but I thought you would find it helpful…

6

AlwaysON – HADRON Learning Series – What Is HADRON?

I have been reviewing and working on supportability aspects of HADRON (High Availability Disaster Recovery – AlwaysON) for months and I am kicking off a blog post series related my ‘HADRON Learning Series’ which I am putting together for the SQL Server support team. You can download CTP1 and try it yourself:  http://www.microsoft.com/downloads/en/details.aspx?FamilyID=6a04f16f-f6be-4f92-9c92-f7e5677d91f9&displaylang=en  AMAZING: Just…

4