It's as the Ninja & Gail says, a plan is neither good nor bad, per se. It's the statistics, the structure, and your query, that drive what kind of plan...

goofy2sql (11/21/2011)

---

I am trying to figure out If the problem is with SQL or memory. Since there is 11GB of memory I dont see memory problem but processor queue length...

Jack Corbett (11/21/2011)

---

Hey, for those not on Twitter (why aren't you). My dad passed away early this morning. Not unexpected. I blogged about it, http://t.co/hCjjRnRh if you...

Yeah, got those here.

Wibble

CPU & IO pressure are different. I'd need a lot more information to make even vague suggestions.

Lexa (11/21/2011)

---

Grant Fritchey (11/21/2011)

---

Lexa (11/20/2011)

---

Grant Fritchey (11/20/2011)

---

Try getting the execution plan when it's slow and when it's fast. Compare the two. It could be bad parameter sniffing.

But to be...

Wibble.

The only number in there that means anything without a comparison to other numbers is the processor queue length. A length of 16 suggests you might have some CPU conflicts...

I'd suggest using Gail's second choice there. Most shops I've worked in set the logs to cycle. Of course, maybe that's true because I'm the one that sets them to...

Lexa (11/20/2011)

---

Grant Fritchey (11/20/2011)

---

Try getting the execution plan when it's slow and when it's fast. Compare the two. It could be bad parameter sniffing.

But to be honest, it sounds...

bridgt01 (11/20/2011)

---

Grant, I didn't write this code but I'm not seeing a WHERE clause against the multi-statement table valued function.

As for updating stats, stats have been updated and indexes have...

I've been working with Red Gate tools for 10 years now. I've been working for the company for the last nine months. I liked their software so much I went...

Try getting the execution plan when it's slow and when it's fast. Compare the two. It could be bad parameter sniffing.

But to be honest, it sounds like contention. Have...

ggpevans (11/19/2011)

---

Hello, I have searched far wide on two topics, with no luck.

The two topics are

a) Relationships

b) Joins (Inner joins and cross joins etc)

I understand that...

Sounds like some seriously large queries and/or some processing occurring within queries that is excessively large. Based on what you've provided, it's hard to say what. I'd suggest setting up...