Brandie Tarvin (7/28/2011)

---

Ninja's_RGR'us (7/28/2011)

---

Wow that's so nice. I had heard about it but never played with it. It's like the Loch Ness Monster, so glad I finally saw...

Got it //

Source link : http://sqlfrndz.com/2011/06/09/activity-monitor-script-to-find-head-blocker-sql-server-2005-2008-and-later/

Schadenfreude-Mei (7/28/2011)

---

Ninja's_RGR'us (7/28/2011)

---

Michael Valentine Jones (7/28/2011)

---

I have had people on my team that are full time work from home for the last 10 years, and I am happy with the...

Now this is getting expansive :w00t:!

Here's a script I recently found here (sorry didn't save the credits so I can't give the original url).

It gives you the head blocker and way more info on what's...

Find out what the query is waiting on.

Figure out a way for that process to work faster or not during prod hours or not at all.

Michael Valentine Jones (7/28/2011)

---

I have had people on my team that are full time work from home for the last 10 years, and I am happy with the situation.

We are...

ajsnyman (7/28/2011)

---

Ninja's_RGR'us (7/28/2011)

---

Not...

I can say it's the same as access. But I've not used other RDBMS.

That's over 5 minutes of blocking. Is someone [re]building an index or something like that?

Not really cool...

ChrisM@Work (7/28/2011)

---

Walton (7/27/2011)

---

Thanks Brandie.

I think i need to go with the option 1. But I am curious about the hidden ansi character. Would you please explain what is ansi hidden...

SQLkiwi (7/27/2011)

---

I humbly suggest this:

http://www.simple-talk.com/content/article.aspx?article=1250

A detailed discussion of CXPACKET will be in a future instalment. ...

Not really but I for 1 has never done this, at all (that way). And I don't have a sql 2000 instance to play with.

Moreoever this is a sql...

Won't work if you try to "force" or "coerce" him.

Long story...