RE: How to find the stored procedure causing performnace problem

SSC Guru

Points: 323504

June 7, 2011 at 5:52 am

thanks for the clarification Gail!

you said "... If a plan is never cached, it won't appear in the query stats DMV at all...", can you clarify?

I thought every query got a query plan that is created and thus was cached, but might not ever be reused by another subsequent sql, due to ad hoc char by char differences and stuff...can you think of an example where a plan doesn't get cached at all?

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!