If you look at sys.dm_exec_requests you can see what the process is currently waiting on. You can also get a link to what locks are being held by the...

It's hard to know for sure in these situations without a lot more detail. In general, I'd assume an issue with statistics and/or blocking. You say no other processes were...

Let me try:

Hadoop

Ellison

Database Tuning Advisor

Nope. It's broke.

Ninja's_RGR'us (12/2/2011)

---

Grant Fritchey (12/2/2011)

---

I'm glad you brought it...

I'm glad you brought it up. I've been...

Personally? A week. I like to be able to see the rise...

First suggestion I have, bump up your cost threshold for parallelism to 40 or 50. You're getting parallel execution on this plan with an estimated cost of 25, and I...

The optimization on the plan is Full, so this is a good plan. That suggests that that principal problem is with your statistics, not the structure of the query (to...

That is a particularly hairy execution plan.

There a few issues. First, it looks like your statistics might be off. Down in the really nasty part of the plan estimated row...

With bare metal all you can measure is potential. SQLIO is the way to go.

However, if you're consolidating, measure the other servers before you start moving stuff onto the new...

Full backups don't affect log backups in that way. They only affect differential backups. If that's not part of your restore strategy, then you're fine.

Second vote for PowerShell. I'm pretty sure Allen White has a script over here somewhere.

Although, you can see an aggregate history of the executions in cache. If you look at sys.dm_exec_query_stats you can find an aggregation of performance metrics for any query still in...

Kiara (12/1/2011)

---

Brandie Tarvin (12/1/2011)

---

Hey, guys. Is Gus gone yet?

GSquared (12/1/2011)

---

- GSquared, RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF,...

GSquared (12/1/2011)

---

My wife and I are celebrating our 21st anniversary today. As part of that, I'm taking next week off of work (my third vacation since 1988), and probably...