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

HOW IT WORKS: IO Affinity Mask – Should I Use It?

The IO Affinity mask question has come across my desk several times in the last week so it is time to blog about it again. The IO Affinity mask is a very targeted optimization for SQL Server.  I have only seen 6 cases where the use of it improved performance and was warranted.  It is…

3

Microsoft Atlanta Begins….

There is an incredible level of satisfaction in being able to turn an idea into something real. Something valuable. Years go at Microsoft I talked to my colleagues about a vision where we could provide our knowledge in CSS using online technologies instead of having customers struggle to find KB articles on the web. Provide…

3

The week that was PASS…

I’m sitting in SEATAC Airport waiting for my flight, so I thought now would be a great time to write up some thoughts and share some experiences of my week at PASS.  There was a ton of great information this year and we also announced Denali – the next version of SQL Server!  From what…

0

CSS once again comes to the SQL PASS Summit

I’m proud once again to be a part of our CSS team coming to the US SQL PASS Summit next week in Seattle. As in the past, our team will be speaking at a pre-conference seminar, main conference talks, and available to talk to you in person at the SQL Server Clinic. Here is a…

3

How It Works: SQL Parsing of Number(s), Numeric and Float Conversions

        SQL Server and other documentation have always indicated that float values are not precise and comparison or conversion of them can be problematic and imprecise.   Working on a recent customer case it required me to dig into the single/double precision point format as well as SQL Server NUMERIC format and handling.     The application…

3