Hello,

My Windows 2008 R2x64 server is running a SA11.0.1.2627 database server in High Availability.

This server is responsible for 3 different databases.

Sometimes, a specific primary database freezes and no one can connect to it. The other 2 databases work as usual!

If I connect to the mirror database, it works in read-only mode as expected fo all 3 databases.

The only thing that I can do to recover the primary database activity is SHUTTING DOWN the MIRROR database (just the "problematic database" is enough).

It looks to me that the primary database keeps waiting some kind of response from mirror database and this response never happens.

The only thing I have noticed is that the the Console Log File stops logging the CHECKPOINT event for the frozen database.

This problem is happening on Production and Development environments. The Development database is NOT in use by any application.

My development database is frozen at this moment.

I´d like to know if there is any command that I can run against the Mirror database to discover the root cause of the freeze.

The connection timeout between Primary and Mirror databases is set to 1 second.

Thank you.

asked 08 Aug '11, 16:25

Thiago%20Reis's gravatar image

Thiago Reis
3066918
accept rate: 40%


We need to know what the threads in the hung servers are doing to be able to resolve this. I recommend you open a technical support case. We probably need full minidumps for the primary and ideally also for the mirror to determine what they are doing. You can use visual studio to create minidumps, or if you don't use visual studio, I have used the sysinternals procdump tool in the past (-ma creates a full dump).

permanent link

answered 09 Aug '11, 09:20

Ian%20McHardy's gravatar image

Ian McHardy
3.1k23353
accept rate: 39%

Thank you very much. I´ll open a technical support case and ask some help to generate the minidumps.

(09 Aug '11, 09:35) Thiago Reis
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×137
×54

question asked: 08 Aug '11, 16:25

question was seen: 878 times

last updated: 09 Aug '11, 09:35