Jerry

Relic

Maybe somebody will be along later to correct the answer???

Wait to...

American

I'd love to go. I hope to be in attendance and maybe see some people there.

rock

Agreed. That is one of the biggest problems with ad-hoc queries. I have a client with a much higher ad-hoc cache than what you are seeing.

They were used at least twice. Anything not used more than once will retain the stub. Upon being used a second time, the stub is replaced with an...

Greg Edwards-268690 (1/31/2012)

Shows what happens when I think - other people...

It sounds like you have a ton of multi-use ad hoc queries, hence minimal benefit.

I too see this as more of a tool that will be used for abuse. Then again, there will probably be plenty of happy people entering their data. ...

You replied while I was updating my reply. Check the rest of my last post. 🙂

What is the value for Compiled Plan Stub?

You can still get Cache bloat from ad-hoc plans. It should be less than before. This setting is mainly to help...

It's a mix for me. I sometimes use paper and pen (not pencil) or I will type them electronically on laptop, phone or something - it depends on the...