Tracking database recovery progress using information from DMV

Technorati Tags: Engine,SQL Server 2008 You must be very familiar with the database recovery related messages printed to the SQL Server Error log. These come in very handy when troubleshooting issues that are related to long recovery. These messages provide information about the stage of the recovery process and approximate time for completion. 2010-12-29 12:02:10.43…

5

How It Works: Error 18056 – The client was unable to reuse a session – Part 2

I have had several questions on my blog post: http://blogs.msdn.com/b/psssql/archive/2010/08/03/how-it-works-error-18056-the-client-was-unable-to-reuse-a-session-with-spid-which-had-been-reset-for-connection-pooling.aspx related to SQL Server 2008’s honoring of an query cancel (attention) during the processing of the reset connection.  This blog will augment my prior post. Facts You will not see the sp_reset_connection on the wire when tracing the network packets.   It is only a bit…

1

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