Thanks Gail for the response.

Checkpoint makes no difference.

Certainly in one case, there is NO activity on the database; it is database that I set up to test mirroring and I...

Thanks Steve.

It is at least re-assuring to know I am not the only one; I had not found anything similar by doing a web search.

All the standard texts just say...

Thanks for the reply, Michael.

That is very reassuring.

Cheers

Glenn

I think I might have answered my own question.

Neither of the following two Microsoft articles:-

"How to: Upgrade a Database Using Detach and Attach (Transact-SQL)"

http://msdn.microsoft.com/en-us/library/ms189625(v=sql.105).aspx

"How to: Restore a Database...

Michael

Did you ever get an answer to this?

I am in a similar postion. We have a SQL2000 installation to SP3a.

I want to do a side-by-side upgraded to SQL2008R2.

I can't see...

Sorry about the delay.

I was out of the office yesterday and had a bit of catching up to do.

What I discovered when I tried to put my analysis together in...

Update ...

I started to put a spreadsheet together with my analysis - and in the process of doing that discovered some results I had forgotten that might help me. I...

Sorry about the typo. Of course I meant "head of the blocking chain" not "head of the blocking machine".

Initially I was trying to make my question as succinct as possible. But sorry if you think I was withholding useful information.

The only DMVs for which I have a full...

I do have a snapshot of dm_os_waiting_tasks at the time of the problem. The wait_type is LOCK for all 21 rows (LOCK_M_S, LOCK_M_U or LOCK_M_X).

The wait durations of all (8)...

What other information would be helpful?

Thanks again for the quick reply.

I do have the full output from dm_tran_locks. But my suspicion is that the 'hobt_id's have changed in sys.partitions due to our index rebuild.

I still...

Sorry, I misunderstood your question.

There are ...

7 PAGE waits

14 KEY waits

Not easy to map back this back to object names. The 'resource_associated_entity_id's no longer exist (as...

The head of the blocking chain is not waiting on any resource - i.e. waitresource in sysprocesses is blank. The process is sleeping, awaiting command.

Thanks Grant.

Some details about the process at the head of the chain:-

- According to sysprocesses, it is not being blocked by anything (blocked=0).

- Its (status,command,lastwaittype) is ('sleeping', 'AWAITING COMMAND', 'MISCELLANEOUS').

-...