TheSQLGuru (10/24/2008)

---

Can you please tell us which bug it was in CU9 that was causing the problem? I checked and cannot find any FIX from that update dealing with...

Not sure if this was mentioned in this thread, but are index stats up-to-date and is index fragmentation at low levels?

The optimizer can make the wrong choices if stats is...

I will talk to the developers about the way this has been coded. Doesn't look like the cursor and dynamic SQL are strictly necessary, although it is not easy to...

Grant Fritchey (5/10/2009)

---

...

So, you said it was a very large query. Is it dynamically building strings that might exceed 8kb?

It's also possible that it can't show the plan in XML...

Here is the plan (see attached). I have tried to obfuscate object names as much as possible, and, in doing so, I hope I have not messed up anything system-specific.

Here...

andrew gothard (5/9/2009)

---

Marios Philippopoulos (5/8/2009)

---

Grant Fritchey (5/8/2009)

---

Actually, if it's still in sys.dm_exec_sql_text and in sys.dm_exec_query_stats, then it's still in cache. It hasn't aged out yet. If it were not in...

andrew gothard (5/9/2009)

---

Marios Philippopoulos (5/8/2009)

---

Grant Fritchey (5/8/2009)

---

Actually, if it's still in sys.dm_exec_sql_text and in sys.dm_exec_query_stats, then it's still in cache. It hasn't aged out yet. If it were not in...

Grant Fritchey (5/8/2009)

---

Actually, if it's still in sys.dm_exec_sql_text and in sys.dm_exec_query_stats, then it's still in cache. It hasn't aged out yet. If it were not in cache, then not only...

It would have been great if SQL Server...

Grant Fritchey (5/8/2009)

---

How long since the last execution did you query the dmv's? If it's hours or minutes, you may have a serious memory issue. If it's days or weeks......

andrew gothard (5/7/2009)

---

No, plans get aged out if there is no more memory available in plan cache due to the need to hold plans for more recently used queries. ...

David Benoit (5/5/2009)

---

Nope, should be just one unless you execute one specifically 🙂 . The checkpoint should occur pretty quickly as noted in the one perfmon counter earlier discussed. If...

SQLBOT (5/4/2009)

---

Sorry,

I fell asleep at the wheel on this thread.

The checkpoint process should always be running somewhere, or in the state 'checkpoint wait'

There are many activities that automatically initiate a...

GilaMonster (5/4/2009)

---

Not sure either. I just hauled a plan out...

I'd love to but don't want to get in trouble. 🙂

It's odd, this proc is...