What statement does it hang on?

What does that statement do?

If you run that statement separately, what happens?

Is it waiting for a file?

What are the wait types involved?

What state is that...

Oooh, another case for the crystal ball. Or maybe the magic 8-ball...

http://www.sqlservercentral.com/Forums/Topic1586405-2799-1.aspx

Magic 8-ball says "unknown"

cross apply that DMV to sys.dm_exec_sql_text, that DMV has the objectID and database (for procedures), you can join that to sys.objects/sys.procedures.

Ad-hoc queries have neither an object ID or database ID...

Backup, copy, restore can work. You can restore as a different name then swap the old and new databases very quickly.

Log shipping will result in a read-only database at...

Please post table definitions, easily usable sample data and expected results, as per http://www.sqlservercentral.com/articles/Best+Practices/61537/

If you can...

Take a read through these:

http://www.sqlservercentral.com/articles/Indexing/68439/

http://www.sqlservercentral.com/articles/Indexing/68563/

http://www.sqlservercentral.com/articles/Indexing/68636/

Koen Verbeeck (6/25/2014)

---

To be honest, Craig stole it from me when...

jcrawf02 (6/25/2014)

---

Ed Wagner (6/25/2014)

---

Yeah, really. When it gets out of the shop, I'd like to be added to the rotation. I'll even volunteer do the testing to make...

You need either a time machine or some existing, custom auditing for logins to have been in place for a year.

So, which are you trying to do? Catch long-lasting blocking scenarios (for which the blocked process report will work)...

Please post new questions in a new thread. Thank you.

Selects don't block selects, so the queries you ran shouldn't have triggered a blocked process report, they wouldn't have blocked each other.

What are you trying to do, detect deadlocks or...

You're the only one who can say if they're high, because 'high' is a sustained value over what's...