I actually missed that...

Jack Corbett (4/17/2009)

Which is...

You can try joing to dm_exec_plan_attributes and see if the user_id is available for the plans you're interested in. It might not be.

It broke 60 here in the Peoples Republic. Looking good for camping this weekend (although it's going into the 30's over night). I'll be sleeping comfortably in my Hennessy Hammock[/url]...

Not a trigger for monitoring, use a server-side trace.

I'd suggest looking into the waits & queues. Use this white paper from MS.

I completely glossed over the test instance thing on the first read. Yeah, that's a bad idea. You can seriously mess up your environment that way. Testing and development should...

Parallelism, no. Memory yes.

There has to be a difference somewhere. Are they on the same service pack and hot fix #?

If it's considered a trivial execution plan, it won't cache the plan that's created. That looks like a plan that is likely trivial.

BTW, you're posting in the 2008 area for...

If you have multiple plan handles, have you looked at the plans? For the same query, you'll get two plans when parallelism is invoked.

What about the parameters?

Does one of the servers have a different parallelism threshold than the other? How about the parallelism setting? ANSI connection settings? Um, memory allocations, any other kinds...

If I understand the question, you can this to your code

...

--Previous parts of a procedure

SET STATISTICS IO ON;

EXEC something;

SET STATISTICS IO OFF;

--The rest of the procedure

...

Another advantage worth considering are licensing costs. Once you've paid for SQL Server and have it running on a given machine, you can create instances to your hearts content. If...

There's a chance, just a chance, that the queries could still be in the cache. Try querying sys.dm_exec_sql_text to see if you can find the query. From there you can...

Excellent. Glad I could help. And thank you for posting the solution. I hate wondering what worked.